Button To Export To Excel

[rajeshsarin]

Hi Folks,

I want to create a button called "Export To Excel". Then embed code behind this button, so that when ever it is clicked it open the displayed report in excel format.

I want to then place this button on any report that I create in my database, and upon clicking that button I want the displayed report to open in an Excel File.

So basically I wish to create a standardised function that I can call from any report.

Regards - Raj

 

[vbaInet]

For your first question, Access has a Import & Export button that you should find in the toolbar or ribbon.

Regarding your second question if you're using Access 2007 and above there's also a button in the ribbon for outputting your report to pdf format. If you're using an older version of Access, search the Internet for Stephen Lebans print to pdf.