How do I scan from my scanner to directly into database

If you are using a barcode scanner you don't even need a button.  Barcode scanners use a "wedge" interface which means it's attached between the keyboard and the computer.  All you have to do is place the cursor on the field you want the number in and then scan the barcode.  The number will then appear in the field.

I know nothing about using any other kind of scanner with Access.

If you need the image stored in an Access db, you can buy an activeX control for $40.
                                         http://www.pajant.co.uk/


If you don't need your imaging tied to an Access Db, consider this.  For only $25, you can purchase scanning software that should do what you want and more.  See the following link:
                             http://www.mister-bills.com/

Here's another ActiveX that can do this and a lot more:

http://www.chestysoft.com/

/gustav

Thanks for the links guys.  Now I know how to interface an image scanner with VBA  I'm just guessing syedasimmeesaq would be using a barcode scanner because he just wants to scan an employee ID.  I guess we'll find out soon enough.

Thanks for reply guys. No I have to scan the ID , front and back for records.

I need more help on this.

Guys I actually want to do what had been done here:
https://www.experts-exchange.com/questions/10303255/scanning-pictures.html?query=how+to+scan+directly+into+database+&clearTAFilter=true

But the problem is that I don't have Kodak imaging. If there is an alternate to that, I can use that solution. I am using Access 2003.

Thanks

Cactus_data

I looked at the website but I have no idea how to use it? Can you help with the directions to use it.
Thanks

This is what I have done

Private Sub cmdScan_Click()
 
  Dim objScan As ImgScan
  Set objScan = Me!ImgScan1.Object
  With objScan
    .DestImageControl = "ImgEdit1"  'Tell it which image to control
    .FileType = BMP_Bitmap 'Tell it what file type to use
    .ScanTo = DisplayAndFile 'Scan to the screen and the file
    .Image = "C:\Documents and Settings\Asim\My Documents\My Pictures\acdp3.gif" 'Give a temporary file name
    .StartScan 'Open the twain scanner screen
  End With

End Sub

Private Sub ImgScan1_ScanDone()
'This event process after the scan is completed
 
  Dim objScan As ImgScan
  Set objScan = Me!ImgScan1.Object
  With objScan
    .CloseScanner
  End With
 
  With Me!OLEPicture
    .OLETypeAllowed = acOLEEmbedded 'Allow embedded OLE types
    .Class = "Paint.Picture" 'Insert the type of picture you want
    .SourceDoc = "C:\My Documents\TempImg.bmp" 'Tell the OLE control which picture to use
    .Action = acOLECreateEmbed 'Store the image in the database
  End With

'Delete the temporary file
  Kill "C:\My Documents\TempImg.bmp"
End Sub


I have used the chestysoft active-x. But when I run this code it gives me eroors.

May be this is another question. So I will post it under different post. However I will give you the points for pointing me out to right direction. Thank You. If you think you can help me with the coding and get it working too. Please look at my other post. I have posted it at this address

https://www.experts-exchange.com/questions/21419726/Code-help-for-scanning.html

Thank You for the help
Asim

Did you download the Access Demo on that page? That helped me as a start.

/gustav