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.
Here is SOME of the code from a form I use to track documents. The table behind the form has a hyperlink field and document path field that supplies data to the hyperlinkaddress property of the command button.
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.