How to use Access VBA to scan document to PDF

Forum|Forum|6 years ago
June 5, 2019
3 replies
5661 views

I have an Access 2010 Form that I have a combo box that has Document Types in it, that I would like to automate where the user chooses the Type from the combo box, and clicks a button and it automatically scans the document on our Canon Printer and Saves it to a predefined Location and Name based on the Document Type. I would also like to give the user the choice on the Form for the Scan Type: Color Scan, B&W Scan, Grayscale, etc.

What I am trying to eliminate the user from doing is manually placing the document on the Printer, opening up Adobe 2017, choose the Menu option Create>From Scanner, and then choose Color, B&W, Grayscale, and then after it finishes scanning, save the document. I would still need to have the Adobe dialog box pop up that lets the user choose whether or not to scan additional pages that way they can manually place each page on the Printer rather than use the Automatic Document Feeder.

Any VBA code would be very helpful.

Thank you

Scan documents and OCR

This topic has been closed for replies.

H

HouseOfDogsAuthor

Participant

Revisiting this issue as I'd still like to know how to accomplish this? Is there any VBA code samples that allow my form to launch the "PDF from Scanner" option that you would use if you were to use Adobe Acrobat Pro 2020, using any of the Adobe API's?

Bernd Alheit

Community Expert

There is no API in Adobe Acrobat for this.

T

Test Screen Name

Legend

So far as I know, Acrobat offers no API to automate scanning. There may be separate third party apps or components which control the scanner (without using Acrobat), and are designed for automation.

H

HouseOfDogsAuthor

Participant

I have looked into the WIA feature, but that does not scan directly to a PDF; instead it does JPEG or GIF, etc... and I don't want to first scan to that type only to convert it to a PDF, for fear of losing any quality in the conversion as well as the filesize is quite large when converting a JPG image into a PDF document. It is hard to believe Acrobat doesn't have something in their SDK that you can control that function (the Scanner) of the Acrobat product.

H

HouseOfDogsAuthor

Participant

Has anyone else been able to control the Scanner piece of the Adobe Acrobat product using their APIs outlined in their SDK? This is the last piece that I would need to be able to complete my scanner functionality of my Access database? The WIA feature just will not work as it would require converting a JPG or BMP image into a PDF which results in quality loss and huge PDF file sizes

H

HouseOfDogsAuthor

Participant

I am revisiting this issue, as I don't have a full solution yet

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded