Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Wed Feb 18 10:29:41 CST 2009
The recordset is the bound recordset - Set rs = Me.RecordsetClone. And moving to the last record if there's no records generates an error. Which I could trap. But, as I explained, I find it esthetically objectionable to deliberately generate an error, but that has no place in programming discipline anyway. But I think I finessed the problem with .RecordCount > 0. I don't care how many records are there, only that there's at least 1. 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 Charlotte Foust Sent: Wednesday, February 18, 2009 8:14 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Record Count Problem 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