Hi Everyone,
Hoping someone wouldn't mind donating some time. I know the basics of VBA but I am trying to help out my father-in-law and I'm in over my head. He uses Access 2007 for a business database he runs. Here is the situation:
There is a report that when run asks for a date range (start and end date)
Once this runs, the report will generate 30-40 pages.
We want to:
(i) export to PDF (can do)
(ii) export to individual PDFs
(iii) give each PDF a filename from the fields on each exported page (ie. Client name + unique request number.pdf)
Thank you in advance,
PB.
Hoping someone wouldn't mind donating some time. I know the basics of VBA but I am trying to help out my father-in-law and I'm in over my head. He uses Access 2007 for a business database he runs. Here is the situation:
There is a report that when run asks for a date range (start and end date)
Once this runs, the report will generate 30-40 pages.
We want to:
(i) export to PDF (can do)
(ii) export to individual PDFs
(iii) give each PDF a filename from the fields on each exported page (ie. Client name + unique request number.pdf)
Thank you in advance,
PB.