Scan muli-page document in Access database (1 Viewer)

[jsbarroso]

A Sharman,
Thank you for the test database. I am finally back on this project. I receive a compatibility warning between Access 2010 and 2007 when I open your test database. Would it be possible for you to save a copy compatible with Access 2007? When I try to create a new Access 2007 database and import all the content from your test database, I receive a compile error in line “Dim FSO As New FileSystemObject”. I have tried a number of things but no luck.
It is possible to create the entire scanning and attachment process on one form. The group that will be using the database would like to simplify the process. They would like to open a form enter a file name, some brief detail and select to attach an image or PDF file.
Any assistance will be great appreciated.
Thank you in advance.

 

[jsbarroso]

a.sharma,

Thank you again for your test sample database. I can't tell you how much time you have saved me.

I have been able to use your scanning codes as part of my form request. Everything I need it to do work great.

However, currently the folders where scanned images and PDF’s are stored are created wherever the database is saved. My database is split with the back-end tables on a shared network drive. Is it possible to save the image files to the user‘s computer then, after the images are converted to PDF then, the PDF files are saved to our shared network drive?

If so, how would I do it?

 

[BSaltzer]

Re: Relate documents of multiple formats to records in Access database

Thank you all for your approaches and descriptions.

This thread has dealt with scanning documents, saving the digital images outside the Access database, and linking the images to the Access database. I’m looking more broadly than just scanning documents, and hope you can provide guidance.

I have an application for managing assets and many aspects of them. There is a table in the Access database with a record for each asset. For some of the asset there may be one or more related documents. Those documents may be in different formats: scanned, .pdf, Word (.doc or .docx), Excel (.xls or .xlsx), text, image (.jpg, .bmp, etc.), paper (in filing cabinets), etc. Each asset may have one or more related documents, and each document may be related to one or more asset. Each document may have related information: function in the life cycle of the asset (requisition/contract/purchase order number, request for proposal, purchase order, shipping document, manual, warranty, salvage certification, etc.), and other related information (vendor, manufacturer, asset description, date, etc.)

I’d like to enable the User to scan documents if necessary, and find documents of all formats related to a given asset based upon the asset identifier and the other data related to the documents. User should be able to see the documents online (other than the paper ones, of course), print them, and attach their image files to e-mails.

I have found commercial products that can deal with the documents and their relationships to the assets. But they want to “be the whole show” as if the entire operation centers around the documents. Instead I want to keep the focus on the assets and their related documents.

I have not yet found Forum-based programming or a commercial product that can integrate well with my Access database application and link to the document files of many formats outside the Access database.

Any recommendations?

 

[SHABZO]

Hallo Sir

I am trying to open the test.zip file . It says that it has unrecognizable database format. I use access 2007
Basically my client wants to scan his documents and allocate an account no to it and in his access form he needs to call it up for each patient.

 

[jmaty23]

Someone may be able to use this. This code will scan up to 10 documents using a continuous feed scanner and output them to a pdf.

 

[kalexander]

Thanks for the post. I am trying to use your test database to save the hyperlink address to multiple records. I was wondering if you would help me achieve this. If that is possible could you save multiple address to a single record across multiple records of the same form? Thanks, Ken

 

[dnohr]

Looking at the sample database, it looks pretty slick and I can get it to work using that database.

But, I need to tweak it some to incorporate into my project but I'm feeling kind of dumb.......

Where is the VBA that's actually calling the module to scan? I'm confused because looking at the code under the "From Scanner" button it just says

strWhere = "Scanner"
DoCmd.Close

But I can't seem to figure out how the first line actually makes the scanner window appear.

Basically I guess the question is, if one was to copy the modules into a new database, and create a new button to get the Scan, how do you do it.

 

[Tazzou]

Hello.

I'm French and I'm looking how to scan documents from Access and I found this forum. Everything works fine.
I need some information:
- Is it possible to scan multi-page documents directly by placing all pages in the scan charger ? If no, is it possible to modify to do that ?
- How to change the links to the folders "TempScan" and "CustDocs" to customize them?

Thank you to answer me quickly and sorry to revive this old topic.

Regards

 

[haroon.mansha]

Dear @a.sharma
I have checked your test Database, Some questions I want to ask
When we already entered the CustomerName , Why we have through Voterid
Even we can do like CustomerName = txtfield
And then it directly go to Scanner page or File option etc.
and make the output file = textfiled . pdf and store the link .

Will be greatfull if you guide me how to do it.

 

[alorenzini]

IS there a way to show the scanner interface?

 

[a7md m7md]

Is it possible to continue scanning all the papers without the message that appears after each paper, which asks whether to continue or not

 

[Mohdhtm]

Thanks for TEST file

Can i Make scanning all the document function continuing in one file, currently the database scanned document one then you have command to add the another.

Sorry for that. I have removed the password. Use this fresh attachment.

 

[Dvorak]

Someone may be able to use this. This code will scan up to 10 documents using a continuous feed scanner and output them to a pdf.

the code has errors

 

[The_Doc_Man]

the code has errors

First, it should still give you some ideas. This is a marketplace of ideas, not free coding services.

Second, look at the dates involved. MOST of the thread started in 2013 - which is 12 years ago. A lot of these people might no longer be active on the forum. The most recent use was nearly six years ago, in 3rd quarter of 2019.

Third, stating "the code has errors" is like saying "Doc, I don't feel so good. What's wrong with me?" Do you think the doctor will perhaps want to know just a LITTLE bit more of what is wrong?

If you want help, give us something to work on, like saying what errors you are getting and on which line you are getting them. BUT in the case of asking about errors in 13-year-old code, or even 6-year-old code, we are not even sure which VERSION of Access was used to produce the code that vexes you.

I'll give you this positive credit. From your other posts, you have indeed found relevant articles to which you can refer regarding the desire to deal with scanned files. Note in THIS thread that the method involves never actually loading the files to Access, but rather just using Access to track the files via file specs.

 

[Dvorak]

Someone may be able to use this. This code will scan up to 10 documents using a continuous feed scanner and output them to a pdf.

your DB has errors

 

[MarkK]

your DB has errors

Check out the date on the post you responded to. More than a decade ago.

 

[Gasman]

the code has errors

Yes, it does. It does not compile and is meant to scan from a flatbed scanner. I have managed to get it to compile, but no guarantee that it will work as it should. However consider it a start at least, so thank the person for that much.

So if this is not what you want and I believe the general opinion is you want barcode scanning, then it is not for you.

Also one liners like 'your DB has errors' is not going to endear you to those available to offer help.
'i use access vba 2007' to the question 'What don't you understand?' is another example, as you seem so fond of examples?

YOU need to help us to help you.