?
Solved

Embedded Picture in ACCESS 2003

Posted on 2011-04-18
9
Medium Priority
?
314 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.
0
Comment
Question by:sglee
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 75
ID: 35419373
"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
0
 

Author Comment

by:sglee
ID: 35419426
DatabaseMX:
Thanks. I will try it and get back to you.
0
 

Author Comment

by:sglee
ID: 35419667
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?
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 75
ID: 35419686
"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
0
 
LVL 44

Expert Comment

by:GRayL
ID: 35419773
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
0
 

Author Comment

by:sglee
ID: 35424930
GRayL:

 Is this based on DBPix solution or pure VB coding in ACCESS 2003 without 3rd party solution?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 35425568
0
 

Author Comment

by:sglee
ID: 35425655
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.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35426465
;-)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question