Converting Access Reports to Adobe PDF's

[invictus]

I have no trouble converting the Reports to PDF's, my problem is that I have to save these to a network drive and I am trying to find a way to automate the process. I am not familiar with VB and have tried using a macro to do it, but I am still hitting a wall. I made a macro to convert the report to a PDF, but I have no way of getting it to save to the network drive automatically. Any suggestions?? Any help would be GREATLY appreciated!!!!

 

[jeremie_ingram]

You could create a batch file that would copy the files over for you, then call it from access in the chain of automated processes.

Save the created PDFs in one file (c:\PDFS), then open NOTEPAD and enter the following.

MOVE C:\PDFS\*.pdf H:\PDFS\ /Y

The H:\PDFS\ would be the actual server location where you would want the files moved to. If you are wanting to overwrite existing files with files of the same name, add the /Y parameter to the command and it will overwrite without prompting.

Save the file as MOVEPDF.BAT and you can execute it to move the files. If the system is automated, and you are useing a Microsoft OS, you can even put it in the scheduler to occure regularly. This could run regardless of new PDFs, since it will only move what is availible in the folder.