database structure

[Mark]

Hi all,

I have a general question regarding a database I created.
In this database I have many forms and reports... some
based off of queries that ask the user to enter their ID
and NT login name.

Here is where I should probably state that some people
might consider me to "know just enough about Access and
prgramming to be dangerous"... but in hindsite I created
the database without knowing the following:

My question is: As my database is now... when the
database is opened... the switchboard allows the user to
select forms or reports to open. Once in some forms...
the user can access other forms and reports, but they are
asked again for their ID/NT login name. This multiple
asking the user for their ID/NT Login name is quite
repetitive because I just have the forms/reports based on
queries. I am not sure how I would go about making the
database more user friendly and not ask the user to enter
their ID/NT login name so many times... can I do this
after having created the database... things are getting
complicated.

Any suggestions for future reference would be very much
welcomed!

 

[Allen Browne]

When they originally enter their username and password, could you just hide
this form instead of closing it? It is then open in the background to refer
to when needed.

As a bonus, the Unload event of this hidden form lets you know that the
application is being closed if you need to do anything such as writing a log
that the user exited.