[Webinar] Learn how to a build a cloud-first strategyRegister Now


Control Canon DR-3060 with VBA via ISIS or TWAIN Driver

Posted on 2005-04-28
Medium Priority
Last Modified: 2013-12-27
Hey guys, my company would like to set up a document scanner and have each scanned document be linked/related to an entry in a database.  To do this, I would like to use MS Access VBA.

I was thinking of having a form in the database with a text box and a button.  The user would enter the number related to the database entry then click the button.  The program would then automatically initialize the scanner, scan in all documents, and then save the documents using a file name based on the number entered by the user.

Can this be done?  Don't worry about the text-box and the simple VBA, I'm trying to figure out how to control the Canon DR-3060 using either the TWAIN or the ISIS driver.

Thanks in advance for your help.

Question by:scbauer
  • 2
LVL 38

Accepted Solution

lherrou earned 1000 total points
ID: 13894283
Short answer: yes.

Long answer: I'm not a VB programmer, so your question may be more appropriate in one of the visual basic TAs, but I know it can be done, and that Windows Imaging Architecture (WIA) provides for this. Here's a couple of things I found on the web that may get you on track:

http://www.microsoft.com/whdc/device/stillimage/WIA-arch.mspx - about the WIA.
http://www.dosadi.com/vbtwaincode.htm has a nice example of VB code for multi-page scanning with ADF (and they sell a nice developer's kit - be sure to look at it).
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/3rdparty/html/isc_method_startscan_example.asp is an example from Microsoft's site.
http://www.geocities.com/smigman.geo/mci/download.html (look for the one called "SCANNER, Digital Camera Code")

I know that's not much, but maybe enough to get you started.

LVL 38

Expert Comment

ID: 13894291
And don't forget to search this site for "visual basic scanning" or "visual basic twain"


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Well I am not sure whether i deserve anything (credit or points) for this article, since I have not written the source code but discovered the same while browsing the net. I only wish to help EE users save some money and probably help the environmen…
If you are having problems installing printer drivers, or if documents repeatedly get stuck in the print queue even after re-installing the printer drivers, then follow these steps to solve the problems. Please note that the steps are shown both for…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month20 days, 14 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question