Method not found

[Guest]

In this code below the "rs.Edit" gives me the error: "Method or Data Error
not found" I don't understand, I've used it before?????

If txtNewPwd = txtNewPwd1 Then
If rs.RecordCount > 0 Then
rs.MoveFirst
rs.Edit
rs!Password = txtNewPwd
rs.UPDATE
MsgBox "Password changed succesfully."
Else


Thanks

 

[Stefan Hoffmann]

hi Dan,

In this code below the "rs.Edit" gives me the error: "Method or Data Error
not found" I don't understand, I've used it before?????

If txtNewPwd = txtNewPwd1 Then
If rs.RecordCount > 0 Then
rs.MoveFirst
rs.Edit
rs!Password = txtNewPwd
rs.UPDATE
MsgBox "Password changed succesfully."
Else

It is an ADODB.Recordset. You have used DAO.Recordsets before.

btw, use an explicit Dim for rs:

Dim rs As DAO.Recordset

or

Dim rs As ADODB.Recordset

and use Option Explicit.

mfG
--> stefan <--

 

[Guest]

Hi Stefan???

hi Dan,

It is an ADODB.Recordset. You have used DAO.Recordsets before.

btw, use an explicit Dim for rs:

Dim rs As DAO.Recordset

or

Dim rs As ADODB.Recordset

and use Option Explicit.

mfG
--> stefan <--

 

[Stefan Hoffmann]

hi Dan,

Hi Stefan???

hmm, yeah.)

Any questions left open?



mfG
--> stefan <--

 

[Guest]

Sorry, I did not see your code at the bottom of mine.
I'll give it a try..

 

[RoyVidar]

In this code below the "rs.Edit" gives me the error: "Method or Data

Error not found" I don't understand, I've used it before?????

If txtNewPwd = txtNewPwd1 Then
If rs.RecordCount > 0 Then
rs.MoveFirst
rs.Edit
rs!Password = txtNewPwd
rs.UPDATE
MsgBox "Password changed succesfully."
Else


Thanks

You are probably intending to use a DAO recordset. It'd be easier to
judge if you'd also included the declaration.

dim rs as dao.recordset

then
set rs = currentdb.openrecordset("select blah ....
or
set rs = me.recordsetclone ' for form recordsets ...