Open pdf document read only
Private Sub OpenPrint_Click() Dim PDFPartPrint As String Dim AdobeProgramPath As String Dim RetVal As Integer AdobeProgramPath = "C:\Program Files (x86)\Adobe\Reader 10.0\Reader\AcroRd32.exe " 'Hard coded program executable path! PDFPartPrint = (AdobeProgramPath & Forms![frmCustomers]![Child4].Form![Part Drawing Path]) ' Combined Program executable path and part drawing path! 'MsgBox (PDFPartPrint) RetVal = Shell(PDFPartPrint, vbNormalFocus) End Sub
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have a Access database which I have a record where I attached a .pdf document.
Everything is going smovely until I open the document. When I close the .pdf document give me this error:
When I ex. make a google search and find a pdf document - I can open it inside the control - no problem. and the PDF reader save functions opens too.
But I need to save the document in my database og local ex. pdf-file
LastName | FirstName | OPEN | Date | Notes | etc
I would just like to click the word OPEN and have the PDF associated with that contact open.
Lets assume the file will be in PDF format in a specified folder and that the first 4 charters in the document will be the unique client ID followed by the description of the type of document. Something like 3980 Offer Letter.pdf
Can I have access evaluate that folder and only display those files that are have to do with that client in a form where only that client information appears? Also if the user clicks on the file it needs to open.
Is this possible and if so can someone give me an article or advice of what I can do to make this work.
Maybe I am going down the wrong path and there is another way to accomplish this.
I thought of hyperlinks but not sure if that would be virtual
Now I want to make things a little faster.
I now receive by email a PDF form (or file) filled in by a customer. I open it with Acrobat Reader and then manually enter the information contained in the PDF file into a new record in my database.
Now I would like my application to read that file and fill in a new record by itself.
Would somebody know how to do this or at least put me in the good direction
Does anyone have any ideas how I can do this. Basically we are are wanting to put certificates within the document.
If I drop/drag the document into the table I get the "Adobe Acrobat Document" type that allows me to double click to open.
If I copy the same file using VBA, the "Long binary data" type doesn't allow me to open with double click.
Any ideas how to convert the file to a PDF format during, before, or after I copy the file to the table? I don't see any way to cast the file to be an OLE Object of PDF type. Any help - great appreciated.
Dim curDatabase As DAO.Database
Dim MyTrackingTable As DAO.Recordset
Set curDatabase = CurrentDb()
Set MyTrackingTable = CurrentDb.OpenRecordset("TrackingTableName")
MyTrackingTable("Report") = PathToFile + "DaileyReport.pdf"
The database allows a user with permissions/full access to open the database, but if it is already open by one of those users it does not default to the usual read only document.
This message pops up. "Could not lock file" and then it goes to the Access home page where you end up when you open the Access program from scratch.
Any ideas on how to get it back to just having read permission when someone is using the database?
My pdfs are located in a folder on the c: drive
All I want to do is open them and display them on the screen, I would then like to email them as an attachment