asked on Access - Control button to Launch a Scanner app
Hello all.
Don't have any idea if this can be done or not.
I have a scanner that I would like to employ in my db app to scan docs. I don't want the doc itself to be added to the db, just a String of the location of the scanned doc. I envision creating a table to store the file name as a String into that table.
My question is on a Control Button how do you Launch the particular Scanner's scan function.
The particular Scanner being used is a Canon All in One which has it's own "Toolbox" which auto launches when you select the actual scan function on the All in One.
I've scanned around trying to find other threads and read about OCX and DLL files that I'll have to use but not sure how to go about.
Don't have any idea if this can be done or not.
I have a scanner that I would like to employ in my db app to scan docs. I don't want the doc itself to be added to the db, just a String of the location of the scanned doc. I envision creating a table to store the file name as a String into that table.
My question is on a Control Button how do you Launch the particular Scanner's scan function.
The particular Scanner being used is a Canon All in One which has it's own "Toolbox" which auto launches when you select the actual scan function on the All in One.
I've scanned around trying to find other threads and read about OCX and DLL files that I'll have to use but not sure how to go about.
Microsoft Access
Last Comment
wlwebb
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Jim
I attempted the code but I'm hitting a Compile error "user-defined type not defined.
Bombs on the Dim wiaImg as New WIA.ImageFile
Is there a "Reference" I have to enable? I looked for Windows Image Acquisition and Microsoft Windows Image Acquisition but don't see anything I would need to enable.
??????
I attempted the code but I'm hitting a Compile error "user-defined type not defined.
Bombs on the Dim wiaImg as New WIA.ImageFile
Is there a "Reference" I have to enable? I looked for Windows Image Acquisition and Microsoft Windows Image Acquisition but don't see anything I would need to enable.
??????
<<Is there a "Reference" I have to enable? I looked for Windows Image Acquisition and Microsoft Windows Image Acquisition but don't see anything I would need to enable.
>>
Yes, you have to add the reference in VBA for the lib.
The reference is "Microsoft Windows Image Acquistion Library ver n.n"
Jim.
>>
Yes, you have to add the reference in VBA for the lib.
The reference is "Microsoft Windows Image Acquistion Library ver n.n"
Jim.
ASKER
Thanks Jim,
Giving it a try
Giving it a try
I will contact Canon as well has play around with the code you posted to see if it can do with I'm wanting..
Thanks....
I will post back but it may be later tomorrow.