Access and taking Pictures

[klynch0803]

Good Morning Everyone,

I have a project I'm trying to complete this am and need some detailed help.

I have a database of Memberships that I have created. On one form you can lookup a Member by scanning there Drivers Liscense and t shows all there information and there picture.

My problem is though I can't figure out how to write the code to actually take a picture and save the file to a specific Directory and filename. I have a Logitech Pro 2000 Webcam attached to the usb port of my computer for taking the pictures.

My idea is take the form in my current database attached named "fdatMember" and create a New one named "fdatNewMember" (Already Exists) and it will have a button called "Retrieve Picture" (Already created)this would open a seperate form "fImageGrabber" (Already Exists but no webcam or grab capabilities) that would display the Webcam live stream attached to the computer. Upon pushing a button "Grab" it would take the picture and show it in the same window just beside the Webcam live image. When you click Button "Attach" it would save the file in folder "C:\Shakers Test\Picture\" using the Member# assigned in the "fdatNewMember" form and add the link to the Picture File field in the form "fdatNewMember" so you can save the complete record.

Sounds very complex but I actually think it is really simple if I only knew how to write the code to grab the image etc.

If someone could please help me I would greatly appreciatte it and upload the file back to the thread. I have researched a lot on this and really dont know much about api etc. Basicallay I need a new form to start the webcam and show the live stream and be able to grab the image and save it to the proper folder above as "Member #" and add the link to the "fdatNewMember" form. By the way I had to remove images from the Members Picture Folder so I could upload this but it was three pictures name 1.jpg, 2.jpg, 3.jpg that existed and are linked to members in the database serach.

I know its possible because there is a application on http://www.idscan.net/products.html called Veriscan Lite (Free Download so you can see what I mean by the from I'm looking for to Grab picture if you like) that does just this and its a Database application Software that has limited use. I needed something more custom and creative so I decided to venture and create my own LOL..



Thanks for your help in advance and hopefully by reading what code you have written I will be able to learn something from this process for future use.

 

[DJkarl]

I don't mean to rain on your parade but just because it can be done in a compiled application doesn't mean it can be done in Access. Depending on the language that program was written in they have the ability to do several things that Access simply cannot do.

That being said I don't think it is impossible...but unless your webcam software came with a DLL you can reference it is going to be difficult to identify and gain control of that USB device.

 

[klynch0803]

Thank You DJKarl I did some research to your comment and furtunately there are .dll files used by the webcam to access acording to Logitech Technical Support (They are looking into which one it is exactly for me though). The standard Plug & Play Drivers in Windows XP can access the camera I'm just not sure which one I need for sure to capture etc.

 

[klynch0803]

I resolved this issue thanks for the help.

 

[tech1458]

Pictures....

I been looking like crazy for the same solution, how did you solve the problem?

 

[klynch0803]

I been looking like crazy for the same solution, how did you solve the problem?

Unfortunately I was not able to build something on my own therefore I found something that was an add-on for MSAccess called dbpix for $99.00 and I purchased that application add-on. I would love to find a way to have my own as I plan on possibly marketing this product and would like to have something I dont have to purchase for each one to make it work corectly. If you do figure this out on your own other than dbpix I would love to see it..

 

[ylooy]

webcam image into access table

Hi,

I'm fighting with the same question.

How can I look at the moving webcam image in an ms access form, click on a button, and capture the picture in of file or straight into the database.

Cab dbpix solve this problem ?

greetings,

Yves

 

[klynch0803]

Hi,

I'm fighting with the same question.

How can I look at the moving webcam image in an ms access form, click on a button, and capture the picture in of file or straight into the database.

Cab dbpix solve this problem ?

greetings,

Yves

Yes dbpix does solve this issue.

The best I have found is I can display a still image from a file already in existence but not from a webcam. It requires vb that is only in a VB5 language that utilizes .dll and I could not get access to control that or anyone else who could as well. If you decipher dpix and get your own module written not using dbpix i would appreciatte you sharing it here...

Hope I helped.

 

[DCrake]

Simple Software Solutions

I have accommplished this in Visual Basic where the task was to take the photograph of the customer (security reasons) at the point of sale. Like you said there are products that can be referenced and used within an access\vb form. But they can act as a middleware and need to be installed independantly form the main application. However we did find an OCX that worked form within vb and did not need installing/purchasing. Can't remember what it was called and was in my previous life as a Software Dev Mgr. Will try and find out its name and get back to you.

CodeMaster: