databasedonr
Registered User.
- Local time
- Today, 09:25
- Joined
- Feb 13, 2003
- Messages
- 163
I have a database where I track department and personnel data, and from which I print a twice-yearly directory in PDF as a snapshot of both people and departments.
The data is updated regularly, and the PDF is primarily used as a reference for where people were at given times, as assignments change regularly.
Each time the PDF directory is produced, I "attach" it by storing the PDF in a specific spot in a network share and by writing data (the report name, report path and date) into a table, then display these directories on a form. Users can then open these "historical" directories by selecting the record they wish to view. I am currently using the FollowHyperlink command and passing the report path and name.
While this works perfectly - to open the document - what I'd like to do is pass a search parameter to the PDF document so that it opens the document navigates to a specific record, namely the department.
The resource form is visible on the Department record, so what I want to do is pass the department name as a search parameter so that the PDF opens to the specific page for that department. I've thought about using page numbers as well, but these vary depending on the number of records (people) I have when the report is created.
While FollowHyperlink works perfectly, as I say, I can't pass search parameters.
While I can stop where I am, I'd like to look the superstar and have the department directory display in the saved PDF report to match the department which the user is viewing in the database.
Any advice will be happily accepted (including telling the users to do their own search in the pdf once it's opened).
Thanks in advance very much.
The data is updated regularly, and the PDF is primarily used as a reference for where people were at given times, as assignments change regularly.
Each time the PDF directory is produced, I "attach" it by storing the PDF in a specific spot in a network share and by writing data (the report name, report path and date) into a table, then display these directories on a form. Users can then open these "historical" directories by selecting the record they wish to view. I am currently using the FollowHyperlink command and passing the report path and name.
While this works perfectly - to open the document - what I'd like to do is pass a search parameter to the PDF document so that it opens the document navigates to a specific record, namely the department.
The resource form is visible on the Department record, so what I want to do is pass the department name as a search parameter so that the PDF opens to the specific page for that department. I've thought about using page numbers as well, but these vary depending on the number of records (people) I have when the report is created.
While FollowHyperlink works perfectly, as I say, I can't pass search parameters.
While I can stop where I am, I'd like to look the superstar and have the department directory display in the saved PDF report to match the department which the user is viewing in the database.
Any advice will be happily accepted (including telling the users to do their own search in the pdf once it's opened).
Thanks in advance very much.
