Welcome to SPN

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

Sign Up Now!

How to change Access Startup form from a form combo box?

Discussion in 'Information Technology' started by jhutchings@eadmotors.com, Jul 28, 2006.

  1. jhutchings@eadmotors.com

    jhutchings@eadmotors.com
    Expand Collapse
    Guest

    Hi,

    I have an Access DB application that I have developed over the past 6
    months. It is essentially a human resources time off tracking system
    that keeps track of all employee time off requests and then some.

    I have the DB load with a startup form allowing the user to view 3
    different sections. Two of the sections are simple password protected
    forms only certain users are allowed to access due to confidential
    information(I do not use Access security).

    The DB is stored on a network drive and select users have access to it.
    However, I do a lot of maintenance on the database and at times I
    cannot complete the things I need to because other users are in the
    database preventing me from doing edits.

    I have developed a simple form that will tell users that the database
    is currently undergoing maintenance and a countdown eventually closes
    out Access for them.

    Here is my question - Is there a way to develop a form that has a drop
    down list of all the forms I have in my DB and select which form I want
    to load at startup. That way, I can change the startup form from within
    the application and I won't have to go into the database window
    Tools>Startup Options to change the startup form.

    Sorry for the longwinded post - just wanted to give all the details.
     
  2. Loading...


  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Try using the following SQL:

    SELECT [Name]
    FROM MSysObjects
    WHERE Type=-32768
    ORDER BY [Name]


    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    <jhutchings@eadmotors.com> wrote in message
    news:1150748114.476011.140160@h76g2000cwa.googlegroups.com...
    > Hi,
    >
    > I have an Access DB application that I have developed over the past 6
    > months. It is essentially a human resources time off tracking system
    > that keeps track of all employee time off requests and then some.
    >
    > I have the DB load with a startup form allowing the user to view 3
    > different sections. Two of the sections are simple password protected
    > forms only certain users are allowed to access due to confidential
    > information(I do not use Access security).
    >
    > The DB is stored on a network drive and select users have access to it.
    > However, I do a lot of maintenance on the database and at times I
    > cannot complete the things I need to because other users are in the
    > database preventing me from doing edits.
    >
    > I have developed a simple form that will tell users that the database
    > is currently undergoing maintenance and a countdown eventually closes
    > out Access for them.
    >
    > Here is my question - Is there a way to develop a form that has a drop
    > down list of all the forms I have in my DB and select which form I want
    > to load at startup. That way, I can change the startup form from within
    > the application and I won't have to go into the database window
    > Tools>Startup Options to change the startup form.
    >
    > Sorry for the longwinded post - just wanted to give all the details.
    >
     
  4. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

  5. jhutchings@eadmotors.com

    jhutchings@eadmotors.com
    Expand Collapse
    Guest

    Hi Albert,

    Yes - splitting is a good idea. However, I would still like to find a
    way to accomplish what I would like to do so that its easier for a
    novice user to make simple changes such as these if I am not around to
    make them.


    Albert D.Kallal wrote:
    > I good solution would be to split your database, and thus your development
    > problems would go away.
    >
    > I explain this here:
    >
    > http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
    >
    > --
    > Albert D. Kallal (Access MVP)
    > Edmonton, Alberta Canada
    > pleaseNOOSpamKallal@msn.com
    > http://www.members.shaw.ca/AlbertKallal
     

Share This Page