Samantha
still learning...
- Local time
- Today, 14:37
- Joined
- Jul 12, 2012
- Messages
- 187
I have been attempting to come up with a way to automate some administrative procedures. I have little experience with VBA, I can do the basics. I have searched this forum along with the internet in an attempt to find a example.
Essentially, I have a table with a list of materials - Manufacturer, Product Name, Attachment(s). For every material it has at the minimum one file but mostly two PDF's. I would like to be able to select a job number then select products that will apply to that job (which I think I have that part covered) I would then like to run a report for the job allowing the PDF's to be viewable within the report (I have accomplished loading only the first page). Is it possible to get the document to load multiple pages?
My second thought is if I could select the materials then create a binder of the PDF's for the entire job executing within Access to be saved?
I am open to any suggestions!
Thanks,
Samantha
Essentially, I have a table with a list of materials - Manufacturer, Product Name, Attachment(s). For every material it has at the minimum one file but mostly two PDF's. I would like to be able to select a job number then select products that will apply to that job (which I think I have that part covered) I would then like to run a report for the job allowing the PDF's to be viewable within the report (I have accomplished loading only the first page). Is it possible to get the document to load multiple pages?
My second thought is if I could select the materials then create a binder of the PDF's for the entire job executing within Access to be saved?
I am open to any suggestions!
Thanks,
Samantha
