Access 2.0 Help mentioned 'record numbers' frequently but nowhere did it ever say how to determine a given record's record number

Anyone remember how to determine a particular
record's record number (Access 2.0 table question)?

re: Access 2.0 Help mentioned 'record numbers' frequently but nowhere did it ever say how to determine a given record's record number

You could get the number from the AbsolutePosition property of the
Recordset.

Details:
http://allenbrowne.com/casu-10.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CRCI@NorthState.net> wrote in message
news:qkoo90t2nta3v281a2kn7bkp2ru8jjdii5@4ax.com...[color=blue]
> Anyone remember how to determine a particular
> record's record number (Access 2.0 table question)?[/color]

re: Access 2.0 Help mentioned 'record numbers' frequently but nowhere did it ever say how to determine a given record's record number

I checked. Unfortunately, I don't think it was available
in Access 2.0 - any other recollections? Even guesses
(SWAG's) will be appreciated.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



On Sat, 8 May 2004 23:20:33 +0800, "Allen Browne"
<AllenBrowne@SeeSig.Invalid> wrote:
[color=blue]
>You could get the number from the AbsolutePosition property of the
>Recordset.
>
>Details:
> http://allenbrowne.com/casu-10.html[/color]

re: Access 2.0 Help mentioned 'record numbers' frequently but nowhere did it ever say how to determine a given record's record number

Don't have A2 installed on this machine, but if you open the form in design
view, open the Properties box, and look on the Data tab of the dialog, you
should see the property. (Make sure you're looking at the properties of the
Form, not of a text box.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CRCI@NorthState.net> wrote in message
news:1v0q90ht85obnh58p5ibsdhdm37huekio0@4ax.com...[color=blue]
> I checked. Unfortunately, I don't think it was available
> in Access 2.0 - any other recollections? Even guesses
> (SWAG's) will be appreciated.[/color]

re: Access 2.0 Help mentioned 'record numbers' frequently but nowhere did it ever say how to determine a given record's record number

MLH <CRCI@NorthState.net> wrote in
news:qkoo90t2nta3v281a2kn7bkp2ru8jjdii5@4ax.com:
[color=blue]
> Anyone remember how to determine a particular
> record's record number (Access 2.0 table question)?[/color]

In Access, records don't have record numbers.

Is that you, Don?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

re: Access 2.0 Help mentioned 'record numbers' frequently but nowhere did it ever say how to determine a given record's record number

Not quite, I'm afraid. There's 4 properties there, but
AbsolutePosition isn't one of them.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xx


On Sun, 9 May 2004 00:19:20 +0800, "Allen Browne"
<AllenBrowne@SeeSig.Invalid> wrote:
[color=blue]
>Don't have A2 installed on this machine, but if you open the form in design
>view, open the Properties box, and look on the Data tab of the dialog, you
>should see the property. (Make sure you're looking at the properties of the
>Form, not of a text box.)[/color]