Results 1 to 6 of 6
  1. #1
    sanal is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Feb 2018
    Posts
    43

    How to ensure ribbon when report is opened in print oreview in accdr format even if the ribbon is mi


    How to show the ribbon only when a report is opend print preview in access accdr format evenif the ribbon is minimized by someone. Is there any code to ensure the ribbon when a report is opened.

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Code:
    DoCmd.ShowToolbar "Ribbon", acToolbarYes
    DoCmd.OpenReport strDoc, acViewPreview
    Then to hide again, in the report close event:
    Code:
    DoCmd.ShowToolbar "Ribbon", acToolbarNo

    Works with accdb, not sure about accdr
    Last edited by davegri; 07-29-2018 at 08:04 AM. Reason: more info

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    .accdr does not provide a ribbon (nor right click options), if you want ribbon features, you need to create your own.

  4. #4
    sanal is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Feb 2018
    Posts
    43
    Thank you for the reply. I want to prevent minimize of ribbon. Do you have any code to ensure a maximized ribbon in print preview of reports.
    Last edited by sanal; 07-29-2018 at 11:05 PM.

  5. #5
    sanal is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Feb 2018
    Posts
    43
    Thank you for reply.
    In print preview of reports toolbar is seen in accdr .

  6. #6
    sanal is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Feb 2018
    Posts
    43
    Thank you Ajax. In print preview of reports toolbar is there in accdr.

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

Similar Threads

  1. No Ribbon
    By Joakim N in forum Access
    Replies: 2
    Last Post: 05-19-2017, 03:29 AM
  2. Prevent Print Preview Ribbon activating?
    By DubCap01 in forum Access
    Replies: 5
    Last Post: 05-27-2015, 08:55 AM
  3. Open Print Dialog when Report is opened
    By tylerg11 in forum Reports
    Replies: 1
    Last Post: 01-09-2014, 10:44 AM
  4. Replies: 1
    Last Post: 02-23-2013, 12:30 AM
  5. Replies: 0
    Last Post: 09-27-2011, 04:27 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