Copying Reports to Network

[jh3016]

I have about 10 reports that I need to copy to the network every evening as .snp. Right now, I am exporting them as .snp one by one.

Is there a way to do this with one click? Or even better - automatically?

Thanks in advance.

 

[KenReay]

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 -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[RoyVidar]

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

 

[xuereveds]

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