Print Page | Close Window

Pictures.mdb (beginner)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=298
Printed Date: 22 Nov 2019 at 2:53pm


Topic: Pictures.mdb (beginner)
Posted By: Roger Carlson
Subject: Pictures.mdb (beginner)
Date Posted: 28 Jul 2008 at 11:15pm

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 

Pictures.mdb

It is usually preferable NOT to store OLE objects like pictures in the table itself. It causes massive database bloat. The usual solution is to store the pictures as files on the hard drive and store the file name in the table. This sample demonstrates how to to this.

1) Store the pictures (in this case JPEGs) in the same directory as the database. 2) Store the appropriate picture name in the table. 3) Programmatically set the .Picture property of an Image Box to the appropriate file in the On Current event of the form.
 
Download
Access 97 (231 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/Pictures97.zip - uploads/5/Pictures97.zip
Access 2000 (163 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/Pictures2k.zip - uploads/5/Pictures2k.zip



-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window