Saving pdf files, Using Access 2007
I need to automatically save each file based on the account number, to a separate pdf file type. I need to dump these pdf files to a directory on my external drive. I already have the report created. Any help is appreciated.
jerryb30
Is this a report? So one PDF for each record?
ASKER
Yes
It is not clear if you already have a system to loop all "Account Numbers"
It is not clear if the Account number is text or a number...
It is not know the name of the table that holds the accounts...
It is not clear if you have the addin loaded for creating PDF...
It is not clear if this report is for the account (Parent) or for all the Child records (transactions, Balances, statements, ...etc)
the path to your external drive
It is not clear if the Account number is text or a number...
It is not know the name of the table that holds the accounts...
It is not clear if you have the addin loaded for creating PDF...
It is not clear if this report is for the account (Parent) or for all the Child records (transactions, Balances, statements, ...etc)
the path to your external drive
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't think Access 2007 needs an add-in to do PDF.
Jeff, I think your code would create multiple copies of the same report. Which included all records.
How do you call your report? From a query?
Jeff, I think your code would create multiple copies of the same report. Which included all records.
How do you call your report? From a query?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.