Adding Buttons to Report

[jamiesuperman420]

Hello!! I want to add an "Export To Excel" button in a report. When I add the button and go to properties, there are no options for events or data. I'm trying to put the button in the Report Header... Am I doing something wrong or is it impossible?? Thank you!!

 

[pbaldy]

What version? Prior to 2007, you couldn't click a button on a report anyway (and in 2007, only in the new report view), so there were no events associated with it.

 

[jamiesuperman420]

Ah, that must be it - it's Access 2000. Well, good!! Less work for me!! Thank you - I'll just tell 'em to go to File > Export if they want it in Excel.

 

[pbaldy]

If they really want it, what I do is create a custom toolbar with a button that runs a function that does what I want, and display that toolbar when the report is open.