If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
input scanned documents in access 2003
greetings...i need help..does any1 knows how can i automatically input a
scanned a document, store & retrieve it (view it for later purposes) in just 1 click on a command button in ms access 2003? for example, i have a database records of all employee in our company & each employee has a particular training or seminar certificates. i want to scan the certificates & store it in his files in my database & sometimes view or retrieve it for employees needs. can it be possible? tnx in adance. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
#2
|
|||
|
|||
input scanned documents in access 2003
i do this in another application but i dont have msaccess run the
scanner then automatically load the file. i have my staff scann the file then attach it to the database then the database can then open it and what not. are you wanting the database to run the scanner or the latter. You'll be really lucky if anyone know that but i can help you witht he latter if you want. as a note our scanner is our photocopier so it scans and emails the user the document which he/she can then attach to the db. Regards Kelvan |
#3
|
|||
|
|||
input scanned documents in access 2003
Lord Kelvan wrote:
i do this in another application but i dont have msaccess run the scanner then automatically load the file. i have my staff scann the file then attach it to the database then the database can then open it and what not. are you wanting the database to run the scanner or the latter. You'll be really lucky if anyone know that but i can help you witht he latter if you want. as a note our scanner is our photocopier so it scans and emails the user the document which he/she can then attach to the db. Regards Kelvan tnx kelvan, i trying to figure it out also but no luck, mybe your rght. so what should i do? our office scanner is also a photocopier (panasonic DP8035). from the copier i fetching my scan documents to my pc. thats the way it works. thnx -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
#4
|
|||
|
|||
input scanned documents in access 2003
It can be done. You can control Twain device through VBA... I had come
across the info on this very forum a while back. I never went forward with the project to I'm affraid I can't provide you with code, but dig through this forum and you should be able to find the information you need. FYI, MS' search is useless, you have to use Google Group Search tool if you wish to actually find relevant information. http://groups.google.ca/grphp?hl=en&tab=wg -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "zhockz via AccessMonster.com" wrote: Lord Kelvan wrote: i do this in another application but i dont have msaccess run the scanner then automatically load the file. i have my staff scann the file then attach it to the database then the database can then open it and what not. are you wanting the database to run the scanner or the latter. You'll be really lucky if anyone know that but i can help you witht he latter if you want. as a note our scanner is our photocopier so it scans and emails the user the document which he/she can then attach to the db. Regards Kelvan tnx kelvan, i trying to figure it out also but no luck, mybe your rght. so what should i do? our office scanner is also a photocopier (panasonic DP8035). from the copier i fetching my scan documents to my pc. thats the way it works. thnx -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 . |
#5
|
|||
|
|||
input scanned documents in access 2003
If your scanner emails you the scanned document again I don’t know how
to look into your email client and extract it i only know how to send an email from VBA in GroupWise sorry. Try to find what Daniel said to find if not ill try to help you set up the attaching and opening thing I have some fresh tested and debugged code in one of my systems I can try to modify with you for your application. Regards Kelvan |
Thread Tools | |
Display Modes | |
|
|