By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,952 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Export Filtered Form to Excel

P: n/a
Ken
I have a form that has a command button on it to open a report. The
report is based on the forms data, if it's filtered the report is
filtered, if the form is showing 100 records the report is showing the
same 100 records, etc.

I want to create another command button which exports to excel, in the
same manner above. Whether the form is filtered or not, the same
records should be exported.

I played around with TransferSpreadsheet but I can only get it to
export all the records to excel, even when it's filtered.

Any help would be appreciated.

Thanks,
Ken

Jan 5 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I use: DoCmd.OutputTo acOutputForm, frmNameOfForm, , , True

This code will put just the records from the record source of your
form. Play around with the acOutputForm method a little and you might
be able to get it to work exactly the way you want it to. Hope this
helps.

Jan 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.