image_contacts.png - I am trying to recreate the photo from Northwind to Access

I know that I am missing something which is prob right in front of my eyes.  In Northwind you have a place for a customer photo.  I have duplicated this and it works perfectly and I can now add students photos no problem at all.  But I want a default photo - I see that they used image_contacts.png, I would like one that is just a head but you cannot see if its male or femal,  but I cannot find it in Northwind, nor can I find a path to it.  I know it is there, it has to be, but where and how do I add th photo.  I also dont seem to be totally understanding the three parts of the attachment field and how they work on the form, any help would be appreciated please
AnnetteDavidAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

thenelsonCommented:
My Northwind database (A2003) does not store pictures of customers. What Access Version are you using? My Northwind database uses OLE objects to store low resolution images of food items.  - you probably don't want to use that for photos. Better would be linking. See below.

If image_contacts.png is stored in an OLE object, you will have a tough time getting it out. (One problem Of OLE objects). Your best bet is screen capture like prtscr then crop.

As far as a generic head silhouette (I googled "head silhouette"), how's this?
http://www.nottinghamshire.gov.uk/silhouette.jpg



Here are two sample databases for storing images.  

This one links to images stored outside of the database which is preferred to the second method because Access is not good at storing images within it:
http://www.thenelson.name/#LinkedImageDemo

This one stores the images within Access.  
http://www.thenelson.name/#ImbededImageDemo
It is ok to do this for very small images such as icons but will rapidly bloat the database to unusable size if used for larger images.  Here is a link of someone who is trying to fix a database that has bloated with Word and Excel OLE objects: http://www.experts-exchange.com/Databases/MS_Access/Q_21538911.html.

Here is another reference for storing images within Access as Blobs. Does not create bloat.
http://support.microsoft.com/default.aspx?scid=kb;en-us;103257#appliesto

And here are articles about the comparable merits of the three different image storage methods.
http://www.jamiessoftware.tk/articles/handlingimages.html
http://www.granite.ab.ca/access/imagehandling.htm
0
Jeffrey CoachmanMIS LiasonCommented:

See these links
http://www.artistsvalley.com/iconpacks/user-icons-pack.html
http://www.iconarchive.com/category/people/people-icons-by-aha-soft.html

<I would like one that is just a head but you cannot see if its male or femal...>
"The One"??
Which one?
Where have you seen this icon?

Please remember that whenever you se an image you like you can do a PrintScreen in windows and capuer it.
You can paste it into MS Paint, or any other Graphics program and manipulate it to your liking.
Then simply set it as the default Icon.

For example here is my "EEppl" from this site:

boag2000.PNG
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AnnetteDavidAuthor Commented:
Wonderful, such an easy quick to understand answer and worked brilliantly
0
Jeffrey CoachmanMIS LiasonCommented:
;-)

Sorry for the spelling errors.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.