Update a table through a form

[haneen97]

Hi,

I am trying to update the user table while changing a password. The code is goes like this:

strSql = "UPDATE Users SET Users.[Password] = 'UCase(txtPwNew)' ," _
& " Users.Password_Chg_Date = date " _
& " WHERE (((Users.Password) = 'UCase (txtPwNew)') " _
& " AND ((Users.User_name) = 'txtUserName'));"

Set db = CurrentDb
db.Execute strSql

But I am getting an error that says

"Too few parameters. expected 1."

Please help

Also, does the date function returns the current date?

Thanks

Mo

 

[TYLRDRDN]

Date will not return the current date in SQL you are going to need to use sysdate and most likely make sure that you format it accordingly.