[AccessD] SOLVED - RE: A2K: Query with Criteria returns one blank record

Reuben Cummings reuben at gfconsultants.com
Fri May 2 14:12:23 CDT 2008


Don't know.  However, when I went to check I realized I was checking the
wrong recordset.

Rst1 gets a list to run the test against.
Rst2 is the actual test.

I opened Rst2, but ran EOF against Rst1.

Sorry for the bother.

Thanks for the help.

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Gustav Brock
> Sent: Friday, May 02, 2008 2:59 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] A2K: Query with Criteria returns one 
> blank record
> 
> 
> Hi Reuben
> 
> Couldn't you check for .RecordCount = 0?
> 
> /gustav
> 
> >>> reuben at gfconsultants.com 02-05-2008 20:49 >>>
> I have a query that has three criteria.  I am trying to find 
> a record that matches the address and city but not within the 
> same distribution... Street = 'X' and City = 'Y' and 
> ReportDate <> 80301
> 
> I know nothing matches this criteria.  The recordset returns 
> one blank record.  There's problem...I cannot check for EOF 
> because there is one record.  I also cannot check for a null 
> value because I keep getting a message about ... Error 3021 
> eof must be true or the record has been deleted.  Requested 
> operation requires a current record.
> 
> Any suggestions?
> 
> Reuben Cummings
> GFC, LLC
> 812.523.1017
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 






More information about the AccessD mailing list