Solved

Copy data from Access Report?

Posted on 2013-12-18
4
786 Views
Last Modified: 2013-12-18
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
Comment
Question by:terpsichore
  • 2
  • 2
4 Comments
 
LVL 35

Expert Comment

by:PatHartman
ID: 39727454
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
 

Author Comment

by:terpsichore
ID: 39727749
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
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 39727908
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
 

Author Closing Comment

by:terpsichore
ID: 39727966
many thanks - very good ideas that I'm sure will do the trick.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question