Form: Create Folder & Auto Save PDF

[Molly001]

Good evening!!

I have a database at our company.

When dispatching equipment we enter the address and details onto a form.

The data on this form saves into a table.

The form always opens on next record so at the minute for example its 22900.

I would like instead of printing a copy for the company, for a button to click on the form to do the following:

Save "current record" with all data entered by user into a folder on the computer automatically with a file name of ""current date""customername"".

It would save in a folder also called "current date" if this had not already been created i would need the code to firstly create this prior to saving the file as a pdf.

Any advice would be great!

Thanks.

Molly

 

[John Big Booty]

You can use the OutputTo method to save your file to PDF in a specific folder, so long as you are using Access '07 or newer.

See the discussion here regarding the checking for and creating folder, which you would need to do prior to calling the OutputTo method. This is probably the important link from that thread.

 

[Molly001]

Thanks for your responce.

I am currently only running Access 2003.

Does this take .PDF out of the equation or could i install any add ons to allow?

If not, what is the nearest best solution in terms of type of format of the output to use?
Once the file is created this is mainly just for back up purposes but i would like to view on my computer screen.

Thanks.

Molly

 

[John Big Booty]

With '03 it become a little more tricky. I believe that I saw or heard of some code that would do it for you, I just can't find it at the moment if I stumble a cross it I'll post a link.

 

[Molly001]

That would be greatly appreciated.

Thanks love.

Molly

 

[John Big Booty]

I believe that the post this link takes you to explains how you can use the OutPutTo method to print your document to PDF from Access '03. Whether or not it can be fully automated I'm not sure