Need some Guidance with finding records in a file?

[tomg53142]

Hi,

Im new to VBA and have a been doing some generic programming form creation init lately. I have been using Dlookup to get specific info for a field/record. I know there are better ways to do this using ADO ( I belive thats the lingo). From reading the forum a bit it looks like people use rst. ( I guess means resultset).

Anyweays can someone explain how i can read through a file and find multiple matches or test conditions if more than 1 rec exists for desired search? Go into setting any kind of connection string too please. DLookUp seems limited. Give me something to go on or where to go read up. Thanks I appreciate it.

 

[pcdaveh]

I usually use DAO. If you want you can use the openrecordset method and read the values into an array.

This site will give you a little more insight.

http://www.oreilly.com/catalog/progacdao/chapter/ch08.html

 

[tomg53142]

Thanks

When trying
Private Sub cmdListFields_Click()

Dim dbs As Database


I get "User-defined Type not defined"?

Whats this mean? Do I have to install somethgin extra in access to get DAO working?