Selasa, 06 Maret 2012

[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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar