View Pictures in Access Form

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

I have a form with various combo boxes on it and have added a bound ole
picture box also to the form. When the user changes the value in the combo
I need the picture to change on the form. The underlying table of the combo
stores the model code, which is the bound field, the description and the
image.

How do I get the picture to display, and change if the combo box is changed?

I have created a auto form from the table and this displays the picture OK

Thanks Andy
 
andy said:
I have a form with various combo boxes on it and have added a bound ole
picture box also to the form. When the user changes the value in the combo
I need the picture to change on the form. The underlying table of the combo
stores the model code, which is the bound field, the description and the
image.

How do I get the picture to display, and change if the combo box is changed?

I have created a auto form from the table and this displays the picture OK

Thanks Andy
Click to expand...


To show the Image in a Form is better ImageControl, because OLE
bound Control use a lot of Memory, and your DB grow up........!

You need only 3 things:
1)ImageControl in a Form UNBOUND control
2)Add a new Field in your Table named FullPath(String 255) to Store the full
PATH of Image to load...!
3Add in a Form a new textBox bound to a new Field

On After_Update Combo event's load the Picture in ImageControl like this:

Me.NameOFImageControl.Picture=Me.ControlAssociatedtoPath

P.S. remember ......You are allow to load only BMP,JPG,WMF,EMF,ICO.....!

Bye.

Alessandro(IT)
 
Three approaches to handling images in Access are illustrated in the sample
databases at http://accdevel.tripod.com -- the downloads also include an
article discussing considerations in choosing a method to use.

Larry Linson
Microsoft Access MVP
 
Back
Top