Solved

Copy data from Access Report?

Posted on 2013-12-18
4
722 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 34

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 34

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

707 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now