printing invoices to separate pdf files...

K

Karen

I want to print invoices to pdf files using Access. The data will
come from my SQL tables that are part of my business software. I
want
to make pdf files out of the invoices so I can email them to
customers
as they are requesting. What I want to do is print the invoices as
usual in the business software and then have Access 'print' them to
individual pdf files (by invoice number). I was thinking I could
have
a do while or something like that in code to do that. Can someone
point me in the right direction?

I can do the report layout and have made pdf files before using
ConvertReportToPDF. But I need help with the do while.


I am using Access 2007 and work mostly with Access2000 files.


Thanks!


Karen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top