Skip "No Records Found" Alert

[John Chamberlain]

I have a script that calls a subscript, the subscript calls the next subscript, etc. There are 7 searches, with corresponding print commands when records are found. The scripts are searching 7 date fields to see if they contain any dates within a range determined by Status (CurrentDate) - the date in the field (a positive result selects the record for printing). Naturally, some of these searches do not yield any results.

What I want is a way to have the "No Records Found" alert turned off, so that I don't have to hit the "Cancel" and "Continue" buttons for those searches that do not return any records. Is this possible?

TIA

John Chamberlain

[MoonShadow]

John, add a Set Error Capture [ On ] at the start of each of your subscripts. This will stop FM's message. Then handle it yourself.

[T-Square]

John--

To extend MoonShadow's post, you would check for no records found using

If[Get(LastError) = 401 /* this is the 'No records found' error */]

#do some stuff

Else

#do some other stuff

End If

[John Chamberlain]

Worksw perfecfly!!

Thanks, guys