473,806 Members | 2,795 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to control scanner from Access?

Can anyone point me to VB/VBA code that will control a TWAIN-compliant
scanner?

Jan 8 '06 #1
8 35208
> Can anyone point me to VB/VBA code that will control a TWAIN-compliant
scanner?


I found this:

http://www.microsoft.com/downloads/d...ng=en#filelist

and got this to work:

Public Function scan()
'Required reference: Microsoft Windows Image Acquisition Library v2.0
Dim objDlg As Object
Dim objMgr As Object
Dim i As Integer

Set objDlg = CreateObject("W IA.CommonDialog ")
Set objMgr = CreateObject("W IA.DeviceManage r")

For i = 1 To objMgr.DeviceIn fos.Count
Debug.Print objMgr.DeviceIn fos(i).Properti es("Name").Valu e & vbCrLf &
_
"[ " & objMgr.DeviceIn fos(i).DeviceID & " ]"
Next

End Function

developing...

Jan 8 '06 #2
Then WIAAutSDK readme file says:

"The Windows Image Acquisition Library v2.0 is only designed to support the
PNG, BMP, JPG, GIF and TIFF image formats. It should not be relied upon to
support other formats, though they may appear to be supported depending on
system configuration."

Is it possible to get PDFs? Why can't I get PDF from WIA?

After WAI produces a TIFF, can it be programmaticall y converted to PDF?
How?

Jan 8 '06 #3
"deko" <de**@nospam.co m> wrote in
news:5v******** ************@co mcast.com:
After WAI produces a TIFF, can it be programmaticall y converted to
PDF? How?


A PDF created from a TIFF is going to be nothing more than a thin
wrapper around a copy of the TIFF.

Do you want to OCR the contents and then create a PDF, with
searchable text? That's more complex and my bet is that there's
nothing COM automatable available.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jan 8 '06 #4
If you are using Office 2003 then the included MODI App has built in OCR
and can load Tif files. One of the interfaces is an ActiveX control that
does work on an Access form. I've only tested the OCR capabilites on a few
(fax) TIF files but I was amazed at the accuracy.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"David W. Fenton" <XX*******@dfen ton.com.invalid > wrote in message
news:Xn******** *************** ***********@127 .0.0.1...
"deko" <de**@nospam.co m> wrote in
news:5v******** ************@co mcast.com:
After WAI produces a TIFF, can it be programmaticall y converted to
PDF? How?


A PDF created from a TIFF is going to be nothing more than a thin
wrapper around a copy of the TIFF.

Do you want to OCR the contents and then create a PDF, with
searchable text? That's more complex and my bet is that there's
nothing COM automatable available.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Jan 8 '06 #5
> If you are using Office 2003 then the included MODI App has built in OCR
and can load Tif files. One of the interfaces is an ActiveX control that
does work on an Access form. I've only tested the OCR capabilites on a few
(fax) TIF files but I was amazed at the accuracy.


I discovered MODI only because it was the default app for opening a TIFF
file. Pretty cool, and the OCR is accurate as you say. The question 'to
PDF or not to PDF' now becomes political/cultural one. If everyone can open
a TIFF as easily as a PDF (and you don't need all the embedded bells and
whistles) why bother with PDF? The only reason, as far as I can see (and as
Adobe CEO Bruce Chizen would want everyone to believe), is that PDF is the
only truly portable document format - that is, in the minds of users: "if
it's not Word or PDF, you can't open it". That misguided idea is the
catalyst behind the request that led me down this road in the first place.

I'll have to look into MODI a bit further...

Jan 9 '06 #6
Br
deko wrote:
If you are using Office 2003 then the included MODI App has built
in OCR and can load Tif files. One of the interfaces is an ActiveX
control that does work on an Access form. I've only tested the OCR
capabilites on a few (fax) TIF files but I was amazed at the
accuracy.
I discovered MODI only because it was the default app for opening a
TIFF file. Pretty cool, and the OCR is accurate as you say. The
question 'to PDF or not to PDF' now becomes political/cultural one. If
everyone can open a TIFF as easily as a PDF (and you don't need
all the embedded bells and whistles) why bother with PDF? The only
reason, as far as I can see (and as Adobe CEO Bruce Chizen would want
everyone to believe), is that PDF is the only truly portable document
format - that is, in the minds of users: "if it's not Word or PDF,
you can't open it". That misguided idea is the catalyst behind the
request that led me down this road in the first place.


It's probably be much easier to "steal" the text from a Tiff than a
protected PDF....
I'll have to look into MODI a bit further...

--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Jan 9 '06 #7
> If you are using Office 2003 then the included MODI App has built in OCR
and can load Tif files. One of the interfaces is an ActiveX control that
does work on an Access form. I've only tested the OCR capabilites on a few
(fax) TIF files but I was amazed at the accuracy.


One way to describe MODI is a TIFF viewer on steroids. While TIFF is a
viable alternative to PDF, if you want to read the TIFF 6.0 Specification
you'll need Adobe's Acrobat Viewer. This is because Adobe owns the
copyright and is effectively the custodian for standard. Still, TIFF is a
scanner-friendly format and a good choice for document imaging.

