Take a picture from a form with usb camera **need help

[lwilson2k1]

i am trying to perform a surplus of misc. hardware and need to document it.

I want to take a picture of it barcode that identifies the item through the form i would be working. (i need help getting this started)



I also am going to scan the barcode of the hardware item to a text box in the form.

from that i am hoping that i can maybe scan barcode, take the picture, and have the barcode number replace what the picture filename is in the picture folder where it would be stored.

Please help!!!!

Let me know if any confusion. I am not an expert in access nor with coding.

thanks

LGW

[ItsMe]

Barcodes can be scanned into a database. What you want to store in the database is the translation of the barcode, usually a number or alphanumeric number. Barcode scanners can translate the barcode for your and store it in the database, provided you have a form designed correctly to do so.

In order to store photographs on a computer or in Access database tables as an attachment, you will need to manage and manipulate the camera's TWAIN. This requires advanced programming skills.

[lwilson2k1]

I am going to break this up.

Barcode scanner to text box

Pic with camera

form has picture box showing live feed of camera
click button to snap picture
picture is taken and store into a folder
- barcode to become the filename of picture take

Table
Column with item barcode
and
Column with file name (which i want to be the barcode)

Need some help with coding also.

[ItsMe]

There may be a control available to look at a "live feed". I am not aware of one. Maybe look into activex or OLE. Not sure why you are creating a barcode to be stored in your DB.

Data bases store data. If you want to print barcodes, you will need the barcode fonts installed on your computer. Have not looked into this lately. Access may have some intrinsic fonts available. Adobe offers them also.

[orange]

see this for some links that may help
http://www.access-programmers.co.uk/...d.php?t=200100

Good luck.
Let us know how you make out.