Automating/ Verifying data entry in a form
in [Forms]
|
Prev: Print All/Selected
Next: front end and back end
From: Tayo on 30 Jun 2008 05:58 I have a table shown below UserID FName LName Pw 1A FN1 LN1 FN1LN1 2A FN2 LN2 FN2LN2 3A FN3 LN3 FN3LN3 4A FN4 LN4 FN4LN4 I now have a form with 4 textboxes named txtUserID txtFName txtPW txtLName My Questions: 1. How would I set the controls so that when a user typed in his username in the txtUserID textbox and his password in the txtPW textbox, the application will check for the correctness of the entries from the table and if they corresponds, it will automatically fill-in the txtFName and the txtLName field with the corresponding first name and last name of that UserID 2. How would I make sure that a particular UserID that has been entered is marked in the database so that the user cannot enter the same UserID & PW again on another system? I will really appreciate it if anybody can explain these answers to me so that I can know the flow and why each step or procedure is necessary. I am still a novice in MS Access Thanks a lot.
From: bhicks11 via AccessMonster.com on 30 Jun 2008 06:55 You can use the DLOOKUP function to auto populate the required fields. You can add an additional field to verify if the user is already open - Toggle it open/closed. Bonnie http://www.dataplus-svc.com Tayo wrote: >I have a table shown below > >UserID FName LName Pw >1A FN1 LN1 FN1LN1 >2A FN2 LN2 FN2LN2 >3A FN3 LN3 FN3LN3 >4A FN4 LN4 FN4LN4 > >I now have a form with 4 textboxes named > >txtUserID txtFName >txtPW txtLName > >My Questions: >1. How would I set the controls so that when a user typed in his username in >the txtUserID textbox and his password in the txtPW textbox, the application >will check for the correctness of the entries from the table and if they >corresponds, it will automatically fill-in the txtFName and the txtLName >field with the corresponding first name and last name of that UserID > >2. How would I make sure that a particular UserID that has been entered is >marked in the database so that the user cannot enter the same UserID & PW >again on another system? > >I will really appreciate it if anybody can explain these answers to me so >that I can know the flow and why each step or procedure is necessary. > >I am still a novice in MS Access >Thanks a lot. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200806/1
From: Tayo on 30 Jun 2008 09:03 Hi Bonnie, Thanks a lot for your answer but I need a solution that I can do by myself. It will help me in knowing MS Access better. Tayo "bhicks11 via AccessMonster.com" wrote: > You can use the DLOOKUP function to auto populate the required fields. You > can add an additional field to verify if the user is already open - Toggle it > open/closed. > > Bonnie > http://www.dataplus-svc.com > > Tayo wrote: > >I have a table shown below > > > >UserID FName LName Pw > >1A FN1 LN1 FN1LN1 > >2A FN2 LN2 FN2LN2 > >3A FN3 LN3 FN3LN3 > >4A FN4 LN4 FN4LN4 > > > >I now have a form with 4 textboxes named > > > >txtUserID txtFName > >txtPW txtLName > > > >My Questions: > >1. How would I set the controls so that when a user typed in his username in > >the txtUserID textbox and his password in the txtPW textbox, the application > >will check for the correctness of the entries from the table and if they > >corresponds, it will automatically fill-in the txtFName and the txtLName > >field with the corresponding first name and last name of that UserID > > > >2. How would I make sure that a particular UserID that has been entered is > >marked in the database so that the user cannot enter the same UserID & PW > >again on another system? > > > >I will really appreciate it if anybody can explain these answers to me so > >that I can know the flow and why each step or procedure is necessary. > > > >I am still a novice in MS Access > >Thanks a lot. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200806/1 > >
From: bhicks11 via AccessMonster.com on 30 Jun 2008 09:49 Tayo, that's a good idea. I thought I was suggesting a solution you can do yourself. Bonnie http://www.dataplus-svc.com Tayo wrote: >Hi Bonnie, > >Thanks a lot for your answer but I need a solution that I can do by myself. >It will help me in knowing MS Access better. > >Tayo > >> You can use the DLOOKUP function to auto populate the required fields. You >> can add an additional field to verify if the user is already open - Toggle it >[quoted text clipped - 32 lines] >> >I am still a novice in MS Access >> >Thanks a lot. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200806/1
From: Tayo on 30 Jun 2008 10:48
Please somebody should help me out here. "Tayo" wrote: > I have a table shown below > > UserID FName LName Pw > 1A FN1 LN1 FN1LN1 > 2A FN2 LN2 FN2LN2 > 3A FN3 LN3 FN3LN3 > 4A FN4 LN4 FN4LN4 > > I now have a form with 4 textboxes named > > txtUserID txtFName > txtPW txtLName > > > My Questions: > 1. How would I set the controls so that when a user typed in his username in > the txtUserID textbox and his password in the txtPW textbox, the application > will check for the correctness of the entries from the table and if they > corresponds, it will automatically fill-in the txtFName and the txtLName > field with the corresponding first name and last name of that UserID > > 2. How would I make sure that a particular UserID that has been entered is > marked in the database so that the user cannot enter the same UserID & PW > again on another system? > > I will really appreciate it if anybody can explain these answers to me so > that I can know the flow and why each step or procedure is necessary. > > I am still a novice in MS Access > Thanks a lot. > |