Welcome to SPN

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

Sign Up Now!

MVP's I Need Your Help

Discussion in 'Information Technology' started by jetro=), Jul 28, 2006.

Tags:
  1. jetro=)

    jetro=)
    Expand Collapse
    Guest

    i am just a student, i have a project and i call it recipe database i already
    finished 80% of it but i have a problem with repor generation i am not good
    at VB code i just want to print a report per page i want but everytime i
    tried to use macros or wizard all data in my database has been printed plz
    can you share me your big i know this is not a big deal to you MVPs please
    help me modify my report. thnx!
     
  2. Loading...


  3. OP
    Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Use a Where clause in your open report statement to limit it to the record
    on your form, something like:

    DoCmd.OpenReport "Your Report", acViewPreview, , "ID=" & Me.txtID
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "jetro=)" <jetro@discussions.microsoft.com> wrote in message
    news:0F5DCB1E-19D1-4914-BBED-23297EF9E56C@microsoft.com...
    > i am just a student, i have a project and i call it recipe database i

    already
    > finished 80% of it but i have a problem with repor generation i am not

    good
    > at VB code i just want to print a report per page i want but everytime i
    > tried to use macros or wizard all data in my database has been printed plz
    > can you share me your big i know this is not a big deal to you MVPs please
    > help me modify my report. thnx!
     
  4. OP
    gee664@gmail.com

    gee664@gmail.com
    Expand Collapse
    Guest

    You do not want to use the openarg to modify the data source for your
    report?



    Arvin Meyer [MVP] wrote:
    > Use a Where clause in your open report statement to limit it to the record
    > on your form, something like:
    >
    > DoCmd.OpenReport "Your Report", acViewPreview, , "ID=" & Me.txtID
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "jetro=)" <jetro@discussions.microsoft.com> wrote in message
    > news:0F5DCB1E-19D1-4914-BBED-23297EF9E56C@microsoft.com...
    > > i am just a student, i have a project and i call it recipe database i

    > already
    > > finished 80% of it but i have a problem with repor generation i am not

    > good
    > > at VB code i just want to print a report per page i want but everytime i
    > > tried to use macros or wizard all data in my database has been printed plz
    > > can you share me your big i know this is not a big deal to you MVPs please
    > > help me modify my report. thnx!
     
  5. OP
    jetro=)

    jetro=)
    Expand Collapse
    Guest

    i just wnt to print what record i choose its like printing by date or by code.

    "gee664@gmail.com" wrote:

    >
    > You do not want to use the openarg to modify the data source for your
    > report?
    >
    >
    >
    > Arvin Meyer [MVP] wrote:
    > > Use a Where clause in your open report statement to limit it to the record
    > > on your form, something like:
    > >
    > > DoCmd.OpenReport "Your Report", acViewPreview, , "ID=" & Me.txtID
    > > --
    > > Arvin Meyer, MCP, MVP
    > > Microsoft Access
    > > Free Access downloads
    > > http://www.datastrat.com
    > > http://www.mvps.org/access
    > >
    > > "jetro=)" <jetro@discussions.microsoft.com> wrote in message
    > > news:0F5DCB1E-19D1-4914-BBED-23297EF9E56C@microsoft.com...
    > > > i am just a student, i have a project and i call it recipe database i

    > > already
    > > > finished 80% of it but i have a problem with repor generation i am not

    > > good
    > > > at VB code i just want to print a report per page i want but everytime i
    > > > tried to use macros or wizard all data in my database has been printed plz
    > > > can you share me your big i know this is not a big deal to you MVPs please
    > > > help me modify my report. thnx!

    >
    >
     
  6. OP
    jetro=)

    jetro=)
    Expand Collapse
    Guest

    thnx Mr. meyer for your support =)

    "Arvin Meyer [MVP]" wrote:

    > Use a Where clause in your open report statement to limit it to the record
    > on your form, something like:
    >
    > DoCmd.OpenReport "Your Report", acViewPreview, , "ID=" & Me.txtID
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "jetro=)" <jetro@discussions.microsoft.com> wrote in message
    > news:0F5DCB1E-19D1-4914-BBED-23297EF9E56C@microsoft.com...
    > > i am just a student, i have a project and i call it recipe database i

    > already
    > > finished 80% of it but i have a problem with repor generation i am not

    > good
    > > at VB code i just want to print a report per page i want but everytime i
    > > tried to use macros or wizard all data in my database has been printed plz
    > > can you share me your big i know this is not a big deal to you MVPs please
    > > help me modify my report. thnx!

    >
    >
    >
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page