Print from Access using VBA

Can I use PDFCreator to print directly from Access 2000 using VBA?

The process must be fully automated. No user input required!

Code samples will be appreciated!

Many thanks



If you have previously messed with excel doing the same thing then it should not be difficult from Access.

I use a code from Ken Puls ( to make pdf invoices and email them.

Works perfectly on XP, currently trying to fix it on Windows 7, the user rights are bugging me.

If you need help just let me know.