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.
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.
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?
However, there are 3 links I want every record to display that are unique to that supplier.
These links are PDFs that we have scanned into our system and are sitting in a share folder. Right now I have the buttons hyperlinking to the folder instead of linking it to the actual PDF because for me right now it is a static thing and every record in the form will link to the same place.
Is there a way where I can make these buttons supplier specific and have them link to a different PDF for every record/supplier.
This works fine, and I can choose a relative link (relative to the database) or a direct link (c:\folder\file.docx).
I would like to proceed a bit, and also print the linked files from a button, and preferably without opening the files, Or perhaps, as Windows when right-clicking on af file and click Print (opening the file, print it, and close it again).
Our item master table had a link field that, on click, would open up the PDF drawing files on the system. Unfortunately, the links appear to be setup as "\Drawings\.pdf". Instead of "\\\Database\Drawings\.pdf"
The hyper link was c:\workfiles\data
Now I moved my database to the company server with all data and hypelinked files.
The new location is oa-server1\eng\workfiles\access\data
the problem is that the hyperlink is not working any more and I need to re-link each record again.
My question: Is there a way to tel access to find the new location of the linked files.
I have a folder with multiple files in, some .doc, .pdf , .msg, .jpg and I was wondering if there was anyway of producing a single pdf file of of these. It would have to be automatedand I will be doing this multiple times.
I have managed to get the list of filenames into Access and into a table (thanks to Allen Browne!).
I think there are two ways of doing this.
1. Create a PDF of each file in the folder and then merge them together
The problem I see with doing it this way is how do you create a pdf of a file that isn't open(aka the .doc)? Or create pdf of a jpg from within Access?
2. Create one file, no merging, of each of the files.
What do you want to do?
* Learn about PDF and XPS file formats
* Install and use the Save as PDF or XPS add-in from Microsoft
* Install a third-party solution