Results 1 to 3 of 3
  1. #1
    data808 is offline Noob
    Windows 8 Access 2007
    Join Date
    Aug 2012
    Posts
    727

    Scroll not working in viewing reports


    I am trying to just view a report but cannot scroll down. I do NOT have it in pop up. The scroll bar property is set to "Both". I cannot figure this out.

    I also came across something weird where in the VBA code where I have the report open up to view, if I use line:

    DoCmd.OpenReport "Detailed Report", acViewNormal

    It will open up my HP ePrint dialog window.

    If I use this line:

    DoCmd.OpenReport "Detailed Report", acViewReport

    It shows the report. Is acViewNormal an autoprint function/command or something?

    Does anyone know how to fix the scroll bar issue or explain why this report tries to auto print when I use acViewNormal?

  2. #2
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Dubai
    Posts
    614
    Try DoCmd.OpenReport "Detailed Report", acViewPreview

  3. #3
    data808 is offline Noob
    Windows 8 Access 2007
    Join Date
    Aug 2012
    Posts
    727
    That brings the report in a print preview state. Found a better way of doing it. Create another report. One report will open up as a pop up window. The other will be a tabbed view. Then assign one button to view the report in a window where you can scroll and assign the second button to open the tabbed view report as your print preview when you are ready to print the report. Make sense? Thanks for the help though. Really appreciate that someone replied to my post. Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. viewing next autonumber
    By mike02 in forum Access
    Replies: 8
    Last Post: 08-14-2012, 07:37 AM
  2. Viewing a read-only table
    By mejia.j88 in forum Database Design
    Replies: 9
    Last Post: 04-16-2012, 05:31 PM
  3. Reports not working after MS Update
    By lauradilts in forum Access
    Replies: 4
    Last Post: 01-13-2012, 09:29 AM
  4. Viewing Attachments
    By tcheck in forum Access
    Replies: 3
    Last Post: 08-02-2011, 03:24 PM
  5. Access 2.0 Viewing Code
    By wollydog in forum Access
    Replies: 0
    Last Post: 12-03-2008, 07:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums