Image Capture in an Access Form
Posted on 2005-04-20
I am trying to consolidate all the little applications my company has acquired over the years that deal with employee information. I have managed to tie time tracking, training, building access, and personnel records to a central database but there is still one separate application that is causing me trouble.
We have an off-the-shelf program that takes the employees photo and generates an ID badge. The badge is coded for building access. The problem with this program is that the database is not linkable in any way helpful to me.
I have all the needed data in the central database, including a field named “photo” that contains the name of the jpg bitmap for each person. I have found a few badge making applications that let me print the badge using my database as a reference. One problem remains:
I have no clean way to photograph the employee and save the bit map where it belongs. I am looking for something that would keep this whole process flowing easily for our HR department so they don’t have to become computer experts to add a picture. What I envision is something like an Access form that shows the live USB video feed on the left and a resulting still on the right that occurs when they click a button. If the picture is acceptable they click another button and the bitmap is saved in the right location with the right file name. This form could just become part of the employee information entry procedure. A separate program that does that job would work as well. I could call it from a form.
Sorry for the long winded explanation. I figured the best way to get results is to make the whys and where clear to everyone. I am open to any and all suggestion that accomplish the above.
Points go to the person who points me in a direction that leads to solving my problem. If anyone has the actual solution they can offer, the points will be doubled.