Welcome to SPN

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

Sign Up Now!

Wanted: vba code sample for for and sub-form

Discussion in 'Information Technology' started by Will, Nov 1, 2005.

  1. Will

    Will
    Expand Collapse
    Guest

    1 - When you use the Wizard in Access to build a form and a sub form... does
    it actually create vba code that you can look at and use as an example on
    how to do it yourself?

    If so, where can I find the code after I use the Wizard?

    2 - Would anyone be kind enough to provide a simple vba example on how to do
    this that I could use as a learning model?

    thanks for any help.
     
  2. Loading...

    Similar Threads Forum Date
    I Just Wanted To Say Sorry Hard Talk Mar 3, 2016
    Khushwant wanted Sikhs to retain identity Blogs Oct 21, 2015
    General Desperately Wanted: Dhol Videos :) Videos Aug 24, 2012
    India Name changes in store for girls called Unwanted Breaking News Oct 22, 2011
    India India's Unwanted Girls Breaking News May 23, 2011

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    The code is in the Wizards files (with names like:)

    WZMAIN80.MDE

    located in the Office folder. There used to be readable copies of some of
    them available at Microsoft downloads. I don't think they are available for
    the latest versions. Using CreateControl and CreateReportControl, you can
    write them yourself. For a sample of what a form definition looks like use
    my code at:

    http://www.datastrat.com/Code/DocDatabase.txt

    to look at your existing forms.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Will" <Will@somewhere.com> wrote in message
    news:s6m9f.222775$p_1.76507@tornado.tampabay.rr.com...
    > 1 - When you use the Wizard in Access to build a form and a sub form...

    does
    > it actually create vba code that you can look at and use as an example on
    > how to do it yourself?
    >
    > If so, where can I find the code after I use the Wizard?
    >
    > 2 - Would anyone be kind enough to provide a simple vba example on how to

    do
    > this that I could use as a learning model?
    >
    > thanks for any help.
    >
    >
    >
     
  4. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Will" <Will@somewhere.com> wrote

    > 1 - When you use the Wizard in Access
    > to build a form and a sub form... does
    > it actually create vba code that you can
    > look at and use as an example on
    > how to do it yourself?


    Arvin has answered your question, in detail.

    Now I will make a statement:

    I have _never_, using Access since about a month and a half after the debut
    of Access Version 1.0, had a business need to create a form, much less a
    form and a subform, from code. The only instance in which I can envision
    this being needed is writing a Wizard to create some particular kind of
    form, not in a production application database.

    If you will explain what it is that you are trying to accomplish, if it is
    not a "specialized Wizard", it is possible that someone here can offer you a
    suggestion of a significantly easier approach to solve the problem.

    Larry Linson
    Microsoft Access MVP
     
  5. Will

    Will
    Expand Collapse
    Guest

    Larry,

    I'm not sure I understand your comment.

    If you don't create forms... how do your users enter data into your
    database?

    Acesss normall does an OK job of doing this for you when you need it... but
    I wanted to see how to do it using vba.

    I think I missed your point... would you try again and educate me?

    thanks,

    Will

    "Larry Linson" <bouncer@localhost.not> wrote in message
    news:eHau7im3FHA.1148@tk2msftngp13.phx.gbl...
    > "Will" <Will@somewhere.com> wrote
    >
    > > 1 - When you use the Wizard in Access
    > > to build a form and a sub form... does
    > > it actually create vba code that you can
    > > look at and use as an example on
    > > how to do it yourself?

    >
    > Arvin has answered your question, in detail.
    >
    > Now I will make a statement:
    >
    > I have _never_, using Access since about a month and a half after the
    > debut of Access Version 1.0, had a business need to create a form, much
    > less a form and a subform, from code. The only instance in which I can
    > envision this being needed is writing a Wizard to create some particular
    > kind of form, not in a production application database.
    >
    > If you will explain what it is that you are trying to accomplish, if it is
    > not a "specialized Wizard", it is possible that someone here can offer you
    > a suggestion of a significantly easier approach to solve the problem.
    >
    > Larry Linson
    > Microsoft Access MVP
    >
    >
     

Share This Page