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.

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)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

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/AlbertKal...plit/index.htm

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.members.shaw.ca/AlbertKallal

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/AlbertKal...plit/index.htm
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> (E-Mail Removed)
> http://www.members.shaw.ca/AlbertKallal

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/AlbertKal...plit/index.htm
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> (E-Mail Removed)
> http://www.members.shaw.ca/AlbertKallal