Hi guys,

Is there anyway to automatically pop-up a form when oppening my MS Access
application?

I also want to allow users to use specific forms.

Thanks in advance,
Aldo.

Open your application.
On the main menu go to "Tools\StartUp".
Fill in the name of the form you want to open.

Regards
Kevin

"Aldo" <(E-Mail Removed)> wrote in message
news:A5BC9D62-CF31-4917-8663-(E-Mail Removed)...
> Hi guys,
>
> Is there anyway to automatically pop-up a form when oppening my MS Access
> application?
>
> I also want to allow users to use specific forms.
>
> Thanks in advance,
> Aldo.

You are right, that will open the form. I set it to Switchboard.
The problem is that the user can still get access to all tables and queries.
I want to allow them to use only forms.
Thanks,
Aldo.



"kc-mass" wrote:

> Open your application.
> On the main menu go to "Tools\StartUp".
> Fill in the name of the form you want to open.
>
> Regards
> Kevin
>
> "Aldo" <(E-Mail Removed)> wrote in message
> news:A5BC9D62-CF31-4917-8663-(E-Mail Removed)...
> > Hi guys,
> >
> > Is there anyway to automatically pop-up a form when oppening my MS Access
> > application?
> >
> > I also want to allow users to use specific forms.
> >
> > Thanks in advance,
> > Aldo.
>
>
>

In the same area there is a checkbox for show database window. Uncheck this.

if you need it after that, F11 will show the window again.

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"Aldo" wrote:

> You are right, that will open the form. I set it to Switchboard.
> The problem is that the user can still get access to all tables and queries.
> I want to allow them to use only forms.
> Thanks,
> Aldo.
>
>
>
> "kc-mass" wrote:
>
> > Open your application.
> > On the main menu go to "Tools\StartUp".
> > Fill in the name of the form you want to open.
> >
> > Regards
> > Kevin
> >
> > "Aldo" <(E-Mail Removed)> wrote in message
> > news:A5BC9D62-CF31-4917-8663-(E-Mail Removed)...
> > > Hi guys,
> > >
> > > Is there anyway to automatically pop-up a form when oppening my MS Access
> > > application?
> > >
> > > I also want to allow users to use specific forms.
> > >
> > > Thanks in advance,
> > > Aldo.
> >
> >
> >

"Aldo" <(E-Mail Removed)> wrote in message
news:B2B351D0-75BF-4897-A179-(E-Mail Removed)...
> You are right, that will open the form. I set it to Switchboard.
> The problem is that the user can still get access to all tables and
> queries.
> I want to allow them to use only forms.
> Thanks,
> Aldo.
>

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKal.../msaccess.html

You should distribute a mde to your users if you really want to lock up the
designs parts.....

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)