In a recent forum message, Andrew wrote:
"I have been trying to achive something for some time now and was wondering if anyone could help out. I have a database with contains information about products. One the fields is called "product id" which changes with every entry or page of the form.
I would like to display on the form either picture or a hyperlink to the picture of the product. I have all the pictures of the products saved in the same folder as the database. They are named as "product id.jpg". Is there a way of inserting the image or hyperlink that updates every time the form changes page?"
Do you have any suggestions for Andrew? Interested in solutions to the same issue? Visit the About Databases forum and join the discussion!
"I have been trying to achive something for some time now and was wondering if anyone could help out. I have a database with contains information about products. One the fields is called "product id" which changes with every entry or page of the form.
I would like to display on the form either picture or a hyperlink to the picture of the product. I have all the pictures of the products saved in the same folder as the database. They are named as "product id.jpg". Is there a way of inserting the image or hyperlink that updates every time the form changes page?"
Do you have any suggestions for Andrew? Interested in solutions to the same issue? Visit the About Databases forum and join the discussion!
I tried several permutations of this and simply had to watch the database size (I have ALOT of photos to deal with). Recommend : http://office.microsoft.com/en-us/access-help/store-images-in-a-database-HP005280225.aspx for the options from Microsoft
The employee form in Northwind has pictures that change with each employee. You can copy this form and code to your database and change the field names to be appropriate names in your database. I have done this and also set it up where the picture doesn’t show unless a command button is pushed.