We help IT Professionals succeed at work.

Embedded Picture in ACCESS 2003

sglee
sglee asked
on
336 Views
Last Modified: 2012-05-11
Hi,
 
  I created a table that has part information - Part number, description, PICTURE ... etc.
  I have Pictures in BMP format and I created filenames for them and stored them on the network older.
  How can I create a Part data entry screen where I can display the photo of each part WITHOUT storing BMP file as a part of the MDB because I know it will make the MDB larger real quick.
 I created a text fileld which stores the file name and path of the part picture. I like my parts form to go grab & display the picture based on the filename and folder location stored in the field on the same record.
Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
"because I know it will make the MDB larger real quick. "
Just be aware of this product, which avoids that issue:

You might want to consider this or at least be aware of if you are dealing with images in an Access database ... and I can totally vouch for this program.  
http://www.ammara.com   >>> DBPix ...

It does *all* the work for you. Examples show how to add a simple 'control' panel to Load, Save, Zoom In/Out, Size To Fit and much more.  AND ... virtually eliminates BLOAT associated with storing images in an Access MDB. I have 3 clients who sell commercial run-time products that use DBPix.

Note. I have no connection with DBPix ... except I have used it many times ...

mx

Author

Commented:
DatabaseMX:
Thanks. I will try it and get back to you.

Author

Commented:
DatabaseMX:
I downloaded DBPix from their website and installed the program on my computer.
What am I supposed to do next?
Do I create my tables and forms in the sample database or
the installation of DBPIX program has applied necessary updates to my ACCESS 2003;therefore use my own ACCESS 2003 and use the new control/feature?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
"therefore use my own ACCESS 2003 and use the new control/feature?"
Yes ...
Look at the sample db for code, etc.  Also, how to set up a control panel for handling images.  Pretty sure that are on KB's on the website.

I haven't looked at the demo db for some time now.

mx

Commented:
Add a text field to your tblParts named PicPath  -  it would contain values like c:\PicData\Part1.bmp.  In the form displaying the part info add a new unbound Image control named imgPic. In the form's Current event add this code:

Private Sub Form_Currrent()
  Me!imgPic.Picture = Me!PicPath
End Sub

Author

Commented:
GRayL:

 Is this based on DBPix solution or pure VB coding in ACCESS 2003 without 3rd party solution?
MIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
boag2000:
Thanks for the real example. I tried it and worked well.
It does not look like it is storing the actual image in the database, so I don't have to worry about database size getting big over the time either.
This solution kills two birds with one stone.
Thank you again.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
;-)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.