Access, Visual Basic and pdf-documents
Access, Visual Basic and pdf-documents
(OP)
Hi!
Can anyone help me with this?
I want to add a commandbutton to a form in Microsoft Access, that will open a pdf-file located at a specific place on our server. the name of the document is stored in a table.
Any VB-code for this?
Can anyone help me with this?
I want to add a commandbutton to a form in Microsoft Access, that will open a pdf-file located at a specific place on our server. the name of the document is stored in a table.
Any VB-code for this?





RE: Access, Visual Basic and pdf-documents
Private Sub Form_Current()
On Error GoTo err_Form_Current
If Me.Command119.hyperlinkaddress <> (Me.DocumentPath) Then ' updates hyperlink
Me.Command119.hyperlinkaddress = (Me.DocumentPath)
End If
If DocumentPath Like "*jpg" Then
Me!Picture.Picture = Me!DocumentPath
ElseIf DocumentPath Like "*.bmp" Then
Me!Picture.Picture = Me!DocumentPath
Else: Me!Picture.Picture = ""
Me.Command119.hyperlinkaddress = Me!DocumentPath '(Me.DocumentPath)
Me.Repaint
End If
If the document was an Image, It would show up in the form.
Maybe this will get you started.
Gerald Austin
Iuka, Mississippi
http://www.weldinginspectionsvcs.com