Use last update value from table to default in TxtBox

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

Guest

I'm was created login list in database.
How to use last updated value (lngEmpID) from login table (tblLogIn) to
default value in text box ...Form![LogOn2]![txtUser]?
lngEmpID is number linked to another table with user names.
Thanks!
 
Igor,

I always use the Registry.

When a user successfully logs in, save their details to the Registry:
SaveSetting "myApplicationName", "User Settings", "Last Login",
Me!txtUser

Then the next time the login form loads, retrieve the value from the
Registry:
Me!txtUser = GetSetting("myApplicationName", "User Settings", "Last
Login", "")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Thanks Graham,
but i need special registration to enter in some verification form inside
database and must create different login for this. Have you idea?

„Graham R Seach“ said:
Igor,

I always use the Registry.

When a user successfully logs in, save their details to the Registry:
SaveSetting "myApplicationName", "User Settings", "Last Login",
Me!txtUser

Then the next time the login form loads, retrieve the value from the
Registry:
Me!txtUser = GetSetting("myApplicationName", "User Settings", "Last
Login", "")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Igor G. said:
I'm was created login list in database.
How to use last updated value (lngEmpID) from login table (tblLogIn) to
default value in text box ...Form![LogOn2]![txtUser]?
lngEmpID is number linked to another table with user names.
Thanks!
Click to expand...
Click to expand...
 
Igor,

I'm sorry, but I don't understand. Can you rephrase?

What I'm talking about is storing the username in the Registry after a
successful login. When you next open the login form, that same username is
put into txtUser. This has the effect of using the last successful login as
the default login the next time.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Igor G. said:
Thanks Graham,
but i need special registration to enter in some verification form inside
database and must create different login for this. Have you idea?

Graham R Seach said:
Igor,

I always use the Registry.

When a user successfully logs in, save their details to the Registry:
SaveSetting "myApplicationName", "User Settings", "Last Login",
Me!txtUser

Then the next time the login form loads, retrieve the value from the
Registry:
Me!txtUser = GetSetting("myApplicationName", "User Settings", "Last
Login", "")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Igor G. said:
I'm was created login list in database.
How to use last updated value (lngEmpID) from login table (tblLogIn) to
default value in text box ...Form![LogOn2]![txtUser]?
lngEmpID is number linked to another table with user names.
Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Sorry Graham, my mistake, I'm not read carefuly.
Thanks!

„Graham R Seach“ said:
Igor,

I'm sorry, but I don't understand. Can you rephrase?

What I'm talking about is storing the username in the Registry after a
successful login. When you next open the login form, that same username is
put into txtUser. This has the effect of using the last successful login as
the default login the next time.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Igor G. said:
Thanks Graham,
but i need special registration to enter in some verification form inside
database and must create different login for this. Have you idea?

Graham R Seach said:
Igor,

I always use the Registry.

When a user successfully logs in, save their details to the Registry:
SaveSetting "myApplicationName", "User Settings", "Last Login",
Me!txtUser

Then the next time the login form loads, retrieve the value from the
Registry:
Me!txtUser = GetSetting("myApplicationName", "User Settings", "Last
Login", "")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

I'm was created login list in database.
How to use last updated value (lngEmpID) from login table (tblLogIn) to
default value in text box ...Form![LogOn2]![txtUser]?
lngEmpID is number linked to another table with user names.
Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top