X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Photo to a form    
post Sep 24 2008, 03:18 AM

Posts: 1
Joined: 20-February 08

I am a beginner, however I was wondering if someone could tell me how to add a photo to a table so it will populate with all the other information from that particular table. For example a employee information sheet. When you select an employee it gives all their contact information and their picture will show up on the form.
Thanks in advance.
Go to the top of the page
post Sep 24 2008, 03:26 AM

UtterAccess VIP
Posts: 1,405
Joined: 7-October 03
From: Heart of England

Take a look at the Northwind database example that ships with Access. It includes exactly this example
Go to the top of the page
post Sep 24 2008, 05:57 AM

UdderAccess Admin + UA Ruler
Posts: 19,556
Joined: 27-April 02
From: Upper MI

Hi ! and Welcome to Utter Access ! -o!
Adding photos or other images to a table is just not a good practice. Instead, store the location of the image file in a field of that table. Then, have the "OnCurrent" procedure of the form refresh the image by calling up the file location when needed. If the file location contains no data, no picture will show.
Your database will also not "bloat" because the pictures are housed outside the db container.
hope this helps
Go to the top of the page
post Sep 24 2008, 06:43 AM

UtterAccess VIP
Posts: 5,812
Joined: 31-August 06
From: North Carolina, USA

How to include a bound picture on form
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    21st March 2018 - 12:04 AM