Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Fri Oct 15 09:00:36 CDT 2004
Susan, I'm sending you a simple db (A2K, 208KB) that includes an automatic login/exit form, modules for computer name and user name, and a usys table that stores this information along with a date/time stamp. Notes: 1. Requires a DAO reference. 2. Login info is tracked regardless of whether the user exits from the login form or not. I basically just use it as a scare tactic to keep honest people honest. Mark -----Original Message----- From: Klos, Susan [mailto:Susan.Klos at fldoe.org] Sent: Friday, October 15, 2004 9:15 AM To: 'AccessD at databaseadvisors.com' Subject: [AccessD] Get user name This thread went around awhile back and I looked it up in the archives. I want to use the code that was suggested, but I don't know 1) how to call the function or 2) if it will work in our situation. Most of our users are on Windows2000 but a couple are still on NT. Does that make a difference. Do I need a login screen or can I just have the username entered into the table (backend on a network drive) when the user opens the form or enters a new record on the form. And finally how do I call the function in the form? I guess I could ask if anyone has a simple project log database already developed that they wouldn't mind sharing. Ours is really quite simple in that all we want to keep track of is what projects staff members are working on, requester, due dates, and a few other things. Any help would be greatly appreciated. Susan Klos Senior Database Analyst Evaluation and Reporting Florida Department of Education 850-245-0708 sc 205-0708 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com