RE: I am dead with ado rs.Find("Code Like 'E*')
- From: "Santhana Gopalan" <SanthanaGopalan@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 21 Apr 2005 06:15:04 -0700
Find method of the recordset will always go to EOF when a record with the
specified criteria is not found.
Check if you have Recordcount > 0 before executing the Find method.
Also, if you have used this Find method inside a loop, make sure you move
the record pointer to the first position using MoveFirst method. Because, the
record you're currently finding may be positioned before the record that was
found the last time the Find method was executed.
"Manish Sawjiani" wrote:
> Dear Experts,
>
> This works during design time without problem but after i execute compiled
> code it shows 3021 no records or current record is deleted :
> the code is as follows:
>
> rs.find "Code like 'E*' --- HERE IT BOMBS - RUNTIME ERROR
> if rs.eof or rs.bof then
> msgbox "Sorry there are no records"
> else
> fillfields
> end if
> i am on the verge of delivering to my client and there are 21 forms with
> this kind of find. i hope something comes out of this as always and i have
> never been let down by vb experts - THANKS A HEAP!
> Manish Sawjiani
>
>
> --
> Three Cheers to Technet for the Help!
.
- References:
- I am dead with ado rs.Find("Code Like 'E*')
- From: Manish Sawjiani
- I am dead with ado rs.Find("Code Like 'E*')
- Prev by Date: Re: "3021 No Current Record" on Insert?
- Next by Date: Re: multiple connections
- Previous by thread: I am dead with ado rs.Find("Code Like 'E*')
- Next by thread: Re: I am dead with ado rs.Find("Code Like 'E*')
- Index(es):
Relevant Pages
|
