scanning documents (4 Viewers)

[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