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

PRINTING REPORTS FROM QUERY IN EXCEL

P: n/a
hi. i am working first time with query and reports. i have created a
database. i have reports and query. i have a button in my form by the
name of (View reports) if a user clicks on that button it opens another
form with 3 options
1) Problems all report
2) problems resolved
3) Problems not resolved
Now what i really want is when a user clicks on Problems all report it
should go directly into excel worksheet based on my query which i have
assigned and the width, column should be perfect in excel so then a
user can print. secondly same thing goes for problems resolved based on
my query which wil show all the problems which have been resolved and
should open it in excel with everything alligned and ready to print. i
know it is possible and i have been able to just print Problems all
based on report not with my query and the formatting was really bad. i
need to print reports based on my query directly in Excel worksheet
with everything perfectly formatted. any help will be really
appreciated.
Thanks alot

Jul 18 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
There's nothing stopping you from using ADO to pump the data into a SS
template. That and some Excel VBA should do just fine.

Jul 18 '06 #2

P: 6
try makind an excel file with macros that will do all the formating and printing you need. Then after opening the query copy all the data, open the excel file and let the file paste /throuth the macro/ the data and do all the rest you need to be done.
Jul 18 '06 #3

P: n/a
hey thanks for the reply. since i am a newbie in these reports and
query thing
can you explain me a little bit more. what kind of VB procedure i had
to type and what is an ADO and SS template.
i really appreciate that.
pi********@hotmail.com wrote:
There's nothing stopping you from using ADO to pump the data into a SS
template. That and some Excel VBA should do just fine.
Jul 18 '06 #4

P: n/a
Try this
http://www.mvps.org/access/modules/mdl0035.htm

you also might want to look for transferring your data to a template.
Otherwise, you're going to have to run AutoResize or whatever in code
in Excel

Jul 19 '06 #5

P: n/a
hi. the website sounds good. let me give you a little bit of idea what
i will be doing tomorrow. i will be creating a standard module and copy
the code on the website. now i was reading on the website the author
said to use the copy from recordset which he prefers more so i will
try to concentrate on that part of code to see if it works or not.
secondly and last since i have a button in my form which takes directly
to the excel worksheet what kind of onclick procedure you think i
should create with the standard module on the website?
Thanks
Sub sCopyFromRS()

pi********@hotmail.com wrote:
Try this
http://www.mvps.org/access/modules/mdl0035.htm

you also might want to look for transferring your data to a template.
Otherwise, you're going to have to run AutoResize or whatever in code
in Excel
Jul 19 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.