Re: report printing dillemma

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Allen, thanks for the response. I went straight to #4 and made the change
and it works just fine now. I started thinking that I was in the other
office using the other printer as my default so I could print at the office.
Thanks. Something I need to remember in the future.
*** John


"Allen Browne" wrote:

> Try this sequence:
>
> 1. Make sure that Name AutoCorrect is off, i.e. uncheck the boxes under:
> Tools | Options | General | Name AutoCorrect
> Explanation:
> http://allenbrowne.com/bug-03.html
> Some of the bugs of this misfeature cause reports to forget their correct
> settings.
>
> 2. Compact the database:
> Tools | Database Utilities | Compact
>
> 3. Open the report in design view.
> Choose Page Setup from the File menu.
> On the Page tab, make sure the report is set for Default Printer.
> Make a small design change (e.g. renaming a label).
> Save.
>
> 4. Compact again.
>
> If that does not solve the problem, make sure you have SP3 for Office 2000.
>
> --
> 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.
>
> "JohnE" <JohnE@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:4786029F-89B4-4F2E-9770-FE22945641C9@xxxxxxxxxxxxxxxx
> >I have a report that takes 1 minute 20 seconds to open in preview. The qry
> > is fine and so on. But, when I went to print it, it is showing that it is
> > printing to a printer in one of our other offices. It should have printed
> > out on the printer next to my computer (nonnetworked). When I created the
> > report and first printed it, I was in that other office. I no longer have
> > any other printers then those in our office listed. But it still prints
> > to
> > the other. I guess my question is; is there some hidden place within A2k
> > that says which printer to print to? I looked all over my computer and
> > did
> > not find the pinter listed. Anyone else have this problem. I would hate
> > to
> > have to delete and redo the report.
> > *** John
>
>
>
.

Relevant Pages

  • Re: Image ctl causes bloat when using text field to store path/fil
    ... This is the only code in the whole report. ... "Gina Whipp" wrote: ... problem, I have since discovered, is with the Image Control. ... Compact on Close will attempt to do so while the database is use... ...
    (microsoft.public.access.tablesdbdesign)
  • Re: HTML code is showing up
    ... Compact the database. ... This might mean creating another text field in your table, populating it with an Update query, deleting the old one, compacting the database, and then renaming the field back to the old one again. ... Then double-check that the Text Format of the property in the form is plain text. ... If that is the case, when you create a report, the text box on the report should have its Text Format property set automaticallly for you. ...
    (microsoft.public.access.reports)
  • Re: Reports Revert from Landscape back to Portrait (Office 2003)
    ... If you change printer to one where the paper size is ... Compact the database to get rid of this junk: ... Another alternative would be to export this report to a text file, ...
    (microsoft.public.access.reports)
  • Re: Slow Editing Report
    ... Then compact the database to get rid of this junk: ... If the report is based on a crosstab query, you could solve the issue by ...
    (microsoft.public.access.reports)
  • Re: Problems deleting an unwanted report
    ... Then try a compact: ... File | Database Utilities | Compact/Repair ... Recovering from corruption ... I deleted it from the Report area of Access but now every time I try to ...
    (microsoft.public.access.reports)