adding my emoji (1 Viewer)

ECEK

Registered User.
Local time
Today, 15:25
Joined
Dec 19, 2012
Messages
717
Is it possible to have an image for each person in my database and for that to be shown on a form. ie. so when that person opens the database their image is shown.

If you could point me in the right direction that would be great.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:25
Joined
May 7, 2009
Messages
19,175
you can either use short text field or attachment field.

if attachment, you can just drop the attachment field to the form and it will show the image.

for short text, it must contain the path of the image.
you need to to add this field to the form and add an image control.
on the current event of the form, set the picture property of the image to the short text field (name).
 

ECEK

Registered User.
Local time
Today, 15:25
Joined
Dec 19, 2012
Messages
717
Thanks Arne. I researched myself and found the answer to use the attachment approach. Works a treat. Thanks
 

theDBguy

I’m here to help
Staff member
Local time
Today, 08:25
Joined
Oct 29, 2018
Messages
21,359
Thanks Arne. I researched myself and found the answer to use the attachment approach. Works a treat. Thanks
Hi. For emojis, it probably won't be a huge problem, but be aware that using Attachment fields for storing large files/images could easily balloon the size of your database file towards the file size limit of Access, which could affect your database's performance.
 

Users who are viewing this thread

Top Bottom