Hi, i've a menubar with a "direct link" to an outputTo macro (exporting a query to an excel file)..in the "admin" mode is working..but in user mode when i click on it i've this message

http://img90.imageshack.us/img90/8445/immaginebs0.th.jpg (http://img90.imageshack.us/my.php?image=immaginebs0.jpg)

my db is not read only (or i think so..where can i find this?) and is not unconverted from an earlier version of access, ...

after clicking on the OK i've this window

http://img218.imageshack.us/img218/1135/immagine2bc1.th.jpg (http://img218.imageshack.us/my.php?image=immagine2bc1.jpg)

I mean, is it possible to run a macro directly from a menubar without passing through something else (form, whatever, ...) ??

thx in advance

bye

i think i've found the problem..

the query is not loaded, so the outputTo cannot find it..
is there a possibility to run the query without showing the preview (or datasheet, or pivot chart, ...) ?? ..i mean something "hide"..

Instead of OutputTo, use the TransferSpreadsheet Action.

Instead of OutputTo, use the TransferSpreadsheet Action.
thx it works, i didn't use this 'cause i thought it would have worked only with a table..but it works even with query!
thx again