Webcam image store

[j.hagon]

I am having a major brain block with this, hope someone can help.

I need a solution to the following:

I would like to be able to click on a Command Button on a form which will open a WebCam capture box. From this box I can view a live feed from the WebCam and has one button on it - Take Photo (or similar).

By clicking this button the current image from the WebCam is taken and updated in the MS Access form and stores the taken image under "../images/[record_id].jpg" with the associated link being stored in the appropriate field in the table the form is designed from.

Think of an ID system, with simple operator use:
Enter name, address etc., and then click a few buttons and their photo is saved.

I hope someone can help me PLEASE.. this is really the only stumbling block I have left.

Regards,
Jeremy Hagon

 

[dynamictiger]

Try

www.pajant.co.uk

 

[j.hagon]

thanks.....

Thanks for the links to the software, unfortunately Photoshop does a similar job. I'm looking for a simple pop up window with one button on it and a live preview screen in it, not too big, but when the user click the "Take Photo" button, the image previewed in the window above will then be transfered to the Access form and the link saved in the correct field under the file name [../images/(recordnumber).(jpg.bmp.gif) etc..

Do you have any more ideas?

Kind regards
Jeremy Hagon

 

[dynamictiger]

Take another look at Pajant, I believe it has this capability, although I do not use it this way. It certainly will pop up a form with a button on it, although you have to make the form and file the image into the path where you want it. It comes down to twain compatible drivers or not.

 

[j.hagon]

I had a second look - but could not work it out.

I have found JFL Peripheral Solutions ObjectTWAIN 3.1 which includes examples and source code for VB as well as a nice and easy HTML front end which includes VBScript.

I would love to know how to incorporate the example VB code into MS Access so that a command button will launch the code and do what I need it to.

If you have the time, could you help me out please.

Object Twain is found at http://www.jflinc.com

Many thanks
Jeremy Hagon

 

[dynamictiger]

Attached is an example form based on the Pajant tool, which is significantly cheaper than the one you are loking at. You will need to set a reference to pajant in your VBA. The code is all enscapulated in the form.

This form is designed to acquire images from a scanner, however, you could email Pajant with any enquiries on using it as you wish, they are very very helpful.

 

[j.hagon]

Thanks for the help, info and sample file.

I have now managed to acquire the image from Twain, save the acquired image as "../images/[file_id].bmp". This took a bit of playing around with!

Now.. the only proble that I have is.. yep.. you may have guessed it.. is how to view the image in a VB form.

I have viewed the example Northwind database in Access and they use the method that I need to convert, but I have had luck as yet.

Any help would most be appreciated.

Regards
Jeremy Hagon

 

[dynamictiger]

Create an image by clicking on the image tool in design view of the form. This will open an annoying wizard, that ties the image to an image somewhere on your drive. That's fine, work through that.

Set the image to be the size you want, and set the properties to stretch or what have you.

In the properties delete the contents of the picture this is the path to the first image.

Add a field that ties to your table containing the path to your image.

In code in the current event for the form write the following:

Me.Image1(or whatever your image is called).Picture=
Me.txtPicturePath(or whatever your picture path is called)

 

[j.hagon]

Thanks for the information.
This works fine in MS Access, but i'm trying to view a linked image in VB.

I have the form, the database etc..

The field that the image path is called "IMAGEPATH".

I have added an image box on the form and called it "IMAGEFRAME".

I have a text box on the form bound to the field "IMAGEPATH", which when the code is run, shows the correct field data, ie: \\server\database\images\1234456789.jpg

I have added the following line to the code straight after a message box pop up (which shows ok):
"Me.ImageFrame.Picture = Me.ImagePath"

This does nothing!

Please can someone tell me where I am going wrong as I'm sure it's something REALLY simple, but it's getting damned annoying!

Many thanks
Jeremy Hagon

 

[vd_patel]

i also facing the same problem

I would like to be able to click on a Command Button on a form which will open a WebCam capture box. From this box I can view a live feed from the WebCam and has one button on it - Take Photo (or similar).

By clicking this button the current image from the WebCam is taken and updated in the MS Access form and stores the taken image under "../images/[record_id].jpg" with the associated link being stored in the appropriate field in the table the form is designed from.

Think of an ID system, with simple operator use:
Enter name, address etc., and then click a few buttons and their photo is saved.