PRINTING REPORTS FROM QUERY TO EXCEL

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13416-printing-reports-from-query-to-excel.html
assigned and the width, column should be perfect in excel so then a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13416
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

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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" wrote in message
news:1153181289.167540.307210@m73g2000cwd.googlegr oups.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13416
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13416
> 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
>

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 wrote:
> 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13416
>
> Larry Linson
> Microsoft Access MVP
>
> "chris1980" wrote in message
> news:1153181289.167540.307210@m73g2000cwd.googlegr oups.com...
> > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13416
> > 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
> >

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13416
Help for that command to see detail.

Larry Linson
Microsoft Access MVP


"chris1980" wrote in message
news:1153229407.942962.249550@m79g2000cwm.googlegr oups.com...
> Hey larry thanks for the reply. since i am a newbie in access
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13416
> 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 wrote:
>> 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