Show user photo on Combobox in Microsoft Access

[Alhakeem1977]

Hi All,

I have got a database to send a documents between the departments within our organization.

I would like to show the user's photo when the sender trying to select one of the users in other department from a Combobox on mouse over the user names the users photo will be shown at this moment within the drop down list.

How can I achieve this goal?

Thanks a lot in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk

 

[isladogs]

AFAIK you can't place images in a combo (or listbox)
However you can easily place an image control next to the combo so that is updated when a selection is made.
For example, something like the attached (though in this case I'm updating from a listbox)

 

[MChrup]

Hello there,

I've been looking for similar thing recently.
Access is quite limited with embedded photos, especially if it is not a bitmap.
What I would suggest is to store user photos on hard drive (shared folder with access for multiple users). Then on the side of the combo box create image control. And then within mouse over event load user photo into this control.
Possibly I'll try to code it tomorrow and see if it is even possible so I could tell you more tomorrow evening if you wouldn't figure it out until then.

Sent from my LYA-L29 using Tapatalk

 

[moke123]

You cannot display a photo within a combobox.
You can set an image control in the after update event of a combo but the image must be in another control.
You would not be able to get the value of a combo box unless there is a selected item so I doubt a mouse over effect would work.

 

[Alhakeem1977]

Thanks for your earliest response.

I am waiting your code if you will get enough time to do it.

Thank you so much in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk

 

[Alhakeem1977]

Thanks a lot for your earliest response as usual.

I will try your suggestion and I will let you know.

Thanks again!

Sent from my HUAWEI NXT-L29 using Tapatalk

 

[Gasman]

Why not try yourself.?

Store the path for each user's picture in their record and bring that field into the combo as hidden.
Then when a user is selected, use that value to set the source for the picture control.

However having worked in a few large companies, if you are hoping the picture will confirm the correct John Williams, I doubt most users would even know what that person actually looks like.

Thanks for your earliest response.

I am waiting your code if you will get enough time to do it.

Thank you so much in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk

 

[Alhakeem1977]

I thought the vba can do this trick.

Thanks a lot!

Sent from my HUAWEI NXT-L29 using Tapatalk