ok,
Update tblEmployees
Set strEmpPassword = Me.NewPass
Where strEmpPassword = Me.OldPass.Valu e
that is what i entered in my VB.
strEmpPassword is the field in the employees table
OldPass is the name of the textbox in the form where the old password is entered,
likewise for the new password
when i run the code, it comes up with "Compile error, sub...
amraam35
Last Activity: Jul 31 '06, 02:30 PM
Joined: Jul 28 '06
Location:
-
Mahesh_Bote,
Thank-you so much for your help, that was exactly what i was looking for.Leave a comment:
-
Hi
Thank you very much for the replys. I dont think i made my question very clear. I have a table with three fields. User ID, User Name, and Password.
I have a form called "ChangePassword ", where you can change the old password into a new one. You enter the User Name and password, and a then a new password that you want to change the old one into. If the user name and old password match, then the program...Leave a comment:
-
replace table value
heres the situation. I have a table in access with some fields, 1 2 and 3. I have a form that i want you to enter text in a box, and for that text to replace a certain value in field 1.
Is there a script that can do this, or a command? I am so stuck on this.
I can call up the value that i want, and enter the new value, i just cant get them to swap.
thanks alot
Bill -
to make it a little more clear, im looking for some type of script that will tell it to replace (strEmpPassword ) (which is an entry in a table record) - the one for the username which was entered above - with (ConfirmPass) - the new password which was entered on the form and as of yet has not been stored in a table.
I have tried the replace() function, that just changed letters in a script.
Thanks againLeave a comment:
-
Replacing table value with different value in VB
Here is the problem. I have made a log in script that prompts you to log in with a username and password as the "splash screen" It is an unbounded forum that checks that the username and password are in the employee table, and that they are together, and if it is, it lets you log on. That works just fine. Then i tried to make a form that you can change your password if you please. It has 4 entrys, the user name, password, and then2...
No activity results to display
Leave a comment: