Take a Photo & Show in Database
Posted on 2014-07-23
I need assistance to automate taking a photograph using a webcam (or a camera attached to my pc) & "attaching" same to my database.
The image is not embedded into the database.
The ffg. (only relevant table fields) are listed:
frmEmployees has imgEmployeePhoto which has tblEmployee.EmployeeImageFilePathAndName as it's Control Source.
The Employee's JPEG photo would be stored at C:\Project1\EmployeePhotos
The naming of Employee's photo would be: "EmployeeID yyyy-mm-dd hh:mm:ss"
The process should be:
Step 1: Take the photo | Name the photo and store to disk
Step 2: Parse the EmployeeID and write the File Path and Name to tblEmployee.EmployeeImageFilePathAndName
Step 3: Refresh/Requery frmEmployees so that the Employee photo shows.
Your assistance in this would be greatly appreciated.