printing invoices to pdf files

[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

 

[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

bump....