Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Florence, Oregon, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Report Preview Window Problems (WindowsMe/Access2002)

    My Access2002 report display facility (ie. Windows print preview) has started behaving oddly without my having changed anything (obviously). Up until now, the report preview window appeared contained within the bounds of the Access window (could not be moved out of that window), and clicking on File | Print... or on the toolbar print button printed the pages. Now the preview window appears outside the bounds of the Access window (can be moved, for example, to my second monitor), and clicking on File | Print or on the print button prints not the report but the Access screen behind the report. In this case, as the report is generated from an Access form, that form, even after it has been closed (DoCmd.Close acForm,...) is what's printed.

    I have compared every one of my current Access Tools | Options settings with the settings from the same system backed up a month ago, and absolutely everything matches. (Incidently, Ctrl-P with the print preview window selected does print correctly, but that's an asside: most people don't print that way.) In addition, all my other Access database systems, some containing VBA code and some not, print preview and print physically as they should. Could someone please tell me what has happened and what I need to change to correct it.

    Thank you for your time, John

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

    Re: Access Report Preview Window Problems (WindowsMe/Access2002)

    Check the PopUp property of the report. If it's set to Yes, the report will not be bound to the Access application window.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access Report Preview Window Problems (WindowsMe/Access2002)

    >>Check the PopUp property of the report. If it's set to Yes<<

    Is this a new feature in A2002?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Access Report Preview Window Problems (WindowsMe/Access2002)

    Yes, reports now have properties such as
    <UL><LI>AutoResize
    <LI>AutoCenter
    <LI>BorderStyle
    <LI>ControlBox
    <LI>MinMaxButtons
    <LI>CloseButton
    <LI>PopUp
    <LI>Modal[/list]And DoCmd.OpenReport has new arguments WindowMode and OpenArgs, like OpenForm.

    (Some of these may have been introduced in Access 2000, I jumped from Access 97 to Access 2002)

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access Report Preview Window Problems (WindowsMe/Access2002)

    I think these must all be new with A2002.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    3 Star Lounger
    Join Date
    May 2002
    Location
    Florence, Oregon, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Report Preview Window Problems (WindowsMe/Access2002)

    Thank you HansV and Marld_iquorman. Turning off the report property pop-up solved the problem. Further, turning off pop-up in the report requesting form also solved the problem of the form remaining visible in front of the report (which now that I think of it makes sense).

    John, Oregon

Posting Permissions

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