PRINTING REPORTS FROM QUERY TO EXCEL

[chris1980]

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

 

[Larry Linson]

If your purpose of using Excel worksheet is just so you can control the
printing, I suggest that with minimal learning time, you should be able to
print exactly what you need from an Access Report.

Larry Linson
Microsoft Access MVP

 

[chris1980]

Hey larry thanks for the reply. since i am a newbie in access
what i really wanted to do is create some kind of VB procedure like
Docmd.openreport something like that so then when a user clicks on my
report button
it should go directly into excel through access. and i do have query
reports. how can i print my query
reports in excel. can you explain me a little bit more
Thanks

 

[Larry Linson]

Chris,

I did not answer the question "how can i print my query reports in excel". I
suggested that, if your only purpose of exporting the information to Excel
was in order to _print_ it, that Access reports are very good for formatting
and printing information. (I've been in the computer business for 48 years,
and am not aware of a better, easier-to-learn report generator than Access'
Reports.)

I'm not the person to answer that specific question, because I've used
Access since Jan. 1993 and have never found a need to move, nor seen any
benefit from moving, Access data to Excel for the purpose of formatting or
printing.

If you have other needs for having the information in Excel, the
DoCmd.TransferSpreadsheet command can be used to export the data directly,
instead of saving formatted text from a Report. In the module window, use
Help for that command to see detail.

Larry Linson
Microsoft Access MVP