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.

 

[arnelgp]

i think what you are trying to ask is a barcode scanner.
because if it was a document, you can manually scan it using scanner/printer and save the pdf.

in case of barcode, you need to buy a barcode reader.
it has same functionality as a keyboard, so whatever you click to scan
will be recognized by MS Access.
but you will need to decode it to be of used.

 

[Gasman]

From a Google of 'how to scan a barcode into an access db'
Each scanner setup can be different.

 

[CJ_London]

@Dvorak - suggest you write your question in your native language, highlight it and select translate (to English) then copy/paste the translation to the thread

Assuming Spanish:

Le sugiero que escriba su pregunta en su idioma nativo, resáltela y seleccione traducir (al inglés) y luego copie/pegue la traducción en el hilo

 

[Ken Sheridan]

examples??????

You might like to take a look at BrowseDemo.zip in my Dropbox public databases folder at:

https://www.dropbox.com/scl/fo/0sci...cGdr3QW0?rlkey=ib6bs6g9jqcrywwzivur3265t&dl=0

This little demo file illustrates how one or more files can be associated with each record in a bound form by browsing to the file, whose path is then stored as text in a related table to which a subform is bound. In the subform buttons allow the user to open the file in its associated application, or to print the file directly where appropriate.

The bound controls in the subform illustrate how to simulate the text as a hyperlink, on which the user can click to open the file.

By storing the paths to the file as text, minimal space in the database is used, so the bloat which would result from embedding images of the documents is avoided.

 

[DickyP]

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.

Can't agree more with this. I literally have thousands of scanned attachments associated with my databases. They are, however, all separate files with paths stored in the databases.