Link PDF files
For each record there could be more then one pdf file. I would like to automate the process as much as possible. The pdf file would exist on a network drive and the user would need to go to their record in Access and then link the pdf files.
I started but am having problems with Access not opening the pdf file, it will open word files but not pdf,
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have a DB in the same directory and the ID of my data is equal the pdf document.
My question is how can I create a dinamic link in the form to view a PDF file? Like this: I find an client for your ID: 12345. In the form with more details from "12345" I have a button that is a link to PB_12345.pdf. I know that I can make one by one, but I have a lot of IDs
My issue is that in linking I open the “Insert Hyperlink” window, click on the “File” button, which opens a “Link to File” window. The default that is in the box “Files of type” is Office Files.
For every link I have to change it to “All Files (*.*)” and it would save me so much time for the default to be “All Files (*.*)”. Is there any way tochange the default for this?
So far I've not been able to make the pdf recognize the logo as a hot link. The pdf willrecognize a URL string as a hot link.
The files are in G:/Fire/Private/PDF PFP/ and every file is named after the Pre-Plan # (ie. A01.pdf, A02.pdf, A03.pdf, etc)
They recieved two documents from the customer which are scanned in as two separate PDF files. The PDF files are stored on the scanner units memory.
The scanned documents are accessed from a web interface.
The PDF will be downloaded and then saved to a folder.
The user will then link the file in the database by entering the file path into a field. (how?)
VBA code will be executed to rename the file, move the file from the original path and dump it in a central folder.
A shellexecute script will be used to open the files from within access. (this is covered)
So how do I go about llinking the files? I have never used access as a 'document server' before. Is there a way to have a file upload window where the user can navigate to the file? I can do the renaming bit all fine, just need to actually get the files path
Once a report opens we touch our PDF icon on our tool bar(I believe this was downloaded). Then it saves to PDF as if it was printing( I guess this is the norm since we have PDF printer setup.
I would like to save(pdf format) and print theses reports automatically(button) on form.
The name I would like the pdf to be is(reportname-datestamp).
I'm having issues because of the PDF format