Emma,
I usually create a users table with their userid, last_name, First_name,
logged_on_at, and a couple of other fields). When they open the application,
I get their userid using the code found at the following site:
http://www.mvps.org/access/api/api0008.htm
Then I check the users table to determine whether this userid is in my
table. If not, I popup a users form and have them fill in their name and
other information I am collecting, including filling in the Logged_on_at
field (using Now()). If they are already in the users table, I just fill in
the Logged_on_At field and take them straight to my splash screen, where you
could display their name using the DLOOKUP function and their UserID.
When I do this, I also include some code in my splash screens Close event to
set the Logged_on_at field to NULL for that user. I keep my splash screen
open but hidden as long as the application is open.
--
HTH
Dale
Don''t forget to rate the post if it was helpful!
email address is invalid
Please reply to newsgroup only.
