Solved

Capture Webcam Image in MS Access form field

Posted on 2011-02-19
8
4,804 Views
Last Modified: 2012-05-11
Hi,

I have almost completed a database to log visitors and times.  
I have a form with visit details of the visitor and who they are visiting.

However, I still need to find a way to do the following:

I want to be able to click a button on the form and capture the webcam.
I then want this captured image to be stored in the frame on the form and then update the table Visitors.

I have never used a webcam within Access so haven't a clue where to start.

Cheers people!
0
Comment
Question by:Howco
8 Comments
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 34934444
I'm not sure, but I THINK you would need to use the DirectShow API - you can start looking here:
http://msdn.microsoft.com/en-us/library/ms783323(v=vs.85).aspx
0
 
LVL 12

Expert Comment

by:ErezMor
ID: 34934496
there are several ways to go around this, i ended up using WIA (windows image acquiring...?)
using this, and a logitech web-cam i could take a picture from an access form and then do whatever with it.
it mentioned the web cam since this wia doesnt (or didnt at the time, around 2006-7) support all web cams and some i tested just didnt do the trick (while still functioning otherwise)

if i can remember right, it's all  in wiaaut.dll which is supposed to be in system32 forlder
0
 
LVL 6

Expert Comment

by:Gugro
ID: 34934503
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 34934591
Besides capturing images, DBPix does a LOT more.

http://www.ammara.com/

I can totally vouch for this program.  

It does *all* the work for you. Examples show how to add a simple 'control' panel to Load, Save, Zoom In/Out, Size To Fit and much more.  AND ... virtually eliminates BLOAT associated with storing images in an Access MDB. I have 3 clients who sell commercial run-time products that use DBPix.

Note. I have no connection with DBPix ... except I have used it many times ... as have several of my clients.  Fantastic product.

mx
0
 
LVL 75
ID: 34934595
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34955791
One thing to note is the resolution of the web cam.

A lot of web cams do not have a high enough resolution to be used as a "camera" that and produce really clear images...
0
 

Author Comment

by:Howco
ID: 34958853
It is only to capture visitor pictures for a gatepass database.

I have done the vast majority of it now.  I just need to sort out the image capture side of it.

I am about to test the options given.  I will report back later today.

Thanks for all of your input.
0
 

Author Closing Comment

by:Howco
ID: 34960079
This seems like the better solution after trying them all.

Many thanks guys.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question