[AccessD] Record Count Problem

just a quick not but shouldn't the line

If rs.BOF = True And rs.EOF = True Then

of been

If rs.BOF = True Or rs.EOF = True Then

Paul Hartland
2009/2/18 Charlotte Foust <cfoust at infostatsystems.com>

> So you were getting BOF and EOF when recordcount > 0?  In that case you
> needed to move into the recordset with a movelast or movefirst.    And
> is this a DAO or ADO recordset?  They behave slightly differently.
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> at Beach Access Software
> Sent: Monday, February 16, 2009 12:58 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Record Count Problem
>
> I changed
>
> If rs.BOF = True And rs.EOF = True Then
>
> To
>
> If rs.RecordCount = 0 Then
>
> Crude but effective.
>
>
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
> www.bchacc.com
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
> Sent: Monday, February 16, 2009 12:18 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Record Count Problem
>
> If rs.BOF = True And rs.EOF = True and rs.recordcount = 0 Then
>        GoTo GoodBye
> Else
>        Goto WaveHelloToRocky
> End if
>
>
> Or save the PK, then requery, then find saved PK and position on it.
>
>
> Max
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> at Beach Access Software
> Sent: 16 February 2009 19:09
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Record Count Problem
>
> Dear List:
>
> In the following:
>
> Set rs = Me.RecordsetClone
> ' If no records then goodbye:
> MsgBox rs.RecordCount
> If rs.BOF = True And rs.EOF = True Then GoTo GoodBye:
>
> the record count shows as 1 but BOF and EOF are both true.
>
> The record was just added.  So the routine exits instead of doing what
> it's supposed to do.
>
> A Me.Requery solves the problem, but leaves the pointer at the start of
> the the recordset instead of the record the user was working on.
>
> I can's save a bookmark because the Requery triggers the activate event
> which calls this routine and destroys the bookmark.
>
> But why would the record count show 1 when the BOf and EOF are set to
> True?
>
> TIA
>
>
>
>
>
>
> Rocky Smolin
>
> Beach Access Software
>
> 858-259-4334
>
> www.e-z-mrp.com <http://www.e-z-mrp.com/>
>
> www.bchacc.com <http://www.bchacc.com/>
>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com