If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: Searching a db

Try %.

Originally posted by dotolee
I have a MS Access table called File
It has fields called FileNum, Description and Comments. I want to enable the end user to type in one or more words / numbers to search for a particular file.

YIPEE!
Thanks a bunch. That worked really well. One other question.
I have two tables:
one called Users and one called Resources. All users in the Users table are represented in the Resources table.
I'm trying to select all users from Users and then select additional information for each of them in the Resources table.
How do I add to my recordset?
Code:

When i do the above, I get an error that says "Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype." When I uncomment the line about the lock type, I get the error "Operation is not allowed when the object is open."

Why not have one select statement that joins users to resources? You benefit because you only make one connect and one pass through the data, getting the information you want in one result set. Also, your errors may go away.

Originally posted by dotolee
YIPEE!
Thanks a bunch. That worked really well. One other question.
I have two tables:
one called Users and one called Resources. All users in the Users table are represented in the Resources table.
I'm trying to select all users from Users and then select additional information for each of them in the Resources table.
How do I add to my recordset?
Code:

When i do the above, I get an error that says "Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype." When I uncomment the line about the lock type, I get the error "Operation is not allowed when the object is open."