Pictures From a web cam

[IT-1957]

Hi, I have a database for custom parts, I need to take a picture of each part
and associate the picture with is corresponding record, I have 15 producion
lines and an a front end application controling the flow of each part, there
are a lot of parts (1000's each day) so linking one by one manually is just
no possible (and not every one could doit)
Is there a way to get the picture from the web cam an placed as an ole
object on the record using a command button? Or that by clicling the button
the image get stored on a folder, storing the reference path per each picture
with is corresponding record? I'm using SQL 2005 as the back end.

Your help is really apreciate. (I tried to use VideoCap Pro ACTIVEx cONTROL
but I haven't been able to ge it to work)

 

[Roger Carlson]

Your second option, storing the pictures in a folder, would be the best
choice IMO.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "Picture.mdb" which illustrates how to load the picture stored
in a folder into a form or on a report. There is another sample called
"PicturesLoad.mdb" which shows how to save the path to the picture in your
database for loading. Unfortunately, it does it one at a time, but you
could use that as a basis for loading multiple pictures.

There is additional explanations in the samples. Take them apart and see
where it gets you.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L