Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

save as command cannot process any subforms

Status
Not open for further replies.

Marsellus

MIS
Apr 9, 2003
4
0
0
US
This is the error message I get when I try and export my report to Excel or to any other program.
Any suggestions? My entire report is based on subforms (a bunch of queries).
Thanks!
 
After doing a bit of digging, I found that I have the same problem. Just didn't think nothing of it until trying to output the reports automatically to email as an attachment.

Here's what you need to do.

1. Save the forms as a report.
2. Go to the main form and locate the subforms.
3. Change the Source object under the Data tab to the form, saved as a report
Works like a charm.

My ref is Microsoft Knowledge Base Article - 207489. It'll give you step by step procedures. Just make sure you save the correct form as report and select the right report as the source object for the subform. If you have any questions, let me know.

Myk
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top