Welcome to SPN

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

Sign Up Now!

Form Question

Discussion in 'Information Technology' started by Matt W., Nov 9, 2005.

Tags:
  1. Matt W.

    Matt W.
    Expand Collapse
    Guest

    I have a lot of forms that are all identical to each other. If i need to make
    a change to the form i have to go into each form and make the change. Is
    there a quicker way to change the design of one form that gets applied to all
    the forms? Any input is appreciated. Thanks
     
  2. Loading...


  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Why would you have "a lot of forms that are all identical"

    The answer is to delete all but one.


    --
    Rick B



    "Matt W." <MattW@discussions.microsoft.com> wrote in message
    news:F6E41067-DA24-46BD-AFD5-7D71B0EB5A3C@microsoft.com...
    >I have a lot of forms that are all identical to each other. If i need to
    >make
    > a change to the form i have to go into each form and make the change. Is
    > there a quicker way to change the design of one form that gets applied to
    > all
    > the forms? Any input is appreciated. Thanks
     
  4. Matt W.

    Matt W.
    Expand Collapse
    Guest

    The designs are identical, each form gets different information from
    different queries

    "Matt W." wrote:

    > I have a lot of forms that are all identical to each other. If i need to make
    > a change to the form i have to go into each form and make the change. Is
    > there a quicker way to change the design of one form that gets applied to all
    > the forms? Any input is appreciated. Thanks
     
  5. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Matt W. wrote:
    > The designs are identical, each form gets different information from
    > different queries
    >
    > "Matt W." wrote:
    >
    >> I have a lot of forms that are all identical to each other. If i
    >> need to make a change to the form i have to go into each form and
    >> make the change. Is there a quicker way to change the design of one
    >> form that gets applied to all the forms? Any input is appreciated.
    >> Thanks


    The RecordSource of a form can be changed easily in code. You can do all of
    this with one form.

    --
    I don't check the Email account attached
    to this message. Send instead to...
    RBrandt at Hunter dot com
     
  6. Peter Danes

    Peter Danes
    Expand Collapse
    Guest

    Make one form and set its recordsource at runtime.

    Me.RecordSource = "NameOfQuery"

    --
    Pete

    This e-mail address is fake to keep spammers and their auto-harvesters out
    of my hair. If you need to get in touch personally, I am 'pdanes' and I use
    Yahoo mail. But please use the newsgroups whenever possible, so that all may
    benefit from the exchange of ideas.


    "Matt W." <MattW@discussions.microsoft.com> pí¹e v diskusním pøíspìvku
    news:F92ECE1F-AEF7-49F5-A596-D1D8A7AD7A29@microsoft.com...
    > The designs are identical, each form gets different information from
    > different queries
    >
    > "Matt W." wrote:
    >
    > > I have a lot of forms that are all identical to each other. If i need to

    make
    > > a change to the form i have to go into each form and make the change. Is
    > > there a quicker way to change the design of one form that gets applied

    to all
    > > the forms? Any input is appreciated. Thanks
     
  7. Matt W.

    Matt W.
    Expand Collapse
    Guest

    Well, Different users will be using this Db and I don't want them to have to
    change the record source every time they need to look at other data. I was
    just wondering if there was an easier way, Thanks

    "Rick Brandt" wrote:

    > Matt W. wrote:
    > > The designs are identical, each form gets different information from
    > > different queries
    > >
    > > "Matt W." wrote:
    > >
    > >> I have a lot of forms that are all identical to each other. If i
    > >> need to make a change to the form i have to go into each form and
    > >> make the change. Is there a quicker way to change the design of one
    > >> form that gets applied to all the forms? Any input is appreciated.
    > >> Thanks

    >
    > The RecordSource of a form can be changed easily in code. You can do all of
    > this with one form.
    >
    > --
    > I don't check the Email account attached
    > to this message. Send instead to...
    > RBrandt at Hunter dot com
    >
    >
    >
     
  8. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 8 Nov 2005 10:21:19 -0800, "Matt W."
    <MattW@discussions.microsoft.com> wrote:

    >Well, Different users will be using this Db and I don't want them to have to
    >change the record source every time they need to look at other data. I was
    >just wondering if there was an easier way, Thanks
    >


    How do the queries differ? Does each query have the same tables, and
    the same fields, just different criteria? If so, you only need ONE
    form and ONE query; just make it a Parameter query which either
    prompts for the criteria, or reads them from a Form. Post back if
    that's what you're trying to do.

    John W. Vinson[MVP]
     
  9. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Matt W. wrote:
    > Well, Different users will be using this Db and I don't want them to
    > have to change the record source every time they need to look at
    > other data. I was just wondering if there was an easier way, Thanks


    I would place a ComboBox or similar in the Form header and based on the entry in
    that switch to the appropriate RecordSource. The user wouldn;t even be aware of
    what was going on.

    --
    I don't check the Email account attached
    to this message. Send instead to...
    RBrandt at Hunter dot com
     

Share This Page