Re: page margin
From: Bob Brannon (bbran_at_3rivers.net)
Date: 01/27/05
- Next message: Mariel: "Open a report based on different queries"
- Previous message: Fons Ponsioen: "RE: Counting based on a conditional expression"
- In reply to: Allen Browne: "Re: page margin"
- Next in thread: Allen Browne: "Re: page margin"
- Reply: Allen Browne: "Re: page margin"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 Jan 2005 10:47:15 -0700
Hello Allen,
The problem was I didn't know what you meant by the "Immediate Window". I
see now it is part of the VB window, which I have rarely used, but had
gotten to it a few days ago already. Sorry for the confusion.
Anyway, I tried what you said and the bottom margin still cannot be
adjusted. Any idea what that problem might be? By now I could have spent
less time just copying my other report and modifying the copy. However,
that would not provide a solution to the problem, just a work around. Now I
am really interested in figuring out the problem.
Any other suggestions?
Regards,
Bob Brannon
"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:%23Xb9M8ABFHA.4008@TK2MSFTNGP09.phx.gbl...
Sorry, Bob. SaveAsText is an undocumented VBA command.
It creates a text file containing your object (in this case your report.)
You can then import it into another database with LoadFromText.
To use it:
1. Open the Immediate Window (Ctrl+G).
2. Type in the command, and press Enter.
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Bob Brannon" <bbran@3rivers.net> wrote in message news:%23XlNdk8AFHA.1408@TK2MSFTNGP10.phx.gbl... >I must be dense, how do I get to this "SaveAsText acReport"? > > When I try Save as from the file menu a window comes up with the "as" > grayed > out but set on report. Would this be because the report asks for some > data > before it runs? > > > "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message > news:%23COFcJwAFHA.2156@TK2MSFTNGP10.phx.gbl... > Regarding references, you cannot remove VBA or Access libraries. > You probably want to keep the DAO one. > The other 2 are usually not needed. > More info about references: > http://members.iinet.net.au/~allenbrowne/ser-38.html > > If the problem with the huge bottom margin applies to only the one report > (not to a new report, for example), here's another alternative. > 1. Open the Immediate Window (Ctrl+G). > > 2. Enter something like this, replacing Report1 with the name of your > report: > SaveAsText acReport, "Report1", "C:\Report1.txt" > > 3. Delete the report. > > 4. Compact the database. > > 5. Open the Immediate window, and enter: > LoadFromText acReport, "Report1", "C:\Report1.txt" > > SaveAsText and LoadFromText are undocumented, but can sometimes recover a > bad object. > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia. > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. > > "Bob Brannon" <bbran@3rivers.net> wrote in message > news:%23dPyt$uAFHA.3504@TK2MSFTNGP12.phx.gbl... >> OK, I was able to get to the Code window before then but I do not know >> what >> you mean by setting minimal references. The only ones checked are: >> >> VB for apps >> Access 9 obj lib >> DAO 3.6 obj lib >> OLE auto. >> VB for apps extensibility 5.3 >> >> Should I uncheck all these? >> >> And, on you web page for recovering from corruption you say the process >> will >> cease at step 5 and see the name of the object that did not import. What >> is >> the process that will cease? I was able to import the report whose >> margin >> I >> cannot reset but I can't reset it in the new database either. >> >> >> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message >> news:eITEsdnAFHA.2540@TK2MSFTNGP09.phx.gbl... >> Press Alt+F11 to open the code window. >> Alternatively, press Ctrl+G to open the Immediate window (which opens in >> the >> code window). >> >> Once you are there, you will find References on the Tools menu. >> >> -- >> Allen Browne - Microsoft MVP. Perth, Western Australia. >> Tips for Access users - http://allenbrowne.com/tips.html >> Reply to group, rather than allenbrowne at mvps dot org. >> "Bob Brannon" <bbran@3rivers.net> wrote in message >> news:u4A8qDlAFHA.2604@TK2MSFTNGP10.phx.gbl... >>> Sorry for the confusion if I caused any, the step 5 I was referring to >>> was >>> your step 5 in the web page you reference for recovering from corruption >>> with a form or report that won't open. >>> >>> I'm not sure how to get to the code window, but if I have I don't know >>> what >>> you mean by "setting minimal references" or how the corrupt report will >>> show >>> up. >>> >>> >>> "Bob Brannon" <bbran@3rivers.net> wrote in message >>> news:egJeL$kAFHA.2016@TK2MSFTNGP15.phx.gbl... >>> How do you do step 5 that you referred to in your earlier response. I >>> don't >>> know how to get to that code window you referenced. >>> >>> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message >>> news:uwaeZjbAFHA.1564@TK2MSFTNGP09.phx.gbl... >>> If you have another report you could use, just: >>> 1. Delete the report. >>> 2. Compact. >>> 3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V). >>> 4. Open the copy in design view, and change the RecordSource. >>> >>> It's worth persuing the process that gets Access to rebuild the database >>> for >>> you. I end up using that about once a month with different people's >>> databases. >>> >>> -- >>> "Bob Brannon" <bbran@3rivers.net> wrote in message >>> news:%23OIwGKbAFHA.2076@TK2MSFTNGP15.phx.gbl... >>>> All the name autocorrect options are already turned off. However, I >>>> compacted, copied, pasted, renamed adn still could not change the >>>> margin >>>> of >>>> the copy. >>>> >>>> I have another report that is exactly the same but uses a different >>>> cirteria >>>> for the data reported, so I could probably just copy that and make the >>>> changes. >>>> >>>> I am not sure how to follow your recover from corruption process. >>>> >>>> >>>> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message >>>> news:ePCkzz2$EHA.2880@TK2MSFTNGP14.phx.gbl... >>>> All printers have an unprintable area at the bottom, but 1" should work >>>> fine. >>>> >>>> If you are able to create another report and set the bottom margin to >>>> 1", >>>> then the report is corrupt, and the likely cause is Name AutoCorrect. >>>> Details: >>>> Failures caused by Name Auto-Correct >>>> at: >>>> http://members.iinet.net.au/~allenbrowne/bug-03.html >>>> >>>> After turning off the Name AutoCorrect options, compact the database. >>>> Then >>>> select the report in the Database window, copy (Ctrl+C), and paste >>>> (Ctrl+V), >>>> supplying a new name for the copy of the report. Can you change the >>>> margin >>>> of the copy? >>>> >>>> If you're still stuck at this point, try the undocumented SaveAsText >>>> and >>>> LoadFromText, or follow the steps for the first symptom in this article >>>> to >>>> get Access to reconstruct if for you: >>>> Recovering from Corruption >>>> at: >>>> http://members.iinet.net.au/~allenbrowne/ser-47.html >>>> >>>> >>>> "Bob Brannon" <bbran@3rivers.net> wrote in message >>>> news:%23LFioVx$EHA.1408@TK2MSFTNGP10.phx.gbl... >>>>> Hello, >>>>> >>>>> I am using Access 2000 on XP Home SP2. >>>>> >>>>> For the life of me I cannot figure out why I cannot change the bottom >>>>> margin >>>>> of a report in page setup from 2.5" to 1". When I try it reverts back >>>>> to >>>>> 2.5. >>>>> >>>>> The report is designed exactly the same as another report that uses >>>>> different a different criteria in the query. That report has not >>>>> trouble >>>>> with the bottom margin being 1". Any suggestions? >>>>> >>>>> Regards, >>>>> Bob Brannon
- Next message: Mariel: "Open a report based on different queries"
- Previous message: Fons Ponsioen: "RE: Counting based on a conditional expression"
- In reply to: Allen Browne: "Re: page margin"
- Next in thread: Allen Browne: "Re: page margin"
- Reply: Allen Browne: "Re: page margin"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
