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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copying Reports to Network
- Thread starter jh3016
- Start date
Hi
To do it with one click you just need a command button that runs all 10 reports so
DoCmd.OpenReport "REport1",..etc
DoCmd.OpenReport "Report2"...etc
..etc
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
To do it with one click you just need a command button that runs all 10 reports so
DoCmd.OpenReport "REport1",..etc
DoCmd.OpenReport "Report2"...etc
..etc
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
Hi
Perhaps try the outputto method of the docmd object:
[tt]docmd.outputto acoutputreport, "rpt1",acformatsnp, "c:\test\rpt1.snp"
...per each report[/tt]
As for automatic. Hmmm - you could explore the timer event of the form, for instance. But that would involve that the form (app) would have to be open at a given time each day - and perhaps also log if the current days report is alredy run... Or perform such on the on close/unload of the "last" form of the application (also recommend doing a test for wether "todays" reports have been run...)
Roy-Vidar
Perhaps try the outputto method of the docmd object:
[tt]docmd.outputto acoutputreport, "rpt1",acformatsnp, "c:\test\rpt1.snp"
...per each report[/tt]
As for automatic. Hmmm - you could explore the timer event of the form, for instance. But that would involve that the form (app) would have to be open at a given time each day - and perhaps also log if the current days report is alredy run... Or perform such on the on close/unload of the "last" form of the application (also recommend doing a test for wether "todays" reports have been run...)
Roy-Vidar
Hi,
As RoyVidar says you can use the docmd.OutputTo command which will output this for you......as for automatic you could be a little cheecky and create a dummy db that has links to your original.....what you do with this then is lock it down and have a startup for on open of the db.....with this form you use the on load event to run the code that will export your reports either in turn or using recordsets and then closes the db......after completing this you would need to set a scheduled task on your box or whatever location to simply open the db this will then fire the form and on load procedure and will run your code automatically for you.
there are other ways but there just not as cheeky as this!
xuereveds
As RoyVidar says you can use the docmd.OutputTo command which will output this for you......as for automatic you could be a little cheecky and create a dummy db that has links to your original.....what you do with this then is lock it down and have a startup for on open of the db.....with this form you use the on load event to run the code that will export your reports either in turn or using recordsets and then closes the db......after completing this you would need to set a scheduled task on your box or whatever location to simply open the db this will then fire the form and on load procedure and will run your code automatically for you.
there are other ways but there just not as cheeky as this!
xuereveds
- Status
Similar threads
- Locked
- Question
- Locked
- Question