[AccessD] Position in bound recordset

If you're trying to put it in a text box on a form just use "=(CurrentRecord)"
That will give you the record number in the current dataset including a dataset from a query.
Jim

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Rocky Smolin at Beach Access Software
Sent: Sun 10/5/2008 14:30
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Position in bound recordset



Yep.  You're right.  Just tested and it works fine.  Tks.


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 Bill Patten
Sent: Sunday, October 05, 2008 11:24 AM
To: Access Developers discussion and problem solving
Subject: Re: [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 <http://www.databaseadvisors.com/> 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> 



################################################################################

This email transmission contains information from NCI Information Systems, Inc. 
that may be considered privileged or confidential and is intended solely for the 
named recipient.  If you have received this message in error, please contact the 
sender immediately and be aware that the use, copying or dissemination of this 
information is prohibited.

################################################################################