As for scanner automation from Access, the question (as evidenced by this
thread) leads to a consideration of document imaging: once you acquire an
image, what do you do with it?

This is where Microsoft shows it's strength. Thanks to Ballmer's
"Developers , Developers, Developers" idea, we have things like WIA and MODI.
Both have well documented object models and are easily integrated into
Access. Granted, it's all Microsoft-centric stuff, but I want a solution
not (necessarily) an open source standard.

One thing I found interesting is that ScanSoft (a speech and imaging
technology company now known as Nuance, based in Burlington, MA) developed
the OCR component in MODI. Can anything good come from Massachusetts?

Some helpful sites:

http://www.ilixis.com/developer/modi.html

http://home.earthlink.net/~ritter/tiff/#whatis

Jan 9 '06 #8
> If you are using Office 2003 then the included MODI App has built in OCR
and can load Tif files. One of the interfaces is an ActiveX control that
does work on an Access form. I've only tested the OCR capabilites on a few
(fax) TIF files but I was amazed at the accuracy.


Another useful critter in the MODI tool set is MSPSCAN.EXE - the Microsoft
Office Document Scanning utility. It looks like a front end to WIA. For
the type of document scanning we do, it's all that's needed. I'll be glad
to get rid of PaperPort (a major PITA).

But the MODI VBA Language Reference says: "MODI automation provides powerful
document management and OCR features; however, it does not automate the
document scanning process itself or support image annotation."

So, for what I'm trying to do, I'll need to automate WIA rather than MODI.
This means writing my own MSPSCAN. The one thing I'm not sure how to
replicate is the link to the scanner driver that allows stuff like scanning
multiple page documents with an automatic document feeder. In MSPSCAN, when
the multiple page document option is selected, the scanner's driver/utility
is called and that interface (not MSPSCAN) is used to configure the ADF.

My guess is there's a DLL (viceo.dll?) that was installed with the scanner
driver that I'll need to figure out how to use.

Jan 9 '06 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1584
by: Harmony407 | last post by:
Hello: I am currently creating a database in which a user can scan an image into MS Access. The images once scanned, will be held in a seperate table. Here is my problem. The scanner is not showing up in the Insert Object box when I right-click insert object. The options which appear are very generic. The scanner is a Kodak i260 and it is the only scanner installed on the computer (which is running Windows XP). MS Access
9
4554
by: Dan =o\) | last post by:
Hey guys, I wonder if you could please provide me with some ideas as to how to get around this problem. Symbol MC9000-k, Pocket PC 2003... With a scanner application I've written, data is loaded into ArrayList structures when the user performs some action. This list contains a list of barcode numbers that are currently accepted. Finally, there is a manual entry button in my application where the user can
0
1195
by: terryrey | last post by:
Hi, I've got a winform control that is using Twain and which works fine in a windows application. I am now trying to get this hosted and running in IE6 for our intranet app but am running into problems. Basically, the control works in so far as it can communicate with the scanner and detects when it is switched on/off and connected/disconnected and I can interrogate and set the capabilities of the scanner as well.
11
11191
by: Ron L | last post by:
I have a barcode scanner which uses a "keyboard wedge" program so that the data it scans comes through as if it was typed on a keyboard. I am trying to have the data in the barcode be displayed in a text box. I know that there are certain control characters embedded in the data that I want to display substitutions for in the text box, for instance I want to replace ASCII character 04 with the string "<EOT>". I have tried doing a simple...
2
1740
by: Anders | last post by:
Hi Im trying to develop a C# application which interacts with a Fingerprint scanner. The appliaction is going to run in the background (and as trayicon). When my applicatons catches an event from the finger scanner i want to paste a text into "what ever active textbox control is focused" and the execute a "press enter command". Eg. a focused textbox control in Internet Explorer.
3
1759
by: Budhi Saputra Prasetya | last post by:
Hi All, I'm currently trying to embed .NET Custom Control into my ASP .NET. The control call FindWindow and BringWindowToTop function of Win32 API that is wrapped under another DLL file. I read documentation and it says that I need to sign my control using SignCode and I did. I signed both DLL (Control and Wrapper), but I still have the error message for Security Exception. This is the message:
7
25959
by: DemonWasp | last post by:
I've been having some trouble getting the Scanner class to operate the way I'd like. I'm doing some fairly basic file IO and I can't seem to get the class to load the last line/token any way I try. First, I tried using the following: File InFile=new File("input.txt"); Scanner In=new Scanner(InFile);
0
1980
by: ChopStickr | last post by:
I have a custom control that is embedded (using the object tag) in an html document. The control takes a path to a local client ini file. Reads the file. Executes the program specified in the ini on the client's PC. After the program has ended the control looks in a client side temp folder (specified by the ini file) for an image created by the executed program. If the image is there, then the control moves the file to a public folder...
3
2955
by: thename1000 | last post by:
Hi, I'm trying to create this output: Input team 1's name: Team 1 Input team 1's ranking: 90.4 etc.
0
9719
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9599
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10624
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10374
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9193
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7650
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5546
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5684
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3010
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.