[AccessD] Position in bound recordset

Hey Rocky,

Looks pretty slick to me, though I think you can do the same thing with
me.lblRecordXofY.Caption = "Patient " & me.recordset.AbsolutePostion + 1 & 
"of "  & me.recordset.RecordCount

and illuminate setting and destroying another recordset.

Bill
----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Sunday, October 05, 2008 9:59 AM
Subject: Re: [AccessD] Position in bound recordset


Never mind.  Figured it out.


    Dim rs as Recordset
    Set rs = Me.Recordset
    Me.lblRecordXofY.Caption = "Patient " & rs.AbsolutePosition + 1 & " of "
& rs.RecordCount

Unless there's a slicker way.


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 Rocky Smolin at
Beach Access Software
Sent: Sunday, October 05, 2008 9:54 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Position in bound recordset

Dear List

Is there a way to get the record number of the current record on a bound
form - that is, not the autonumber id but the position of the record - like
record 45 of 12,000?

MTIA



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