Search results

I have the following in my Access 2000 DB... One Macro named "Report" with a RunCode action and the following Function Name - OutputToReport() One Module named "Module1" comprised of the following code... Function OutputToReport() DoCmd.OutputTo acOutputReport, "Budget Summary Report"...

Thanks for the reply. That's exactly what I did, and it worked fine. But, when I tried to execute on the main production server, I get the following error message... Run-time error '2202' you must install a printer before you design, print, or preview. Any ideas?

I have the following batch file which executes my one Access macro... "c:\program files\microsoft office\office\msaccess.exe" d:\Nick\Budget.mdb /X BMS is it possible to have this execute several macros?? Thanks beforehand.

Everything worked great. Thank you so much. But I wanted to see if I could tap into your knowledge base one more time. In my macro in Access, I'm having to output to a specific folder and listing the file name, for example...D:/Reports/bms.doc in the Output File in the Action Arguements box...

Ok. What a great idea. I did the following, but I'm still getting a popup that reads "File already exists, replace yes or no". What if I were to include some code in the batch file to delete the file each time or something to this degree. Also is it possible to shut down the program Access...

Thank you so much for the reply. The code thing is totally new to me. If I go with the code, do I insert this into my webpage? Or perhaps in the Access Database someplace? Thanks again!!

where would I input this code? In the Action Arguements in the specific Macro design view or perhaps a condition?

Thanks so much for the replies. Much appreciated. I'm presently using ColdFusion, and would actually jsut like to on my CF page to display a link like the following.<a href="Reports/BMSreport.doc">Budget Report</a> , then jsut run a macro daily to export the access report into Word and placed...

I'm to the point where I'm desperate!! I have an Access 2000 DB which consists of several reports. I can export each report into Word Files or htm files easily and then post them on the web. But I was wondering, if it was possible, to somehow write a macro? or something to do this...