Urgent plzz help

[urs]

Set db = DAO.Workspaces(0).OpenDatabase("rem.mdb", False, False, ";pwd=urs")
Set dt = db.OpenRecordset("Name")
this is how i am opening a database
i dont have data control or ado on my form
when i try to find with the coding
dt.FindFirst ("Jhon")
i get an error message that "not supported by this object"
and when i use this coding
dt.FindFirst = ("Jhon") or dt.FindNext = "Jhon"
i get an error message argument not optional
plzz help me

[Cakkie]

You must specify what you re looking for

dt.FindFirst "Firstname='Jhon'"





Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook

[urs]

Sorry friend it is giving me same error
"Object not supported for this type of object"

[Iouri]

You can use SQL
sSQL = "select * from Table where name = 'John'"
open recordset dt using this SQL

and if dt.RecordCount = 0 then ' record is not found

otherwise

sName = dt!Name

Iouri Boutchkine
[email protected]

[phunkydude]

Hi, some recordset types do not support the FindXXXX methods.
Try specifying the Recordset to be a Snapshot or Dynaset.
'Replace the dbOpenSnapshot const with dbOpenDynaset as you require
set rsData = db.OpenRecordset(RecordsetSQL , dbOpenSnapshot)


the syntax shown in the previous posting for the find methods is correct.

[bhanuprakash]

write the following code
set rs = db.openrecordset("select * from xyz",dbopendynaset)

then the next find sytax what you have specified is ok this should work.