Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is it open?
- Thread starter Heartbeat
- Start date
MinAmiChief
Technical User
This may sound a little overkill but its the only thing I could think of...
1.. Retrive the user id of the person logged in.
(there is VBA code for this somewhere I'm not sure...)
2. Have the user id in a table that shows what department that person is in.
3. Update the table whenever there someone enters of exits (1 entered 0 exit).
4. Run a VBA macro that piks up all of the users who have entered the database.
Is this OK?
Number one is just a matter of copying code and pasting it into VB. I know its in the MS Knowledge DB.
HTH
The Chief.
1.. Retrive the user id of the person logged in.
(there is VBA code for this somewhere I'm not sure...)
2. Have the user id in a table that shows what department that person is in.
3. Update the table whenever there someone enters of exits (1 entered 0 exit).
4. Run a VBA macro that piks up all of the users who have entered the database.
Is this OK?
Number one is just a matter of copying code and pasting it into VB. I know its in the MS Knowledge DB.
HTH
The Chief.
- Status
Similar threads
- Locked
- Question
- Locked
- Question