×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Access, Visual Basic and pdf-documents

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?

RE: Access, Visual Basic and pdf-documents

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources