Menus at top of report

[Always_Learning]

Hi There,

I have taken over an Access database and I am having a few issues finding where things are being pulled from.

On all the reports there is a menu area with icons with Page Setup, printer, and a button "Output" which when you click it drops down and gives you options to open in Word, open in Excel or Mail it as an Excel Attachment. My Questions are:
1. How do I find Where is this declared.
2. When I choose to export to Excel I get an error saying " The format in which you are attempting to output the current object is not available"
Apparently this used to work fine.
If I choose to "Mail Attachment" it opens my email client with an Excel attachment which is perfect when I open it. How come that it can do this as an attachment but throws the error when exporting to Excel.

I am finding it hard because I cannot find where this code is being called from and the actual code being run.

I appreciate any help you can give.

Best Regards,

 

[maw230]

Do you know how to access the Visual Basic Editor? Upon opening it all of the objects/modules containing the code should be displayed on the left in the Project Window.

 

[Always_Learning]

Hi There,
Thanks for the reply.

I do know how to get to the VBA stuff and I can see the reports and forms ok but I cannot see how the menu strip at the top of the report is coded.
Is there a way to find where this coding is. There is a button "Output" that call's the export to Excel but I cannot find the code or sub routine that is run for the export.

Thanks for your help.

Best Regards,

Steve.

 

[maw230]

Hi There,
Thanks for the reply.

I do know how to get to the VBA stuff and I can see the reports and forms ok but I cannot see how the menu strip at the top of the report is coded.
Is there a way to find where this coding is. There is a button "Output" that call's the export to Excel but I cannot find the code or sub routine that is run for the export.

Thanks for your help.

Best Regards,

Steve.

If you view the form (which could be the menu strip itself or the form it's on) in design view you can go to it's properties and find the name of the form. Then find its reference in the Project Window. Alternatively, locate the Properties menu after highlighting one of the buttons. Click the 'Event' tab and there will be an 'On Click' box. That should get you where you need.

 

[Always_Learning]

Hi There,
Thanks for the reply.

It's not on a form but on a report. A thin strip at the top of the report, part of the window and has page setup, printer and this output button.
When I click on the button it gives 3 options, Analyse with Excel, open in word and send to mail with attachment.

Best Regards,

Steve.

 

[maw230]

Hi There,
Thanks for the reply.

It's not on a form but on a report. A thin strip at the top of the report, part of the window and has page setup, printer and this output button.
When I click on the button it gives 3 options, Analyse with Excel, open in word and send to mail with attachment.

Best Regards,

Steve.

Same goes for a report...Open it in Design View and look around.