Results 1 to 4 of 4
  1. #1
    shariq1989 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    50

    Open report in Report View


    I am using a code which yields a report in acViewPreview (Print Preview). I want my users to be able to customize the reports themselves and use text filters however they want. To use the text filters, they need to be able to access the report in Report View. Can anyone help me with the OpenReport command for this?

  2. #2
    uncletreetrunk is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    72
    Hey shariq,

    I'm relatively new to access but is this what you want?

    DoCmd.OpenReport "Report Name", acViewLayout

  3. #3
    shariq1989 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    50
    No, but you helped shoot me in the right direction! AcViewReport was what I needed. Thanks!

  4. #4
    uncletreetrunk is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    72
    No problem! Glad I could provide some assistance!

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

Similar Threads

  1. Replies: 2
    Last Post: 05-06-2012, 11:10 AM
  2. Replies: 10
    Last Post: 07-25-2011, 12:07 PM
  3. View Pdf in form/report
    By Mitka in forum Forms
    Replies: 1
    Last Post: 01-15-2011, 11:06 AM
  4. Report not opening to view
    By Desstro in forum Programming
    Replies: 4
    Last Post: 11-25-2010, 05:36 PM
  5. View SQL or VBA for Report?
    By Kimbertha in forum Reports
    Replies: 3
    Last Post: 10-21-2010, 08:56 PM

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