Results 1 to 6 of 6
  1. #1
    cbpuppy
    Guest

    losing report page setups (2000)

    Having trouble keeping the report page setups. Wanted report in landscape but keeps going back to portrait. Any ideas about keeping it the way it is setup? Thanks!!!

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

    Re: losing report page setups (2000)

    Give us more information. Is this happening to the same report on the same machine with the same printer, or is it between machines or with different printers? What operating system and version are you running, and what service release of Office/Windows?

    Oh, and this is a *report*, right, and not just a query you're using as a report?
    Charlotte

  3. #3
    cbpuppy
    Guest

    Re: losing report page setups (2000)

    This is happening to the same report, computer and printer. Didn't think computer and printer made a difference, for future reference - would it?

    OS: Win 2000 SP2.

    Access 2000 - Strange thing though - I found on MS support SP-2 and proceeded to download it... for some reason it was taking a bit longer and was acting weird during the download and installation automation... (A colleague next to me has the exact same computer as mine, however, with Win 2000 SP-1). I suspect that perhaps Win was updated to SP-2 not Access. POssible? <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Anyways, Access 2000 (9.04402 sr-1)

    Yes, this report is based on a select query. Meaning a prompt will come up and ask for a person's name, based on that name all this data will show up in this report.

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Seattle, Washington, USA
    Posts
    179
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: losing report page setups (2000)

    Found this article that could apply to you -- The only problem is that it is for Access 2.0?

    Article # Q114514

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

    Re: losing report page setups (2000)

    Service packs for Windows are entirely separate from service releases for Office. SR-1 is still the release of choice for Office 2000, and it corrects the printer settings problem in other versions of Windows. I don't run Win2000, so I don't know what it's up to these days.

    It seems to me I've read posts on this problem between Win2000 and Office 2000, although I can't locate any of them at the moment. The only other thing I can suggest is that you try turning off Name Autocorrect (Tools-->Options-->General) and see if that makes a difference. It was one of the workarounds for Access prior to SR-1, and it's still worth a try.

    Oh, one other thing would be to download and install the latest Jet 4.0 service pack, although the Windows service pack is supposed to eliminate the need for it in Windows 2000. You can find out more about it and/or download it from the Microsoft site at <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/q239/1/14.asp>http://support.microsoft.com/support/kb/ar...s/q239/1/14.asp</A>
    Charlotte

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

    Re: losing report page setups (2000)

    I forgot about part of your question. If you save a report on one machine, you save the settings, but you'll lose those settings if you print to a different printer. The settings are printer specific.

    It doesn't matter if the report is *based* on a select query, but if the "report" *is* a select query, then your settings are never going to be saved because they are only saved for report objects, not for queries.
    Charlotte

Posting Permissions

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