Copy data from Access Report?

Dear experts -
I would like to have a summary section of a report that shows rows of numbers (e.g., for each person, maybe 15 columns).
Right now, these are simply separate fields, not a subreport or the like.
My goal is to display this information, but also allow the person to copy and paste that tabular data into Excel.
Any guidance on the best way to do this?
Thanks!
terpsichoreAsked:
Who is Participating?
 
PatHartmanCommented:
Try opening the report in Report View rather than Print Preview.  That view allows screen scraping and you can copy blocks of data and paste it into Excel.  I think your code doesn't run in this view though so that could be a problem.
0
 
PatHartmanCommented:
I would create a subreport and do all the calculations in the query.  Then you can add a button to export the query to Excel and that would use the TransferSpreadsheet Method.
0
 
terpsichoreAuthor Commented:
good idea - out of curiosity, is there any way to copy the text to the clip-board easily? people are popping into this report all the time, it would be much faster than having to create a separate spreadsheet every time. In other situations, we have a datasheet form form which we can simply copy text to the clipboard - is there a solution like this? Thanks!
0
 
terpsichoreAuthor Commented:
many thanks - very good ideas that I'm sure will do the trick.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.