Nov 1 2004, 02:25 AM
I would assume this is an old problem, so maybe there is an old answer:
I have a report that I show using ViewType acPreview since my users sometimes do not want to print out the report, but just have a quick look at the data presented.
If they then, however, decide to print it, I have to send them through the context menu to do so (Another issue is that I would like to block the context menu completely to prevent them from mokeying around with the designs.).
Any ideas on how to do that?
Nov 1 2004, 01:38 PM
Use code to shut off that menu, then display a print button using a custom menu bar.
Nov 2 2004, 09:59 AM
Thanks for the answer, I cut off that menu using the "Startup" settings of the database.
How can I create a custom menu bar (and make sure it is the only one accessible to the user)?
Nov 2 2004, 10:05 AM
Look up Custom Menu Bar in the Access help.
Once you have you're custom menu bar created, use code to hide all the other menu bars, then when you open the report in acPreview, add a line to display your custom menu bar.
In the OnClose event for your report, hide the custom menu bar.
Let me know if you need help with the actual coding.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here