How can I setup document scanning with an access db. I want the option to scan a document or multiple documents as apart of the data entry process using Access forums and controls.
Printable View
How can I setup document scanning with an access db. I want the option to scan a document or multiple documents as apart of the data entry process using Access forums and controls.
Word docs?? (I assume)
I guess that there are three options:
1) See if there is already software out there which does what you want and allows you to use with access
2) Office automation - open word and scan through the doc via code. This would be either to specific points or using Word VBA
3) Forget it... ;)
If you have the time available or it is very neccessary, mess around with recording macros in word and using that code as a base.
Note to code from Access to Word you may need to use a reference to the VBA or experiment with objects (the better but harder way).
Vince
Uh.... How do you get "Word Doc" out of Document Scanning... Do you know what Document scanning is?
You take a physical paper document, and scan it, and it gets stored in a database for quick retrival/reference.
This has nothing to do with word documents what so ever!
Thanks
Ok,
So you have probably a couple of choices:
1) Scan docs, store as pics on a hd, and store the pointer to them in access
2) upgrade to sql server and follow the tutorial Beacon made (top threads)
3) Use software already written to do this... there are several around
4) Obtain info on API calls to scan and then convert the file into Access, but I wouldn't recommend this as each scan is going to be big and the final mdb would be huge and slow...
Document scanning -
scanning paper to electronic
scanning through word doc for certain data / references
I took it to be the second type
Vince
Alright, your fired... Wise guy. :mad:
What I am really looking for is some kina of free or relatively cheap ActiveX control to access the TWIAN Scan Manager so that the images can be easily scanned and imported into the database with a click of a button.
But since you aparently dont really know any such active controls, that answers my question. I will just have to keep searching I guess.
Wouldn't that be called Parsing?Quote:
scanning through word doc for certain data / references
I took it to be the second type
:eek:
http://15seconds.com/component/free.htm
Most sites I had a quick search (I am meant to be working) asked for 1 grand usd or more, mighty expensive!!
The link above has one webtwain, but maybe it will do what you need - or point you other sites...
Good luck in your hunt
Vince
Several years ago I wrote a VB app that used the Kodak imgscan.ocx, imgadmin.ocx and imgedit.ocx files.
If these are available to you try them out.
I don't remember much about how it worked, but here's a chunk of code from the "Scan It" button event:
Hope this helps, DaveBoCode:' Setup properties for the ImgScan1 obj. for ref. only:
ImgScan1.FileType = TIFF
ImgScan1.Image = New_ScanFileName ' writes out pages to TempScan.tif
ImgScan1.MultiPage = True
ImgScan1.PageOption = CreateNewFile
ImgScan1.ScanTo = FileOnly
ImgScan1.ShowSetupBeforeScan = False ' prevent that screen from appearing
ImgScan1.PageType = BlackAndWhite ' (won't allow this? #3 instead)
ImgScan1.CompressionType = CCITTGroup4_2d_Fax ' ~35K/page
' Scanner is automatically opened
If ImgScan1.ScannerAvailable Then
' 1st check if New_Scan.tif exists, if so, delete it
If File_Exists(New_ScanFileName) Then Kill New_ScanFileName
ImgScan1.StartScan
ImgScan1.CloseScanner
' scan is now if file New_ScanFileName