Recordset Help (1 Viewer)

[A real begineer]

For some reason when I look up recordsets in my help file, my help file crashes and says I need to repair it. When I do and repeat the question the sequence repeats.

Unfortunately it crashes on any question on recordsets, so I am forced to ask here what is probably covered in help.

I was wondering whether the DAO.Recordset Bookmark could be sought using multiple critirea. I know how to find a recordset on a single critirea, however, my attempts at multiple criteria have failed.

For example lets say wewant to find a recordset for a specific date and time, how do we specify that in the DAO.Recordset model.

 

[charityg]

The way I would do it is create my recordset as a select statement where date=the desired date, then do a find on the time.

something like

rst=db.openrecordset("select * from mytable where mydate=finddate;")
rst.findfirst "[time]=findtime"