Include pictures (jpg/gif) on forms

[collizz]

I am putting together a query-based form for an auction, that needs to include an image of each item retrieved.

One of the columns in the source table contains the name of the picture file (e.g. "pic001.jpg","nopic.jpg") to be displayed for each row retrieved.

How do I link this text with the presentation of that image on my form?

I have a pretty sound knowledge of SQL and I'm fairly comfortable with Access.

All contributions welcome!

 

[Sergeant]

Look here... http://www.access-programmers.co.uk/forums/showthread.php?t=101527
Post the code in your form's OnCurrent event. You need to add your path in front of the picture file name...
Me.MyImageControl.Picture = "c:\MyFolder\MyPics\" & Me.txtPicPath)

 

[collizz]

Thanks a lot, Sergeant.
I haven't coded in a while but, despite the Access interface, I made my way through it! Now if I can just create a portable version of it, I can work at home instead of the office ...