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
|
|||
|
|||
A REAL CHALLANGE
I need to (from within Access) 1. Open a document scanning software so that a
document can be scanned; and then, after scanning, record the file name of the scanned document in a database without having to enter the file name by typing it. (The scanning software automatically enters a file name for the document in the "save as" dialogue box) As I see it the created file name needs to be copied to the clipboard when the document is saved; and then pasted to the correct field in the Access database. Anybody know if this can be done? -- Kepior Senso Fumor |
#2
|
|||
|
|||
A REAL CHALLANGE
On Mon, 15 Feb 2010 00:55:01 -0800, AndrewDB
wrote: RunCommand acCmdCopy will copy to the clipboard. The difficulty will be that the name needs to be selected and have the focus, just like if you would hit Ctrl+C yourself. Perhaps better to use scanning software that has an Automation interface, so you can tell it which document name to use, or at the least retrieve the document name used. -Tom. Microsoft Access MVP I need to (from within Access) 1. Open a document scanning software so that a document can be scanned; and then, after scanning, record the file name of the scanned document in a database without having to enter the file name by typing it. (The scanning software automatically enters a file name for the document in the "save as" dialogue box) As I see it the created file name needs to be copied to the clipboard when the document is saved; and then pasted to the correct field in the Access database. Anybody know if this can be done? |
#3
|
|||
|
|||
A REAL CHALLANGE
Hi Tom
Thanks for your response. I Knew it would not be a simple solution. Just wondered if there was a way to capture the name of the last file saved in Windows considering "My Recent Documents" (In XP) facility is available. -- Kepior Senso Fumor "Tom van Stiphout" wrote: On Mon, 15 Feb 2010 00:55:01 -0800, AndrewDB wrote: RunCommand acCmdCopy will copy to the clipboard. The difficulty will be that the name needs to be selected and have the focus, just like if you would hit Ctrl+C yourself. Perhaps better to use scanning software that has an Automation interface, so you can tell it which document name to use, or at the least retrieve the document name used. -Tom. Microsoft Access MVP I need to (from within Access) 1. Open a document scanning software so that a document can be scanned; and then, after scanning, record the file name of the scanned document in a database without having to enter the file name by typing it. (The scanning software automatically enters a file name for the document in the "save as" dialogue box) As I see it the created file name needs to be copied to the clipboard when the document is saved; and then pasted to the correct field in the Access database. Anybody know if this can be done? . |
Thread Tools | |
Display Modes | |
|
|