I'm working on several databases that manage user logins via storing the information entered in to the logon form on the "main" form page of my db's. For example:
And
How many entries can a text box on a form store? Currently, the db's seem to handle multiple users, but I am unsure as to how. There is a "Logged_In" column on a user table in both db's, but access seems to depend on the storage of the data. I am considering a table that stores this information instead, and am trying to learn more about how this works. Can anyone shed some light or direct me in further research?
Many thanks!
Code:
inUserAccess = DLookup("UserAccess", "tblUsers", "[UserID]=" & txtUser)
inUserName = DLookup("UserName", "tblUsers", "[UserID]=" & txtUser)
inUserInitials = DLookup("UserInitials", "tblUsers", "[UserID]=" & txtUser)
inUserID = txtUser
[Forms]![frmMain].[txtUserAccess] = inUserAccess
[Forms]![frmMain].[txtUserName] = inUserName
[Forms]![frmMain].[txtUserInitials] = inUserInitials
[Forms]![frmMain].[txtUserID] = inUserID
And
Code:
Forms!frmMain.txtMainWelcome = "You are logged in as: " & vbNewLine & Me!cmbName.Column(1)
Forms!frmMain.txtMainUser = Me!cmbName.Column(0)
Forms!frmMain.txtMainUserAccess = Me!cmbName.Column(2)
How many entries can a text box on a form store? Currently, the db's seem to handle multiple users, but I am unsure as to how. There is a "Logged_In" column on a user table in both db's, but access seems to depend on the storage of the data. I am considering a table that stores this information instead, and am trying to learn more about how this works. Can anyone shed some light or direct me in further research?
Many thanks!