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

How can I send Report from MS Acces to Excel?

100+
P: 101
Hi,
I have project in Access.
Now I am generating report in it.
When I select an Item from combobox and click on Search button then Report Apperar to me After that I want to Send it to Excel by clicking button.But can we put buttons on Report?Or I have to put Button on Form and then do it.
Is this possible?
Anyone have solution?
Plz send it to me.
Thanks.
Dec 10 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,389
You'll have to put the button on the form.
Dec 10 '07 #2

100+
P: 101
Thanks for ur reply.
I already try using button in Form.
I created button using wizard in that I choose Report Operation and then SEND REPORT TO FILE.
But when I run the form, select item from combobox and, click on that button then it will show me some options ,in that I select Excel 95-2002, then click ok then it will generate excel file ,but in that file I found all data of my table.
But I want only data for item I selected from combobx.
can u tell me how can I do that?
Dec 10 '07 #3

Rabbit
Expert Mod 10K+
P: 12,389
You'll have to base the report on a query. And the query will filter the records based on your combo box selection.
Dec 10 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.