Re: page margin

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Bob Brannon (bbran_at_3rivers.net)
Date: 01/26/05 

Date: Wed, 26 Jan 2005 10:04:25 -0700

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.
>>
>> -- 
>> 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:%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

Relevant Pages

  • Re: Print oreview multiple records
    ... When they clcik print I would like the preview window ... Once done and they close the report I would like it to automaticly move to ... the preview method my code simply loops thru to the last record then opens ... Do you have the report's Toolbar property set to the name of ...
    (microsoft.public.access.reports)
  • Re: Print oreview multiple records
    ... When they clcik print I would like the preview window to ... Once done and they close the report I would like it to automaticly move to ... the preview method my code simply loops thru to the last record then opens ... DoCmd.OpenReport stDocName, acViewPreview, _ ...
    (microsoft.public.access.reports)
  • Re: report parameter
    ... Access opens a new module. ... Then enter the one line into the Immediate Window. ... If the report is being opened through code, ... Even if there is no control with that name, it could still be in the ...
    (microsoft.public.access.reports)
  • Re: Printer Control and Print/Preview Problems
    ... to be appended to the report print stream. ... or "Print" with the DoCmd.OpenReport command, ... still open preview window. ... > following that with an OpenReport using acNormal. ...
    (microsoft.public.access.reports)
  • Re: Boot problems
    ... Here is the error checking report: ... I also don't quite understand chkdsk and hope you will be kind ... When I ran it from a command line window it found ... You can access Event Viewer by selecting Start, ...
    (microsoft.public.windowsxp.basics)