AboutScottgem Expertise I can answer some questions on a wide variety of business applications, including MS Office, Lotus Smartsuite, Visio, Notes and many others.
Experience I have over 16 years of experience as an IT professional, supporting a wide variety of business applications.
Question I have a report that I have generated in Access. this report is created to disperse information via Email. I have also created a hyperlink on the PDF back to Access.
In order to not only open Access, but open a form and filter the form, I have use a batch file to store the information needed and then transfer it into Access.
In order to get the batch file to change to filter to the right record, I have used a File I/O to bring in the file and revise the text in the batch file before it is sent out. I have done this because I couldn't figure out how to pass parameters into the batch file from a hyperlink.
The only problem is, this code only runs when the report is opened in Access, not in Adobe as a PDF. I need it to run in Adobe when the PDF document is opened as well.
Do you know how to write code in Access that will execute in Adobe during the open event?
Answer I don't think you can control a PDF file from within Access. But I'm really not clear what you are trying to do. Can you give me an axamle and details steps from your workflow?
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
