I have table in access foe empolyee and i want to make aform that enable me to take aphoto throuh connected camera and save photo in afolder with the emp_id as the name of the photo who i can make it
TAKE APHOTO IN ACCESS 2003 and store in specific folder
Collapse
X
-
LAMA1981:
1) You will need the manufacture's information and help to trigger the camera and setup the destination folder for the resulting image. That is not something we can normally do here (also, you failed to mention the make and model of the camera and how it is attached to the computer (^-^) ).
2) ACC2003 is getting very old, and even here, support is becoming limited. You can do a search here on bytes about how to use images within reports and forms as the topic is fairly common; however, if you get stuck or don't find anything that matches what you want to do, then post back.
(added as afterthought)
3) If your camera is attached to the PC, and it can still take a picture, then, it might be possible to:3a) Take the picture as normal (you press the shutter button on the camera (^-^) )4) It is usually better to store links to the picture files within the database verses the actual image due to file size limitations within Access.
3b) If the camera stores the picture to itself or card, then if the camera shows as a drive on the PC, then you can use VBA to open the directory, find the file, and then manipulate the file.
3c) Better, if the camera will store to a specified folder upon capture, then the VBA is much easier.
-z
Comment