Access, Visual Basic and pdf-documents

[MildJoe]

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?

 

[pipewelder1999]

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.

Maybe this will get you started.




Gerald Austin
Iuka, Mississippi

http://www.weldinginspectionsvcs.com