Why can't I see Export To when I right click my report

[Bobby]

Hi,
I'm using Access 2007. I'm opening a report using VBA as follows:

DoCmd.OpenRepor t stDocName, acPreview, , acDialog,
OpenArgs:=sqlSt ring

The database is setup so that when a user opens it, they only get
limited access to certain things, e.g. they can't see the database
window unless they press the F11 button.

The problem is, when the user runs a report and right clicks on the
report, they don't see the "Export to" option. However, when I open
the database by holding the shift key down, and then run the report, I
do get the "Export to" option. Can anybody tell me why this is? I
guess it's some option that I've not ticked when the database starts
up. I've only just started using Access 2007, so I'm not sure where
everything is at the moment, so if you could be fairly specific I'd
appareciate it.

Thanks a lot

Colin

[Rick Brandt]

Re: Why can't I see Export To when I right click my report

Bobby wrote:

Hi,
I'm using Access 2007. I'm opening a report using VBA as follows:
>
DoCmd.OpenRepor t stDocName, acPreview, , acDialog,
OpenArgs:=sqlSt ring
>
The database is setup so that when a user opens it, they only get
limited access to certain things, e.g. they can't see the database
window unless they press the F11 button.
>
The problem is, when the user runs a report and right clicks on the
report, they don't see the "Export to" option. However, when I open
the database by holding the shift key down, and then run the report, I
do get the "Export to" option. Can anybody tell me why this is? I
guess it's some option that I've not ticked when the database starts
up. I've only just started using Access 2007, so I'm not sure where
everything is at the moment, so if you could be fairly specific I'd
appareciate it.
>
Thanks a lot
>
Colin

Right-click menus are not available when you open a report or form with the
acDialog option.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com