Find method from two criteria

[miho1]

I want to use method Find from two criteria

DataEnvironment1.rsCommand1.Find " Name = '" & Text1. Text & "' And Size > 0 "

But gives Error.

Whether it is possible to make it and what syntax?

I shall be very grateful.

Miho

 

[Golom]

Your FIND clause looks OK except that you have a space between "Text1." and "Text" ... could that be the problem? You might also put brackets around the field names.

   DataEnvironment1.rsCommand1.Find "[Name]='" & Text1.Text & "' And [Size]>0 "

 

[miho1]

And so does not work.
If to write

DataEnvironment1.rsCommand1. Find " Name = ' " and Text1. Text and "'"

Everything is all right, but when will add

And Size > 0

Gives Error

 

[Golom]

What's the Error?

 

[miho1]

Run-time error '3001'

Arguments are of the wrong type,are out of acceptable range,or are in conflict with one another

 

[Golom]

As you are specifying them, "Name" must be a Text field and "Size" must be numeric ... are they? Since the problem doesn't occur until you add "Size", I'm assuming that it is the field that has the problem.

 

[miho1]

When I write

DataEnvironment1.rsCommand1. Find " Size > 0 "

There is no problem

 

[miho1]

There is no problem when apply two kriteria separately.

 

[CCLINT]

You cannot use multiple fields with the Find method.
You will need to use the Filter method, best when used with a recordset clone and then setting the bookmark of the original recordset to the bookmark of the cloned recordset.

 

[miho1]

And I have reached up to this conclusion and have made as you spoke.

It is very grateful.

Miho