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?