Hendra-
You could try:
RunCommand acCmdSelectRecord
RunCommand acCmdCopy
That will copy all the columns in the current record to the clipboard, but it
will not copy any text box that uses an expression as the Control Source. You
can fix that by putting the expression in the query that is the Record Source
for the form, and then bind the text box to the calculated column from the
query.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Nashua, NH)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Tuesday, March 06, 2012 7:09 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Copy all data on a form to clipboard
Hi Everyone...
Can we copy all data on a form included all fields and values of calculated
unbound text box and Columns Head to clipboard..?
For example i have a form that have Record Source from a table that have
3 fields :ID, FirstName, LastName...
and on that form i have an unbound textbox (txtName) with Control Source
=[LastName]&", "&[FirstName]...so the form have 4 controls for data to
display....asumed that the form have 10 records...
Can we copy all thoose 10 records displayed data on the form included data in
txtName and the head of columns to clipboard..?
All i want to do is give the user to enable copy the data on the form
to clipboard and then they can paste it to excel...i can do this with
open the query that builded from the record source table, but i want to
do this with a form...
Regards
Hendra
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar