Topics Search

Link PDF files

Link PDF files
Views: 297
What would be the best way to link pdf files in an Access database form?

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,
Sponsored Links:

More topics

 

Importing PDF file into Access

Preview
I am running Access 2007. On my switchboard I would like to create a link to a stand alone PDF file located in a folder outside of the database. If I go to the External Data tab in Access it allows me to link to many different types of external files (text, HTML, XML, etc.). But I don't see any way to create a simple link on the switchboard that will open the PDF file. Is such a link possible to be made
 

Retrieving PDF's Efficiently

Preview
I created an Access 2007 database that I thought I was linking the files but it actually imports the PDF's into an Attachment field in Access. I have imported about 130 pdf's thus far and the table (which only has 7 fields) is already 14 meg. Do most users attach PDF's or do they link them?
 

Form Variable in Hyperlink

Preview
I have a load of pdf files located in a folder on our shared drive (k:/edid/) that I need my DB to be able to link to. I need either a hyper link on a label or a button in my form that when clicks uses the data from field (EDIDREF) to complete the link.so basically I need the hyper link to be k:/edid/45456.pdf with the number changed to whatever is in the EDIDREF field.
 

Link PDF on form

Preview
I have some PDFs named like "PB_(ID).pdf" in a fix directory like / (root).
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
 

Hyperlinking in Access 2000 to .pdf

Preview
In my job I am linking .pdf files to an access database (Windows 7, MS Access 2000). I have already done thousands, and it is an ongoing project.

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?
 

Report Hot Link in PDF

Preview
I have a need to add to add some hot links to websites in Access reports. I've inserted a logo in a report and set it's Hyperlink Address. In Preview mode the report hot link works great. However, I need to output the report to pdf (I'm currently using the PDF/XML addin from Microsoft).

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.
 

Security / Error prompt

Preview
I am getting the error pop up. I am using the following code to open files on the server, and want to know how to keep it from asking.prompting this every time. Is there a better way to code it to prevent this, or is it unavoidable?

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)
 

Linking files to Access

Preview
I have been asked by my employers to create a document retention system.

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
 

automated PDF file from reports

Preview
We have many reports we manually save to PDF files and then print. This can take hours just saving to PDF and printing.

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
 

merging PDF files

Preview
I am using PDFCreator to print reports to files which works fine. Is there a way to merge the files into one (1) pdf file? I am using VB code to do this