scanning documents (1 Viewer)

[Dvorak]

Hi.

How do I scan documents to my access 2007 database?

Can you give me examples???

Thanks

 

[RonPaii]

I am attaching a module using Microsoft Windows Image Acquisition Library v2.0 to do the scanning.

The commented out enum(s) can be removed.

modUtility.Logger in LogError can be replace with your logger or debug.pring

pai1_Msg_Box can be replaced with the standard msgBox function.

 

[Dvorak]

I am attaching a module using Microsoft Windows Image Acquisition Library v2.0 to do the scanning.

The commented out enum(s) can be removed.

modUtility.Logger in LogError can be replace with your logger or debug.pring

pai1_Msg_Box can be replaced with the standard msgBox function.

I am new, do not understand

 

[MarkK]

Maybe, as a starting point, describe where you are stuck. Otherwise we have to guess what you might find useful.

 

[Dvorak]

Maybe, as a starting point, describe where you are stuck. Otherwise we have to g

Maybe, as a starting point, describe where you are stuck. Otherwise we have to guess what you might find useful.

examples???????????????/
uess what you might find useful.i need examples

 

[Dvorak]

Maybe, as a starting point, describe where you are stuck. Otherwise we have to guess what you might find useful.

Maybe, as a starting point, describe where you are stuck. Otherwise we have to guess what you might find useful.

examples???????????????????????????/

 

[RonPaii]

I am new, do not understand

What don't you understand? I uploaded a VBA module as a text file. Do you not know VBA? Do you not know how to import the file?

 

[Dvorak]

What don't you understand? I uploaded a VBA module as a text file. Do you not know VBA? Do you not know how to import the file?

i use access vba 2007

 

[The_Doc_Man]

From your question and comments, it seems you are a novice at Access. Let me ask a more important question. Are you aware of the size limits in an Access database? Because loading scanned documents can rapidly blow past the size limits on Access back-end or stand-alone files.

Questions you should be asking at the preliminary phase include "What is the size of each file I am loading?" "How many files am I planning to load?" "What will I do with those files once I have them?" "Will I have to remove, replace, or otherwise interact with the loaded content at a detailed level?" "Will I need to read the files other than as images - i.e. text mods?"

Imported scanned files that are actually stored in the DB do not shrink in size. There are two approaches to loading scanned files. One is to walk into it knowing you will have limited numbers of files. The other is to move the files to a safe place on your target disk but only keep the file specification (device, path, name, type) in the DB and just reference it when you need it.

 

[Dvorak]

From your question and comments, it seems you are a novice at Access. Let me ask a more important question. Are you aware of the size limits in an Access database? Because loading scanned documents can rapidly blow past the size limits on Access back-end or stand-alone files.

Questions you should be asking at the preliminary phase include "What is the size of each file I am loading?" "How many files am I planning to load?" "What will I do with those files once I have them?" "Will I have to remove, replace, or otherwise interact with the loaded content at a detailed level?" "Will I need to read the files other than as images - i.e. text mods?"

Imported scanned files that are actually stored in the DB do not shrink in size. There are two approaches to loading scanned files. One is to walk into it knowing you will have limited numbers of files. The other is to move the files to a safe place on your target disk but only keep the file specification (device, path, name, type) in the DB and just reference it when you need it.

examples??????

 

[theDBguy]

examples??????

Hi. Welcome to AWF?

What kind of examples are you looking for? Didn't you already get an example from the second post? Are you looking for a tutorial or a link to a video? Or, are you asking for an Access database that does the document scanning?

If you don't know how to code, there is a way to do this without coding. For example, you can use the built-in scanning software in your computer and then just attach the file to your database.

Sent from phone...

 

[Dvorak]

an accesss database example

 

[theDBguy]

an accesss database example

Take a look at this one.

Scan muli-page document in Access database

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...

www.access-programmers.co.uk

 

[The_Doc_Man]

You are getting some examples but you won't get any from me because I don't know your actual requirements. Without knowing your requirements, I am likely to waste your time and mine going in random directions. Sitting here repeatedly asking for examples isn't instilling me with confidence over the likelihood of success in your project. I'll say it the way it was told to me forty years ago. The 7-P rule applies to any project. "Pathetically Poor Planning Produces Pathetically Poor Products." Look at the questions I asked. Can you answer them?

 

[MarkK]

Hi.

How do I scan documents to my access 2007 database?

Can you give me examples???

Thanks

• Make sure the scanner is plugged in.
• If you have a flatbed scanner, make sure the text you want scan is facing the glass.