Display image

[mikekal]

I have a table with users and each user have an avatar.How can make a login form and when choose from combo box one user i can view his avatar

 

[theDBguy]

Are you using an Attachment field for the images?

 

[mikekal]

Are you using an Attachment field for the images?

I have a filepath in table

 

[mikekal]

I have a filepath in table

filepath field
but i can make an attachment

 

[mikekal]

i want when i m choose the one user i can view his avatar

 

[theDBguy]

filepath field
but i can make an attachment

No, don't make an attachment. File path is better. Just use an image control and bind it to the file path by selecting the path field in the control source.

 

[mikekal]

No, don't make an attachment. File path is better. Just use an image control and bind it to the file path by selecting the path field in the control source

 

[mikekal]

I would like to make a login form with combo box to select a user and a text box to put the password.I would like when select the user to view his avatar in login form.The avatar field is in the employees table.Thank you

 

[Eugene-LS]

I have a filepath in table

 

[arnelgp]

using attachment field.
simple Login form.

 

[KitaYama]

using attachment field.
simple Login form.

Isn't this better?

 

[arnelgp]

Isn't this better?

for me, it is.
much better also if invalid users (on combobox) to go back to record 7 for the Unknown image.

 

[arnelgp]

here, it reverts back to "unknown" image when
the content of the combo is not on the list.

 

[mikekal]

Thank you all.You are very helpfull.That i was looking for.Thank you

 

[KitaYama]

Our users don't even enter password. They click their avatars (or select it from a combo) and then scan their pass card.

here, it reverts back to "unknown" image when
the content of the combo is not on the list.

Well, I can't understand why it's not limit to list....

 

[mikekal]

Our users don't even enter password. They click their avatars (or select it from a combo) and then scan their pass card.

Well, I can't understand why it's not limit to list....

 

[mikekal]

I was looking if i choose a user to go in records to current user.How can do that begings with login form.Like northwind database