Welcome to SPN

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

Sign Up Now!

Change Access application name in VBA

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

  1. Paradigm

    Paradigm
    Expand Collapse
    Guest

    I have an Access application that is opened in a number of ways depending on
    a parameter that is passed (a diiferent form is opened). I would like to
    change the name in the main Access window depending on which way it is
    opened i.e. if one form opens the name would be Example1 and if another form
    is opened firest the name would be Example2.
    I am not sure how this can be done. Please help.
    Alec
     
  2. Loading...


  3. Louwsma

    Louwsma
    Expand Collapse
    Guest

    Paradigim,

    You can change the title from the specific form thats being loaded. To
    do that, you have to put the following VBA line in the On Load event on
    each 'opening'-form:

    CurrentDb.Properties!AppTitle = "Some title name here..."

    E.


    Paradigm schreef:

    > I have an Access application that is opened in a number of ways depending on
    > a parameter that is passed (a diiferent form is opened). I would like to
    > change the name in the main Access window depending on which way it is
    > opened i.e. if one form opens the name would be Example1 and if another form
    > is opened firest the name would be Example2.
    > I am not sure how this can be done. Please help.
    > Alec
     
  4. Paradigm

    Paradigm
    Expand Collapse
    Guest

    thanks
    Alec
    "Louwsma" <e.louwsma@gmail.com> wrote in message
    news:1150796541.167311.111850@y41g2000cwy.googlegroups.com...
    > Paradigim,
    >
    > You can change the title from the specific form thats being loaded. To
    > do that, you have to put the following VBA line in the On Load event on
    > each 'opening'-form:
    >
    > CurrentDb.Properties!AppTitle = "Some title name here..."
    >
    > E.
    >
    >
    > Paradigm schreef:
    >
    > > I have an Access application that is opened in a number of ways

    depending on
    > > a parameter that is passed (a diiferent form is opened). I would like to
    > > change the name in the main Access window depending on which way it is
    > > opened i.e. if one form opens the name would be Example1 and if another

    form
    > > is opened firest the name would be Example2.
    > > I am not sure how this can be done. Please help.
    > > Alec

    >
     

Share This Page