Tools menu

[hellohello1]

In my Access 2003 database, under Tools, Start Up, Allow Full Menus is unchecked.

I have a form that opens a query. When that query opens, I would like to activitate the Tools, Office Links menu.

Then when the query closes, the Tools menu goes away again.

Can I do that?

Thanks

 

[genomon]

Not sure, but I think SetOption might do it.
Have a look here:

http://support.microsoft.com/kb/216888

Ever notice how fast Windows runs? Me neither.

 

[hellohello1]

thanks for writing. i looked at SetOption, but no luck...

 

[hellohello1]

Anyone have any other suggestions?

Thanks,

 

[hellohello1]

If I can't make the Office Links, Analyze It with Excel toolbar appear, then, on my form, can I write code to automatically show the query data in a temporary Excel file?

The 'temporary' part is what i'm struggling with.

When I try:
DoCmd.OutputTo acOutputQuery, "qryTest", acFormatXLS, XL, True

it prompts me to name the file in Excel. But I don't want to save the data. Can I have the query data open in a unsaved Excel file (ex: Book1.xls).

Then if the user leaves Book1.xls open, and clicks the button on the form again, they get the data in Book 2.xls. If the user wants to save, that is up to them.

Thanks,