hey.
im my code which is as follows...
i get this error
Run-time Error 3061
Too Few Parameters
!!!!
when i tyoe doa.recordset or doa.database it says user defined type not defined. yet i can use dim rst as recordset fine. i have the Microsoft DOA 3.6 Object Libary thing sellected. is there anything else i need selected in the refrences bit. as far as i can see the sql stament is correct.
also it doesn't like rst.edit
is there anythign you can think of? i think i need more refrences things but i don't know which ones.
p.s im using access 2002 and access 2000 file format
im my code which is as follows...
Code:
Dim mySQL As String
Dim Rst As Recordset
Dim db As Database
Set db = CurrentDb()
mySQL = "SELECT * FROM passwords WHERE passwords.ID = " & ID & ";"
Set Rst = db.OpenRecordset(mySQL)
i get this error
Run-time Error 3061
Too Few Parameters
!!!!
when i tyoe doa.recordset or doa.database it says user defined type not defined. yet i can use dim rst as recordset fine. i have the Microsoft DOA 3.6 Object Libary thing sellected. is there anything else i need selected in the refrences bit. as far as i can see the sql stament is correct.
also it doesn't like rst.edit
is there anythign you can think of? i think i need more refrences things but i don't know which ones.
p.s im using access 2002 and access 2000 file format