[AccessD] Record Count Problem

Charlotte Foust cfoust at infostatsystems.com
Wed Feb 18 10:13:52 CST 2009


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




More information about the AccessD mailing list