1

Topic: Record search

Hello!
There is a code fragment:
......
Set rsK = CurrentDb. OpenRecordset ("select * FROM kg")
rsK.MoveFirst
rsK.FindFirst "Number =" and N and "and Date =" and Format (Me., "mm\/dd\/yy")
MsgBox rsK.NoMatch
In   I put any date, but all time turns out "True" though in the table "kg" of record with such date is not present.
Help to write please correctly?

2

Re: Record search

Esteem in help on DAO as are formatted and than date literals are framed...

3

Re: Record search

Excuse please! Record on the contrary is, but all time turns out rsK.NoMath=True

4

Re: Record search

Format (Me., " \# mm\/dd\/yy \# ")

5

Re: Record search

Anatoly (Kiev);
Thanks! Works.

6

Re: Record search

nauf wrote:

Excuse please! Record on the contrary is, but all time turns out rsK.NoMath=True

Well and if to esteem!
http://www.sql.ru/faq/faq_topic.aspx?fid=157