Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

A weblog about Microsoft Access, SQL Azure, and SQL Server Tips and Code Samples
Browse by Tags · View All
Access Tips 45
Microsoft Access 45
VBA 41
database 33
Access 33
Code 32
Software development 31
Microsoft Access Software Development 26
Free Access Downloads 25
Software 25

Archive · View All
October 2010 4
September 2008 4
June 2009 4
January 2008 3
July 2009 3
June 2007 2
May 2009 2
March 2011 2
July 2010 2
August 2011 2

Patrick Wood's Blog

Use Access to Organize and View Your Photos and Graphics

Jan 17 2008 8:22AM by Patrick Wood   

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.


Republished from Access Easy Tips [18 clicks].  Read the original version here [32134 clicks].

Patrick Wood
101 · 2% · 521
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]