Manuale Access 2003 Pdf Viewer
.Private Sub Command1Click.On Error GoTo ErrCommand1Click.Dim stAppName As String.Dim stPathFileName As String.' Define path and file name of PDF document, keep.pdf extention.stPathFileName = Me!txtPathFile.stAppName = 'C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe ' & stPathFileName.Call Shell(stAppName, 1).ExitCommand1Click:.Exit Sub.ErrCommand1Click:.MsgBox Err.Description.Resume ExitCommand1Click.End Sub.This obviously depends where your Acrobat reader file is locatedS7. If I have to add the active x for pdf file at the main form to display the first row of record at the subform, can it be done? Or I have to click the row of record at the subform then display the corresponding pdf at the active x display? (The subform consists of a row of scroll down text boxes.)How to do that in steps?Besides, will it be a lot of acrobat buttons occupy the screen when I use the active x to open the pdf file at the main form? Can I control that just like for the tiff and jpg viewer (just picture and no other button eg zoom.etc.)?For time being, I think I will need:1.
Add the active x at the main form2. I may need a code to add the text boxes (may be for the click event).3.then I dont know how to make the code and also how to make the active x know how to display the corresponding pdf file when the user scroll down the subform or click the text box at the subform.Hope that you can understand and really looking for any kindly help!Thanks once again! Hi JoThe code I showed in my last post was to start-up Adobe Acrobat in a separate window and automatically display the document specified in the Path. I thought it best to associate a command button with each record and then click to display the document as needed.
This works.I was not using ActiveX components and not trying to display the document inside a window/box/control on a form. My assumption being that a PDF file would be trying to show one or more A4/Letter size pages which would not be easy to read in a small window.I'm sure there may well be ActiveX products that can be added into Access to allow displaying PDF's in an 'Image Control'; I've never needed to look for one, but I would expect instructions how to use it to be provided by the software supplier.I will look into this further and am currently checking AcroPDF.dllS7.
Access 2016 Vba Programming Pdf
Manuale Access 2003 Pdf Viewer Online
I have sucessfully added the OLE bounded object at the main form.The OLE will display the pdf file when the preview button at the subform is clicked with the following codes:Private Sub PreviewClickFormProjectDrawingForm.OLE1.Class = 'Adobe Acrobat 7.0'FormProjectDrawingForm.OLE1.OLETypeAllowed = acOLELinkedFormProjectDrawingForm.OLE1.SourceDoc = Me!ImageLink.ValueFormProjectDrawingForm.OLE1.Action = acOLECreateLinkFormProjectDrawingForm.OLE1.SizeMode = acOLESizeZoomEnd SubI have problem here:1. What will be the code change if the value Me!ImageLink.Value (the value is in fact the full path of the pdf file e.g. G:abcabc.pdf) is empty or the path is wrong or the file is not exists and let the OLE object display back as a blank white?2. In fact, there is a reset button in the main form, what code I should add so that the OLE object can reset to blank.Thanks!