• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 873
  • Last Modified:

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!
0
terpsichore
Asked:
terpsichore
  • 2
  • 2
1 Solution
 
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
 
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
 
terpsichoreAuthor Commented:
many thanks - very good ideas that I'm sure will do the trick.
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now