Hi,
My Reports in my access system is showing the "Design View" and "Layout View" selections on right click. I can't disable the right click entirely because some of the reports are filterable. I got a VBA module code from the web tweaked it to my requirement. It worked when I opened the reports via double click from the navigation pane but when I accessed the report via the buttons on my forms It started giving errors. Do you know the way to customize the right click menu using macro. I am using Access 2013. I found a method on Access 2007 but couldn't figure out how on Access 2013. The macro builder screen is different from the screen shots provided. I need to only have the "Print Preview" and "Filter Menu" on right click at my reports.
Thanks in Advance
Stan
My Reports in my access system is showing the "Design View" and "Layout View" selections on right click. I can't disable the right click entirely because some of the reports are filterable. I got a VBA module code from the web tweaked it to my requirement. It worked when I opened the reports via double click from the navigation pane but when I accessed the report via the buttons on my forms It started giving errors. Do you know the way to customize the right click menu using macro. I am using Access 2013. I found a method on Access 2007 but couldn't figure out how on Access 2013. The macro builder screen is different from the screen shots provided. I need to only have the "Print Preview" and "Filter Menu" on right click at my reports.
Thanks in Advance
Stan