asked on

Printing to Adobe from Access

I have reports setup in Access 2002.

I dont think I can do this from a macro but hopefully from some VBA coding.

I have approximately 50 pages to the report
Each page needs to be printed on a separate sheet with a separate name pulled from a Name field in Adobe 8.0

can someone point me in the right direction

ASKER CERTIFIED SOLUTION

UniqueData

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LennyGray

If you have Adobe installed on your computer, open up a Word Document and select File -> Print.

When you see the printer selection dialog, look to see if you have an entry named "Adobe Printer". If you do, then you can select this printer from Access by choosing the correct printer. Refer to this link for that step: https://www.experts-exchange.com/questions/11452938/Select-Printer.html?sfQueryTermInfo=1+access+printer+report+select

Good Luck!!
Lenny Gray

Pdeters

ASKER

in installed the module with code (WOW - GREAT)

Only problem is it is asking for a DynaPDF.dll

I have Adobe Acrobat 8 Professional installed to create PDF files. I Get this error when i try and run the If then statement

Sorry cannot find the DynaPDF.dll file
please copy .......

I did a search on my computer and I do not have it.

What doy ou suggest??

UniqueData

Sorry, I didn't realize that you have Acrobat Professional.

Please use Lenny's comment.

UniqueData

I can not attatch the

UniqueData

I attempted to zip the dll files you need to make the code run but apparently it is not allowed to send dll files on this site. Therefore if you wish to continue with the code here and completely automate it without picking a printer then I will need an email address to send you the two dll files in a zip file. You will have to have the dll files in the same directory as your db in order for it to work.

Pdeters

ASKER

Can you send it to
pdeters01@comcast.net

We want to get this fully automated if possible.

Thanks

UniqueData

Pdeters, Have you recieved my email with the DLL files?

Pdeters

ASKER

Yes I have. Thank you!!

UniqueData

So does it work?

Pdeters

ASKER

Thank you!!!! It works great!