Avatar of SteveL13
SteveL13
Flag for United States of America asked on

How display ONLY "Close Print Preview" and "Print" on the ribbon

I have the following code which hides the ribbon from displaying:

'Code to hide ribbon if user is security level 2 or higher...
    If DLookup("[SecurityLevel]", "LOCALtblCurrentUser") > 1 Then
         DoCmd.ShowToolbar "Ribbon", acToolbarNo
    End If

Open in new window

But what I really want to do is allow the user to "Close Print Preview" and "Print" from the ribbon when a report is previewed, nothing else.  Can this be done?
Microsoft AccessSecurity

Avatar of undefined
Last Comment
John Tsioumpris

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
John Tsioumpris

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy