[AccessD] Need to Push a Field from a Report Detail Line to theWindows Clipboard

All,

I think I have figured out a solution.  I set up a new text box in the report header.
A Click on the field in the detail line stows the value of this field in the new text box.
Next focus is set to the new text box which is then followed by the "DoCmd.RunCommand acCmdCopy"

Brad


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Brad Marks
Sent: Thu 6/7/2012 3:54 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Need to Push a Field from a Report Detail Line to theWindows Clipboard
 
All,

Our users would like to have a feature on an Access 2007 report to push
data from one of the report's detail lines to the Windows Clipboard
(Report View).

I have experimented with other fields on the report that are not on the
detail lines.  These work nicely with something like this

~~~
Me!Field1.SetFocus
 DoCmd.RunCommand acCmdCopy 
~~~

I can't seem to find a way to do this with a field on the detail line of
the report, however.

Is this possible?

Thanks
Brad

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.