Show picture when hovering over product name in order form

[megatronixs]

Hi all,

I'm creating a database for a flower shop for training purpose. I have a main form with a sub form that has the orders in it. when placing a new order for a client and selecting the product from the combo box, it would be great if the product could show up to the right in the form. I have no clue if this is possible and how to get it working. I have included the database as an attachment so one could have a look at it and let me know which way to follow. I remember that I could do this on a web page, but a web page is not the same as a database.

Hope there could be some path to follow.

Greetings.

 

[megatronixs]

Hi all,

I got some clue what to use. In the past I was using a web control in excel user form to show a picture from folder in the web control. It uses the following code:

WebBrowser1.Navigate "C:\TestPhotos\Image1.bmp"

That works in excel, but not in access.
Is there something I could change to make it work?

Greetings.

 

[megatronixs]

Hi all,

No one can help out?

Greetings.

 

[Normm]

If you have your products in a separate table, why not create an extra field with the data type of 'Attachment' then you will be able to attach photos of each product to the product.

You can then display the picture the same way all the other data is displayed when you select that item. This may not help with a combo box though. I've never tried it that way.

 

[megatronixs]

Hi Normm,

I made something similar for the new product entry form. In it I put an OLE object, when I go to the next product, it will show the image. I will try it out as soon as I have some time to see if I can connect it with the combo box.

Greetings.

 

[megatronixs]

Hi Nrmm,
As I'm ussing for this project Access 2003, I don't have the option for the data type "attachment". Just bad luck. I guess I'm stuck to the OLE object and need to re-think it about the really need for the above idea I had.

Thanks and greetings.