storing username after login

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I have a login screen at the opening of my database. What I would like to
do is that after the user is logged in, that the user name is stored. I
would then like to have the user name stored when a record is added and
another field on my forms to store the user who last modified a record. The
user added would stay the same but user last update would change according to
a change that happens. What is the best way to do this, and also have it
work with multi users. I do not wish to use the User Level in Acccess but
wish to use my own login screen that I built.

Any help would be more then welcomed.

Sincerely,

Jean-Francois
 
Jean-Francois Gauthier said:
Hi there,

I have a login screen at the opening of my database. What I would like to
do is that after the user is logged in, that the user name is stored. I
would then like to have the user name stored when a record is added and
another field on my forms to store the user who last modified a record.
The
user added would stay the same but user last update would change according
to
a change that happens. What is the best way to do this, and also have it
work with multi users.
Click to expand...

To grab the user's network ID and computer name:

http://www.mvps.org/access/api/api0008.htm
http://www.mvps.org/access/api/api0009.htm
I do not wish to use the User Level in Acccess but
wish to use my own login screen that I built.
Click to expand...

That's your prerogative but I wouldn't think that approach would get much
support here. ULS has flaws but it's head and shoulders above a
roll-your-own solution.

Regards,
Keith.
www.keithwilby.com
 
Is there a way however to store the user name from my login form after it is
successfully logged in. Such as frm_main (used to log in) and field
[user_id]. This woudl be stored somewhere and kept for use to update other
records.

Thanks,

JF
 
Jean-Francois Gauthier said:
Is there a way however to store the user name from my login form after it
is
successfully logged in. Such as frm_main (used to log in) and field
[user_id]. This woudl be stored somewhere and kept for use to update
other
records.
Click to expand...

Yes, bind your form to a table.

Keith.
 
Keith said:
"Jean-Francois Gauthier"
Is there a way however to store the user name from my login form
after it is
successfully logged in. Such as frm_main (used to log in) and field
[user_id]. This woudl be stored somewhere and kept for use to
update other
records.
Click to expand...

Yes, bind your form to a table.

Keith.
Click to expand...

Or...when the user fills out the control on the form and presses [OK] or
whatever button it is you have to close the form, don't actually close it. Just
set its Visible property to False. Now you can refer to the data on the form
any time you want.
 
Hi Rick,

Thanks for your reply. I used a similar method as what you have. I have my
login form, once the user is logged in the form closed and another hidden
form opens containing the user id.

Thank you for your help.

Sincerely,

Jean-Francois

Rick Brandt said:
Keith said:
"Jean-Francois Gauthier"
Is there a way however to store the user name from my login form
after it is
successfully logged in. Such as frm_main (used to log in) and field
[user_id]. This woudl be stored somewhere and kept for use to
update other
records.
Click to expand...

Yes, bind your form to a table.

Keith.
Click to expand...

Or...when the user fills out the control on the form and presses [OK] or
whatever button it is you have to close the form, don't actually close it. Just
set its Visible property to False. Now you can refer to the data on the form
any time you want.
Click to expand...
 
Back
Top