Display active row number...

[BLeslie88]

Searched left right and center. All the things we can do & no simple way to display the current row number?

A simple counter - autonumber feature of sorts...

I am running off a table on my form, and want to refrain from doing this in the query and recordsets...

Is there no simple way to display the row number???

1 - Tom - Green
2 - Brady - Blue
3 - Mike - Red
4 - Tyson - Purple

Just want the row # to display - must be stored on some attribute of the recordset somewhere on the form???

I am looking for a property that should in a simple world have this value?

Sorry for double post - first answer and searches over 24 hours produced nothing.

 

[MarkK]

A Recordset has an AbsolutePosition property that you might use. But the question I'll toss back is this: What value do you add to a list by showing row numbers?
The reason it's a difficult thing to do is that data in a table has no inherent order. You can assert an order but in almost all cases a list is only ever a subset of data in a table, so putting a 1. in front of the first item in a list is not meaningful in respect to the data. And I already know it's the first item in the list.
Sometimes it's meaningful to know how many items are in a list, but then it's more common to provide a summary that contains this information as a single item, and that's very easy to do.

 

[The_Doc_Man]

A simple fact: There is no row number in Access that means anything - unless you programmed it in when you defined the table.

Tables are generally unordered sets of records. If you autonumbered the records or otherwise programmed in the creation of a record number, it would be in a field that you can just display. If you did neither, there is no row number.

This is because in SQL, at least in theory, everything happens at once. If the interface to SQL serializes the records, that is something that is an artifact of the interface. But if you did a SELECT INTO or UPDATE query, the set theory underlying SQL says that the entire operation appears to occur to every affected record at the same time. That is, you are not supposed to be able to see a half-finished update-set. Implementation limits on the interface don't count.

 

[BLeslie88]

Thanks for replies, all valid points from a stand view of data.

If a user would like to know how many records they have to get through without counting though...

Or to set a goal for where they want to be... Such as .

Say
1
2
3
.
.
.
49
50

And at noon would like to know where there are towards there goal of records worked...

I am dealing with someone very visual... Seemed like a simple request. I wanted to avoid doing DOA record sets, I know I can do it manually.... Seems seems like a lot of work for a property that should exit regardless of the sort it is a simple calculation that wouldn't require much ram / time to provide.

 

[MarkK]

Assuming that your user's 'record working' alters its data in some identifiable way, then provide two lists. 1) Pending, and 2) Completed, each with a count of items. Simple, and even more visual than line numbers.

 

[BLeslie88]

That is done on reports she gets.

Or are you suggesting a counter for each action taken?

 

[gemma-the-husky]

Sorry for double post - first answer and searches over 24 hours produced nothing.

not really

both posts produced similar responses saying this was not easy, and wondering why you wanted to do it

-------
Actually, the record selector at the bottom shows the ordinal positon of the record you are currently on.
Just turn on the record selectors - is that sufficient for what you are trying to do?

 

[BLeslie88]

You were right for turning on the record selector's...

Knew should be easy - where the row number appears isn't important.

Thanks.

"Duh"