Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-20-2019, 12:28 AM   #1
ECEK
Newly Registered User
 
Join Date: Dec 2012
Posts: 711
Thanks: 211
Thanked 6 Times in 6 Posts
ECEK is on a distinguished road
adding my emoji

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.

ECEK is offline   Reply With Quote
Old 09-20-2019, 12:32 AM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,568
Thanks: 68
Thanked 2,744 Times in 2,629 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: adding my emoji

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).
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 09-20-2019, 04:15 AM   #3
ECEK
Newly Registered User
 
Join Date: Dec 2012
Posts: 711
Thanks: 211
Thanked 6 Times in 6 Posts
ECEK is on a distinguished road
Re: adding my emoji

Thanks Arne. I researched myself and found the answer to use the attachment approach. Works a treat. Thanks

ECEK is offline   Reply With Quote
Old 09-20-2019, 04:19 AM   #4
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,543
Thanks: 55
Thanked 1,226 Times in 1,207 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: adding my emoji

Quote:
Originally Posted by ECEK View Post
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.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
adding a new record has strange behavior and filters records instead of adding jd9913 Forms 1 12-23-2015 01:04 PM
Adding a Row Using VBA hrbreton Excel 2 02-06-2011 09:55 AM
Adding a file / adding an attachment to a record Compressor Modules & VBA 20 12-08-2010 05:26 PM
Adding new records in one table & adding to other tables. Rusty Forms 1 04-29-2004 07:45 AM
Adding up numbers listbox - but not adding duplicates WebFaktor Forms 1 12-13-2002 10:41 AM




All times are GMT -8. The time now is 03:04 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World