How to control a webcam in Access

[Victor Torres]

First of all, I know that using links instead of embedded is better. I know
how to link a picture to a frame. What I don't know and I can't find out, is
how to control a webcam from MS Access 2003 and also how to save that pic to
a folder where I can use my actual codes to retrieve the picture. If anyone
can help me in this one I will be very happy. Also if anyone know where I
can find an example will be better. Thanks a lot!!!

 

[Michel Walsh]

Forgot to say the officially, WIA automation is only officially supported on
XP SP1 or later.

Vanderghast, Access MVP

 

[Victor Torres]

Hi Michel,

Base on what you wrote, it seem that you know a lot of access. Have you
ever try to implement this? If so can you give me an example of a code that
will activate the webcam and after that the bottom that will take the pic and
save it?? I know is too much and that is not your work but if you can help
me with this one... I know a lot about access but I have never work with any
of the activex or stuff like that. Thanks!!!

 

[Michel Walsh]

I don't see my first message... I was supplying MSDN reference to the
download you need to have WIA automation (which contains VB6 code example),
AND an MSDN reference to additional code examples. No, I never tried it (I
am not a fan of Webcams, only have one on Vista, and you are the first one I
am aware who want to do it, in VB/VBA).


for WIA library (dll) and help file and VB6 examples:
http://www.microsoft.com/downloads/...7a-01b8-4de6-91c2-b7ea32537e29&DisplayLang=en



for 'shared' VB6 code, from MSDN, about WIA
http://msdn.microsoft.com/en-us/library/ms630826(VS.85).aspx


(note that you need to have registered (regsrv32) the WIAAuto.dll AND to
check it, as reference, in your application: Tools|References.... You may
want to read:
http://msdn.microsoft.com/en-us/library/ms630818(VS.85).aspx


Sorry if that duplicate an existing message... I just fail to see the
initial one... so I suspect that somehow, the first message fails to reach
the newsgroup.


Vanderghast, Access MVP