By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

TAKE APHOTO IN ACCESS 2003 and store in specific folder

P: 1
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
Nov 13 '13 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397
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 (^-^) )
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.
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.

Nov 14 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.