Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to auot export a report
- Thread starter udik
- Start date
Hi,
Use VBA to control it.
Look at 'export report' in Access Help to understand how to export a report to HTML.
Regards,
Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk
Use VBA to control it.
Look at 'export report' in Access Help to understand how to export a report to HTML.
Regards,
Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk
Try this it works great for me.
DoCmd.OpenReport stDocName, acViewPreview, , criteria
DoCmd.SendObject acReport, stDocName, acFormatRTF, eaddress, , , "Open Orders", "Open Orders", 0
DoCmd.Close acReport, stDocName
The first DoCmd line executes the report. Need this if the report needs some type of criteria
The DoCmd.SendObject line produces the last open report. Check out the on-line help
The last DoCmd closes the report for you.
Hope this helps
DoCmd.OpenReport stDocName, acViewPreview, , criteria
DoCmd.SendObject acReport, stDocName, acFormatRTF, eaddress, , , "Open Orders", "Open Orders", 0
DoCmd.Close acReport, stDocName
The first DoCmd line executes the report. Need this if the report needs some type of criteria
The DoCmd.SendObject line produces the last open report. Check out the on-line help
The last DoCmd closes the report for you.
Hope this helps
- Status
Similar threads
- Locked
- Question
- Locked
- Question