Automate Export to Excel upon Close of Database?

G

Guest

I am wondering if there is a way to automate the export of Access
information, in this case Form information to an excel sheet automatically
when Access is closed or updated.

The problem is we have users who are not remeber to export the data each
time they update it. We have another piece of software which references and
links to information in that excel file.

Is there a way to automate this process so whenver the user closes Access or
saves that the export to excel is automatically completed without them
remeber how to do it?
 
G

Guest

You need a form that opens when you open the application and stays open until
you close the application. It can be hidden. Put the TransferSpreadsheet
code in that form's UnLoad event.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Each Record to Separate Excel File 3
Exporting multiple queries into Excel workbook tabs 10
Access to excel, export? 1
Export to excel file in Access 1
Exporting data in Access fields to cells in Excel 4
Export to excel with pictures????? 1
Export Access Report to Excel 4
Automate query export? 2

Top