I am new to Microsoft Access and have recently made a simple database using
Access 2003. The Database is fine up and running and all works ok, but i
need to allow others using to input data into one form only, so that they
don't interfere with the Tables. what i am hoping can be done is that when
anyone else opens the database it displays the form stright away, they input
the data and save it and leave. This way the information will never go
missing, does anyone know if it can be done and if so how do you do it?

Thanks

Wes

On Thu, 6 Nov 2008 04:37:00 -0800, Wes <(E-Mail Removed)>
wrote:

Good idea. There is a way (under the Tools menu) to uncheck a box so
the database window does not show at startup. You can also set an
option to automatically open some form at startup. Sorry I don't have
A2003 here in front of me or I would give you the exact menu options,
but I'm sure you can find them.

-Tom.
Microsoft Access MVP


>I am new to Microsoft Access and have recently made a simple database using
>Access 2003. The Database is fine up and running and all works ok, but i
>need to allow others using to input data into one form only, so that they
>don't interfere with the Tables. what i am hoping can be done is that when
>anyone else opens the database it displays the form stright away, they input
>the data and save it and leave. This way the information will never go
>missing, does anyone know if it can be done and if so how do you do it?
>
>Thanks
>
>Wes

You could also create a macro and call it Autoexec. In this macro you could
set the warnings to no to suppress confirmation messages, use the openform
and select the form you what to open when the db is opened and use maximize.
This macro will open the form of your choice and it will span the size of
your screen. Of course when you become more familar with Access this can be
accomplished with visual basic and allow for more flexibility.

"Tom van Stiphout" wrote:

> On Thu, 6 Nov 2008 04:37:00 -0800, Wes <(E-Mail Removed)>
> wrote:
>
> Good idea. There is a way (under the Tools menu) to uncheck a box so
> the database window does not show at startup. You can also set an
> option to automatically open some form at startup. Sorry I don't have
> A2003 here in front of me or I would give you the exact menu options,
> but I'm sure you can find them.
>
> -Tom.
> Microsoft Access MVP
>
>
> >I am new to Microsoft Access and have recently made a simple database using
> >Access 2003. The Database is fine up and running and all works ok, but i
> >need to allow others using to input data into one form only, so that they
> >don't interfere with the Tables. what i am hoping can be done is that when
> >anyone else opens the database it displays the form stright away, they input
> >the data and save it and leave. This way the information will never go
> >missing, does anyone know if it can be done and if so how do you do it?
> >
> >Thanks
> >
> >Wes
>