How do I scan from my scanner to directly into database

Dears.

I have to make a form which will have the new employees infromation and right next to it it will have the space for copying the ID card of the new employee.
I want the operator to be able to just click on the SCAN NOW button right next to the picture space and scan the ID directly into it.
How would I do that? any ideas. I am using Access 2003

Thank you
LVL 9
syedasimmeesaqAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
As stated earlier, both the Pajant and the Chestysoft controls can do this.
Pajant is the cheapest but Chestysoft's csXImage is more powerful:

http://www.chestysoft.com/ximage/default.asp

/gustav
0
 
ArjiCommented:
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.
0
 
puppydogbuddyCommented:
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/
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

http://www.chestysoft.com/

/gustav
0
 
ArjiCommented:
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.
0
 
syedasimmeesaqAuthor Commented:
Thanks for reply guys. No I have to scan the ID , front and back for records.
0
 
syedasimmeesaqAuthor Commented:
I need more help on this.
0
 
syedasimmeesaqAuthor Commented:
Guys I actually want to do what had been done here:
http://www.experts-exchange.com/Databases/MS_Access/Q_10303255.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
0
 
syedasimmeesaqAuthor Commented:
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
0
 
syedasimmeesaqAuthor Commented:
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.
0
 
syedasimmeesaqAuthor Commented:
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

http://www.experts-exchange.com/Databases/MS_Access/Q_21419726.html

Thank You for the help
Asim
0
 
Gustav BrockCIOCommented:
Did you download the Access Demo on that page? That helped me as a start.

/gustav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.