[AccessD] Record Count Problem

Max Wanadoo max.wanadoo at gmail.com
Mon Feb 16 15:08:04 CST 2009


I don't think that is crude at all Rocky.
I would use that above the over two tests at any time because if there is
anything in the rs then it will always show at least 1.  As you know, it
will not count all the records until you do a rs.movelast but it will show
at least 1 as soon as you test it.  

Whereas, well you have found what the whereas is already I think!

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 20:58
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