Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Colorado, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Temperamental Report Printing (Access 2000)

    I've got one report among about 8 that does not print correctly. They are all formatted to print landscape, however in one case when I hit the print button on the toolbar it prints portrait. If I use the same button with the other landscape reports, they print fine. Also, if I go to the File pulldown and select Print..., and click OK on the print dialog this problem report prints correctly. So, has anyone else experienced this problem? Is there a way to get the print button that pops up the dialog onto a custom tool bar? Right now all I can get to is the one that automatically prints without the intervening dialog.

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Temperamental Report Printing (Access 2000)

    1. Select Tools | Options..., General tab. Make sure that the Name AutoCorrect options are turned OFF. If they are ON, they can cause reports to forget printer settings.

    2. Create a new macro. Set the action to Run Command and the argument to Print. Save the macro. You can assign this macro to a custom toolbar button.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Colorado, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Temperamental Report Printing (Access 2000)

    Turning off Autocorrect didn't help the report problem. Do I need to recreate the report? I tried exiting the mdb and reentering it, but that didn't help either.

    Thanks for the info.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Temperamental Report Printing (Access 2000)

    I am not aware of other problems with page settings, and I frankly have no idea whether recreating the report will help. If you can afford the time, it might be worth a try.

    There are ways to set the page orientation in code, but in Access 2000 (and before) it involves lots of complicated Windows API calls, and in a multi-user environment it requires each user to have his/her own frontend database. I'm sorry <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Temperamental Report Printing (Access 2000)

    What service release of Access 2000 are you running? There were problems with page settings being lost in the vanilla version and I have seen odd behavior like this on a report in 2002 that was set up for legal and landscape that refused to retain those settings when printed automatically. It would print either letter landscape or legal portrait but I had to use brute force to get it to print legal *and* landscape.
    Charlotte

  6. #6
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Colorado, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Temperamental Report Printing (Access 2000)

    My version is 9.0.6926 SP-3 according to About Microsoft Access.

  7. #7
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Temperamental Report Printing (Access 2000)

    Charlotte,

    What was the "brute force"? I have four reports that are landscape legal and work fine on the pc I used to develop them. However, when we run them on another pc, with the same version of Access (XP SP 3) we cannot get it to print landscape legal, only landscape letter. AAAAAAHHHHHHHHHHH!! ! ! ! !! !

    Ken

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Temperamental Report Printing (Access 2000)

    It isn't pretty, involves API calls, and requires you to open the report in design view and manipulate its properties directly. I don't have the code at hand, but there is plenty of it available if you search on PrtDevMode both here and elsewhere.

    Is the report formatted for the default printer? Are both machines using the same printer and the same drivers? We've found that most of the problems we have with printing can be traced back to printer drivers. Oddly enought, the latest and greatest printers are usually the ones that give us fits. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> You aren't sharing the front end are you? That will prevent you from saving design changes to a report, and you have to save them or the print settings will be lost.
    Charlotte

  9. #9
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Temperamental Report Printing (Access 2000)

    <P ID="edit" class=small>(Edited by charlotte on 11-Sep-04 16:30. to activate link)</P>Charlotte,

    Thanks for the follow up. I have responded to your questions below, in hopes that it may expose something obvious to someone. I tried microsoft's attempt at a patch (for the 97 version because I had found a post where they had used it in XP) located at:
    http://support.microsoft.com/default.aspx?...kb;en-us;302650

    That too was unsuccessful.

    RE: the report formatted for the default printer?
    Yes. Then we tried modifying it for specific printer, which did not help.

    RE:Are both machines using the same printer and the same drivers?
    No. We do share one common printer, but we work in different buildings with different printers. However, all of her printers are HP Lasers, and Adobe Acrobat pdf writer, which is the one printer we have in common.

    RE: You aren't sharing the front end are you?
    By sharing teh front end, I assume you mean we are accessing the same front end across a network. That too would be no. I have developed the reports at my workstation and installed a copy of the frontend on her workstation.

    Thnkas for the additional seach term "PrtDevMode". Perhaps I can find a solution with that key word.

  10. #10
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Temperamental Report Printing (Access 2000)

    Don't be confident that just because they're HP lasers that everything is the same. We've encountered printer problems when one machine has the *latest* drivers installed. One test would be to have her set up the printer as an HP LJ4 and see what happens. Are you printing to the Acrobat printer or to a physical printer? If you're printing to acrobat, then are you using the same drivers for that?

    The MSKB article also uses the PrtDevMode to handle printing. It isn't a patch, so I'm not sure what you meant. If that doesn't work, then it has to be either your code or the printer drivers involved. We've used the PrtDevMode successfully on A97 apps on everything from Win95 to WinXP and on A2k and AXP from Win98 up, so I do know that it works.
    Charlotte

  11. #11
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Temperamental Report Printing (Access 2000)

    Charlotte,

    Thanks for the additional feedback and questions.

    RErinting to the Acrobat printer or to a physical printer?
    So far we have tried both. The goal is to be able to email the reports so we are using pdf for final report, but have used hardcopy for development. (NOTE: In case someone wonders why email the reports as pdf instead of Snapshots, they are Lotus notes user, so emailing as a snapshot is not an option)

    RE: If you're printing to acrobat, then are you using the same drivers for that?
    Yes, both of us are using Acrobat 6.0.0 5/19/03

    There are a total of 16 reports that I have created for her, only four of which are legal landscape. The other 12 are letter landscape, and they do fine. Only problems are with the "legal landscape" reports.

    RE: use of the word "patch"
    Sorry, poor choice of words. I figured since Access doesn't seem to "remember" printer settings, I would just refer to the MSKB article as a "patch" since it appeared to fix what Microsoft couldn't within Access itself. I incorporated the code into the version I have on my workstation, and all is well and good in the world. However, it was well and good on my workstation wthout the code. So, it sounds like the next place I need to go is to validate her printer drivers, other than Acrobat.

    Thanks again for sharing your ideas.

    Ken

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •