Line Number (1 Viewer)

Gismo

Registered User.
Local time
Today, 08:22
Joined
Jun 12, 2017
Messages
1,298
Hi all,

i have a table there the user selects from a drop down which records should be populated
in the form you then have the option to manipulate and delete records
after allegations have been made, i need to allocate line numbers
what would be the preferred way to assign a line number
not sure if i want to go with a table with pre defined line numbers to populate the data file in question
 

June7

AWF VIP
Local time
Yesterday, 22:22
Joined
Mar 9, 2014
Messages
5,424
What is purpose of line number?

Saving this line number would require VBA looping records and populating field with an incrementing variable.

Simplest would be to not save this into record and to just use RunningSum property of textbox on report.

Also review http://allenbrowne.com/ranking.html
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 23:22
Joined
Oct 29, 2018
Messages
21,358
Hi. Does your table have an Autonumber (sequential number) as a Primary Key?
 

Gismo

Registered User.
Local time
Today, 08:22
Joined
Jun 12, 2017
Messages
1,298
What is purpose of line number?

Saving this line number would require VBA looping records and populating field with an incrementing variable.

Simplest would be to not save this into record and to just use RunningSum property of textbox on report.

Also review http://allenbrowne.com/ranking.html
The purpose is that the report requires a part number per line number as per management
pain in the backside actually
 

Gismo

Registered User.
Local time
Today, 08:22
Joined
Jun 12, 2017
Messages
1,298
Hi. Does your table have an Autonumber (sequential number) as a Primary Key?
I did not make the line number a autonumber as alterations needs to be made then to allocate a line number
if i had an auto number and an item has been deleted, how do i reassign the line numbers?
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 23:22
Joined
Oct 29, 2018
Messages
21,358
I did not make the line number a autonumber as alterations needs to be made then to allocate a line number
if i had an auto number and an item has been deleted, how do i reassign the line numbers?
Hi. I wasn't thinking of using an Autonumber field as a line number but merely a way to order the lines sequentially, so you can generate a sequential line number using Count() or DCount().
 

June7

AWF VIP
Local time
Yesterday, 22:22
Joined
Mar 9, 2014
Messages
5,424
RunningSum property of textbox in report can dynamically provide that line number.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:22
Joined
May 7, 2009
Messages
19,169
The purpose is that the report requires a part number per line number as per management
pain in the backside actually
add Unbound textbox to the Report,

the ControlSource is =1
and Running Sum = Over All
 

Users who are viewing this thread

Top Bottom