Scan to PDF, Access VBA or VB6
Posted on 2010-08-19
Since my users find scanner software to be too complicated, I would like to design a simple application to scan documents to .pdf files. One of the primary reasons I need to do this is so I can control where the document goes based on the user who is using the scanner.
I've experimented a little with some different code but I haven't found any optimal solution. It appears that my scanner only makes .bmp files if I use WIA in VBA. How can I convert the bmp to a pdf? Or do I need to convert the bmp to a jpg or tiff and then to a pdf?
I don't need the text to be searchable but it would be nice if you could highlight and select text in the document (certainly not required). I'm not going to be saving the document into the database. I'm just using Access because it's the coding environment I'm familiar with and my users are also familiar with Access.
Also, I do expect to use a scanner with an ADF so we can scan in multi-page documents.