?
Solved

Subdatasheet

Posted on 2006-11-24
7
Medium Priority
?
844 Views
Last Modified: 2008-02-01
How do I get the formatted results of a query with a subdatasheet to Excel?  Needs to be emailed so I need it in Excel.  I want the reader to be able to collapse the summarized totals of the query to see the details in the subdatasheet.
0
Comment
Question by:error_prone
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18008902
Do you mean a report?
0
 

Author Comment

by:error_prone
ID: 18008909
Will if you export the report in Snapshot view, will it still allow the expand/collapse capability?  
0
 

Author Comment

by:error_prone
ID: 18008927
automatically...
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 34

Accepted Solution

by:
jefftwilley earned 1500 total points
ID: 18008948
No, snapshot view is just that...it's non-interactive after that. You can however export as html then you can open it in excel. I do this when I want to keep the report formatting. I wrote a code module that exports my report as html, renames it as .xls

Give that a try and let us know if that's what you're after.

J
0
 

Author Comment

by:error_prone
ID: 18008950
nevermind, I did it in Excel.
0
 

Author Comment

by:error_prone
ID: 18008952
There's a Subtotal option in Excel
0
 

Author Comment

by:error_prone
ID: 18009530
Saving it as html is an interesting idea, although it doesn't really save all of the formatting.  The color and any bordering applied is gone.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

801 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