Please Help me about UPDATE query

huyremy · September 23rd, 2004, 01:44 PM

This is my code

Code:

Dim db As Database

Private Sub Command1_Click()
newpass = Text1.Text
db.Execute "UPDATE Users SET Password =" & newpass
MsgBox " Password Has Been Change "
End Sub

Private Sub Form_Load()
Set db = OpenDatabase("msmo.mdb")
End Sub

And this is my Problem :
I use my form to change the Password Feild in my database But IF my string is number . That code run very well but If my String is Text or Text and Number I get this error

Quote:

quote:Run time Error '3061':

Quote:

Too few Paramenters . Expected 1

I don't know how to fix it . Anybody please help me ?
Thanks very much

bmains · September 23rd, 2004, 02:31 PM

Hey,

For your query, you need to put string params in single quotes, and numbers with no quotes:

update Users set Password = 'Password', NumberField = 1

Also, you need to have a where clause, or all fields will be updated with the password:

db.Execute "update Users set Password='" & newpass & " where userid = '" & userid & "'"

Brian

huyremy · September 24th, 2004, 06:55 AM

Hello Sir !
My database has only one Field is Password (Field(0))
So I try to use that query like
db.Execute "UPDATE Users SET Password ='newpass'"
But my code can't get value from textbox in my form which is Text1.Text
Can you help me again ?
Thanks Sir very much.

gbianchi · September 24th, 2004, 12:15 PM

hi there..

I dont understand your error...

you said that this:

Code:

db.execute "UPDATE Users SET Password = '" & text1.text & "'"

dont work???

HTH

Gonzalo

huyremy · September 24th, 2004, 02:17 PM

I said that this code can not be run

Quote:

quote:db.Execute "UPDATE Users SET Password ='newpass'"

Not Your code can't be run .
But Thanks sir gbianchi and sir bmains !
My Code now has been run very well .
Thanks again .
Wish that you can help me more in the future .

bmains · September 27th, 2004, 09:24 AM

Hey,

Why only one field in the database? How do you know who's password is what? Or is this an application password.

Are you still getting the same error? I don't see anything wrong with that statement. By the way, what is the database (db) object?

Brian

huyremy · September 27th, 2004, 01:20 PM

My code has been run now . Only one field because....my application need only one password to run it :)
Thanks sir bmains very much .

Anantsharma · September 28th, 2004, 02:29 AM

Hi,

Thats good to know that ur prob is solved.

I suggest u to use ADO (I feel u r using DAO). Else are the things related to some good programming techniques u should follw while coding. ADO RecordSets and connection Objects are very flexible.

Best of luck.

B. Anant

huyremy · September 29th, 2004, 03:45 AM

yeah . You a right . Thank Sir About your suggest .