Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

PRINTING REPORTS FROM QUERY TO EXCEL

Discussion in 'Information Technology' started by chris1980, Jul 28, 2006.

  1. chris1980

    chris1980
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    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" <sulemanzia@gmail.com> wrote in message
    news:1153181289.167540.307210@m73g2000cwd.googlegroups.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
    > 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
    >
     
  4. chris1980

    chris1980
    Expand Collapse
    Guest

    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.
    >
    > Larry Linson
    > Microsoft Access MVP
    >
    > "chris1980" <sulemanzia@gmail.com> wrote in message
    > news:1153181289.167540.307210@m73g2000cwd.googlegroups.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
    > > 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
    > >
     
  5. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    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


    "chris1980" <sulemanzia@gmail.com> wrote in message
    news:1153229407.942962.249550@m79g2000cwm.googlegroups.com...
    > 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.
    >>
    >> Larry Linson
    >> Microsoft Access MVP
     

Share This Page