• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 681
  • Last Modified:

ms/access 2013 records/forms with pictures

I have a database that has personal record for which I want to associate a JPG picture, to be shown embedded in a form or a report, and want to associate a PDF file that can be shown after the press of a button.

How do I do it?
Both the pictures and the PDF file are external to the Database and not embedded
João serras-pereira
João serras-pereira
1 Solution
Dale FyeCommented:
1.  With the JPG image, create an image control on your form, but don't assign it a picture property.  Assuming you have a field in your underlying data that contains the name of the JPG and the path to it, use the Current event of your form to assign that path\filename to the Picture property of your image control.

Private Sub Form_Current

    me.imgPhoto.Picture = me.[PicFileName]

End sub

2.  For the PDF, you will also need to have a field in your underlying data which contains the path\filename of the PDF file.  I usually use a text datatype, but you could use the hyperlink datatype.  I then place a button next to the textbox that displays that path\filename and use the Application.Followhyperlink method in the CLICK event of the button to open the PDF

Private Sub cmd_OpenPDF_Click

    application.FollowHyperlink me.txtPDFFilename

End Sub

untested code sent from my iPad.
João serras-pereiraAuthor Commented:
Dear FYED, many thanks for your prompt and excellent answer. I will now use it.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now