Use Access to Organize and View Your Photos and Graphics

You can easily create an Access Database to organize and view your photos and graphic images.  You can store your images in Access tables but it takes up an enormous amount of memory and bloats your database.  It is best to keep your images and graphics in a Directory on your hard drive.  You can then store the path to the image, including the image filename, in a table.  Then you can create a Form to find and view your images.

Here is an easy code snippet for your Form that will allow you to view your images:

' You can use this code with a command button or with the double-click event on the textbox that contains the image path.

    ' Declare a variable for the image path
    Dim strPic As String
    ' Associate the variable with the image path
    strPic = Me.txtImagepath    ' txtImagepath-a textbox that holds the image path
    ' Open the image
    Application.FollowHyperlink strPic

Your image will be opened by the default Windows program for that type of image.

This will allow you to give your family and friends a zipped copy of your database and images.  Just be sure that the images are stored in the same directory and path on their computer.

To download free databases and code samples visit our Gaining Access Website.

Get the free Code Tracker™ Beta Add-in to record and then view how your procedures are being used.

You can download the completed and free Report Date Dialog Form in the US or UK Version at our Gaining Access website.

More Free Downloads:
Pop-up Calendar
ScopeSight for Access Reports Demo: get the exact data you want on your Access Reports.
Free Church Management Software now with new Contributions management.
Code Samples

Get the Access and Outlook Appointment Manager to manage all of your Outlook Calendar Appointments and Access dated information.

Happy computing,
Patrick (Pat) Wood
Gaining Access

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 84 other followers

%d bloggers like this: