Like in Recordset

[TimTDP]

In Access 2000 I have a records that contain the following strings:

### RECEIVING FILE PROCESS TOOK 295 MILLISECOND(S) ###
### RECEIVING FILE PROCESS TOOK 50 MILLISECOND(S) ###
### RECEIVING FILE PROCESS TOOK 600 MILLISECOND(S) ###

I want to find the first instance of a record contianing this string in a recordset, using :

.FindFirst ("LineInfo LIKE '### RECEIVING FILE PROCESS TOOK * MILLISECOND(S) ###'")

note the * to replace the value!

But the syntax is wrong!

What is the correct syntax?

 

[boblarson]

Is there other things in there besides ### RECEIVING FILE PROCESS TOOK ...etc.? So, could you just look for

("LineInfo LIKE '*" & YourNumber & " MILLISECOND*")