View Single Post
  #3  
Old February 17th, 2010, 03:53 PM posted to microsoft.public.access.tablesdbdesign
AndrewDB
external usenet poster
 
Posts: 35
Default 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?

.