Re: Get User ID
From: Reggie (NoSpamreggie_at_NoSpamsmittysinet.com)
Date: 07/20/04
- Next message: ScubaD: "'insert into' and doubles"
- Previous message: koko: "find registered dll on Win98, ME, NT4, 2k, XP"
- In reply to: Rick B: "Re: Get User ID"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 02:55:02 -0700
Nick, Here's a good place to start
http://www.mvps.org/access/general/gen0034.htm
-- Reggie ---------- "Rick B" <anonymous@discussions.microsoft.com> wrote in message news:eOYzOdZbEHA.1048@tk2msftngp13.phx.gbl... > You would have to store the information somewhere. The best way is to > create a hidden form that opens when the front-end is opened. In the form's > open event, write code that stores the UserID (and date and time) to a > table. > > On the form's close event, delete the record from the table, or update it to > include a time and date logged off. > > This will work pretty well, but if Access crashes, the power goes off, etc. > then the table will not be accurate and you will have to fix it. I gues you > could make your open code look for any bad records for the user in the table > and delete them? > > Rick B > > > > > "Nick" <anonymous@discussions.microsoft.com> wrote in message > news:2fe2101c46d7c$f52a7830$a301280a@phx.gbl... > I am wanting to have a field in my database that displays > a list of the current users on the database. I am > strugling to write this code. > > Cheers > > Nick > >
- Next message: ScubaD: "'insert into' and doubles"
- Previous message: koko: "find registered dll on Win98, ME, NT4, 2k, XP"
- In reply to: Rick B: "Re: Get User ID"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
