T
tomyork
Guest
I need a way, preferably in VBA (as I could create an external app quite easily but I do not wish too), of getting my access database (MSA2000) to print a report to a PDF printer *and* to ensure that it saves the outputed PDF file to a specific directory with a specific name. The thing is that the file name and directory name will change according to a customers ref. For example: if I have a form open that shows info for a customer ref 123, I want to be able to click on a button and the script needs to create a report in PDF and store in the directory C:\Example\123\Invoice123.PDF. Similiarly if the customers ref was 456 I would want it to create the PDF in the following directory: C:\Example\456\Invoice456.PDF. I can create the PDF files fine. It's just setting up the automation - so that the user is not required to do anything other than click a button in a database! Even if there is a way of outputting the file to a set location with its file name being the a specific variable (Ie a users ID number) and then getting the database to copy it to a new folder (named identicle to the file) in a set location.Thanks alot for your help. I really appreciate it. If anyone needs anymore info please let me know. Good Luck! Tom
