How to lock all controls in print preview

[June7]

Did you make two ribbon records in USysRibbons table? Set one as default with File > Options > Current Database > RibbonName. Set report RibbonName property with name of second ribbon.

acccdr can be used even when user does not have full version of Access - must have free Runtime version installed. Other than that, I am not familiar with differences of accdr and accde since I never worked with.

[CJ_London]

Accdr - emulates a runtime environment, primarily for developers to test their app. Runtime has a limited menu and ribbon, no navigation window or right click menus but a developer can create their own equivalents. Simply rename your app as .accdr. Sometimes used as a very weak security device (easily overcome by a user renaming back to .accdb

accde - all ribbons, menus , navigation form and right click menus work as with .accdb but user cannot modify forms, reports or modules

[deepaksharma]

Accdr - emulates a runtime environment, primarily for developers to test their app. Runtime has a limited menu and ribbon, no navigation window or

Thank you CJ

[deepaksharma]

Did you make two ribbon records in USysRibbons table? Set one as default with File > Options > Current Database > RibbonName. Set report RibbonName

I find the USysRibbons table but only one row in showing in it. please help

[June7]

I have never seen uSysRibbon record that looked like that. Here are two from my table - RibbonXML field:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
<tabs>
  <tab id="tabDemo" label="Demo">
    <group id="grpAbout" label="About Me">
      <button id="btnWebsite" label="My Website" size="large" imageMso="OutlookGlobe" onAction="=RibbonAction('website')" />
      <button id="btnBlog" label="My Blog" size="large" imageMso="SetLanguage" onAction="=RibbonAction('blog')" />
      <button id="btnEmail" label="Contact Me" size="large" imageMso="EnvelopesAndLabelsDialog" onAction="=RibbonAction('email')" />
    </group>
    <group id="grpInfo" label="Info">
      <button id="btnInfo" label="Info" size="large" imageMso="Info" onAction="=RibbonAction('info')" />
    </group>
    <group id="grpExit" label="Exit">
      <button id="btnExit" label="Exit" size="large" imageMso="MasterViewClose" onAction="=RibbonAction('exit')" />
    </group>
  </tab>
</tabs>
</ribbon>
<backstage>
  <button idMso="FileSave" visible="false"/>
  <button idMso="SaveObjectAs" visible="false"/>
  <button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
  <button idMso="FileOpen" visible="false"/>
  <button idMso="FileCloseDatabase" visible="false"/>
  <tab idMso ="TabInfo" visible="false"/>  
  <tab idMso ="TabRecent" visible="false"/>
  <tab idMso ="TabNew" visible="false"/>
  <tab idMso ="TabPrint" visible="false"/>
  <tab idMso ="TabShare" visible="false"/>  <tab idMso ="TabHelp" visible="false"/>
  <button idMso="ApplicationOptionsDialog" visible="false"/>
  <button idMso="FileExit" visible="true"/>
</backstage>
</customUI>
_______________

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
    <ribbon startFromScratch="false">
        <tabs>
            <tab idMso="TabAddIns" visible="false"/>
            <tab id="PrintPreview" label="Report Print and View Options">
                <group idMso="GroupPrintPreviewPrintAccess" />
                <group idMso="GroupPageLayoutAccess" />
                <group idMso="GroupZoom" />
                <group id="GroupPrintPreviewData" keytip="x" label="Data Export">
                    <button idMso="ExportExcel" keytip="e" size="large"/>
                    <button idMso="PublishToPdfOrEdoc" keytip="p" size="large"/>
                    <button idMso="FileSendAsAttachment" keytip="m" size="large"/>              
                </group>
                <group idMso="GroupZoom"></group>
                <group id="Exit" keytip="x" label="Exit">
                    <button idMso="PrintPreviewClose" keytip="c" size="large"/>
                </group>
            </tab>
        </tabs>
    </ribbon>
</customUI>

[deepaksharma]

The mistake I was making was that I was exiting the Ribbon Creator by creating both Home and Print tabs. This time I created only the Home tab from the Ribbon Creator and exited. Opened the Ribbon Creator again and created a tab named Print for the second time and Exited again due to which two fields started showing in the usysribbons table. The first tab (home) I have set to default in File - Options - Current Database and after that i have set print tab name in print report other tab ribbon name drop down list.
Have I followed the correct procedure?
Thank you.

[June7]

You mean two records showed.

I've never used Avenius's ribbon creator but sounds like you did it right. And if that is the ribbon name (I would assign something more meaningful, like MyPrintRibbon), yes it goes in RibbonName property. Now do the ribbons work?

[deepaksharma]

You mean two records showed.

I've never used Avenius's ribbon creator but sounds like you did it right. And if that is the ribbon name (I would assign something more meaningful, like MyPrintRibbon), yes it goes in RibbonName property. Now do the ribbons work?

Yes, when the print privew report is opened, the print label is highlighted, this was my main problem.
One more thing I want to know from you is that when print button is clicked the print preview opens behind the dashboard is there any way to open the print preview on top of the dashboard.
Thank you.

[June7]

Don't set form as Popup.

[deepaksharma]

You mean two records showed.

I've never used Avenius's ribbon creator but sounds like you did it right. And if that is the ribbon name (I would assign something more meaningful, like MyPrintRibbon), yes it goes in RibbonName property. Now do the ribbons work?

Please Check Ribbons in attachment

[deepaksharma]

You are right, it is working properly when pop up is removed but if it is not set to pop up then the real enjoyment of the software is not available.
Is there any other solution please?

[June7]

Maybe set form as hidden when report opens, unhide when report closes. Set Visible property. Like:

If CurrentProject.AllForms("formname").IsLoaded Then Forms!formname.Visible = False

[deepaksharma]

Maybe set form as hidden when report opens, unhide when report closes. Set Visible property. Like:

If CurrentProject.AllForms("formname").IsLoaded Then Forms!formname.Visible = False

Thanks June I have put this code in on click event of print button.

Forms![dashboard].Visible = False

And this code has been inserted in the on close event of the print report.

Forms![dashboard].Visible = True

Now it is reducing properly am I on the right track? Please guide me.
Thank you.

[June7]

If it's working, then yes.

[deepaksharma]

If it's working, then yes.

Thank you..