Results 1 to 2 of 2
  1. #1
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615

    Issues with the new 'Report View' of reports.

    I have an A2010 application in which for security reasons, I turn the ribbons off, and keep the users out of the navigation pane - no problems there.

    I have found the new "Report View" of reports very useful (or more accurately, potentially very useful) because in that view the controls can act like those on forms, reacting to on-click events (among others).

    My question is - once the Report View is displayed, how does the user print it? The right-click popup menu does not have an option to print. I tried using a command button to print it : DoCmd.OpenReport "MOS_Report_EN", acViewNormal, i.e. opening the same report but this time printing it (there is no WHERE clause to worry about).

    When I click the button, I get a brief message that the report is being printed, but it does not print; not only that, but the report controls no longer react to any button clicks. Could the Report View version on the screen be locking the data so that the one to print won't work (despite what the message says)?



    Any thoughts or suggestions would be much appreciated.

    Thanks

    John

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I have avoided print preview so far. So, I cannot speak from experience. It does seem like a custom shortcut menu is in order, though.

    This thread discusses them. They do not list the toolbar command constants and use the integers instead. You would have to look up the constants to add the correct "Print" feature.
    https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

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

Similar Threads

  1. Replies: 3
    Last Post: 09-17-2014, 03:05 PM
  2. Multiple Datasheet View subform tabs requery issues
    By gottnoskill in forum Programming
    Replies: 11
    Last Post: 06-05-2014, 06:33 AM
  3. Replies: 2
    Last Post: 04-21-2014, 12:43 PM
  4. Having issues with calculated fields in reports
    By Neologic29 in forum Reports
    Replies: 12
    Last Post: 08-17-2013, 05:18 PM
  5. Picture issues within Access reports
    By paulkimball in forum Access
    Replies: 0
    Last Post: 05-14-2012, 07:55 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