Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    Griffith (Near Chicago), Indiana, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Format (Access 2000)

    I created a report based upon a query in access 2000 via the wizzard and had it set up as landscape. When I pull the report now, it always reverts back to portrait. Is there anyway to stop this? (I am pulling the report via a command button with criteria in the vba.)

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Format (Access 2000)

    Do you have Service Pack 1 installed?
    This is a bug fixed in Service Pack 1.
    You can find it here
    Francois

  3. #3
    New Lounger
    Join Date
    Feb 2003
    Location
    Griffith (Near Chicago), Indiana, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Format (Access 2000)

    I do have the latest version of NT service pack installed, I'm not the IT person here so I can't remember what version I have.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Format (Access 2000)

    I was speaking about the service packs of Microsoft Office 2000.
    I you open the Help / about window, you can see if you have an SP1, SP2 or SP3 after Microsoft Access 2000 (XXX XXXXXX XXXXX)
    Francois

  5. #5
    New Lounger
    Join Date
    Feb 2003
    Location
    Griffith (Near Chicago), Indiana, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Format (Access 2000)

    Sorry my bad....No I don't have any service packs installed w/access. you said version 1 should correct the problem?

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Format (Access 2000)

    Yes, download it from the link in my first post.
    Francois

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Report Format (Access 2000)

    In the meantime (I cannot verify this because the Search on the Lounge has been disabled), what you could do is to turn AutoCorrect off.
    This is just a temporary solution as Service Pack 1 has some goodies.
    Go into Options/General and make sure all the AutoCorrect checkboxes are cleared.

Posting Permissions

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