Numbering Rows (and saving the number on a table)

  • Thread starter Thread starter Vin Antonello
  • Start date Start date
V

Vin Antonello

I need to number the rows in a subform.

I used Stephen Lebans mdb but since i need to save the row number in a table
his code is not helping me. It show the row order, but if I try to copy the
value to another textbox (the one from the table) access freezes...

Currently im using the default value of the text = max([Order])+2, but
everytime something is deleted it gets messed up.

im using access 2003. Thanks for any help!
 
Trying to store row numbers in a table is bad practice as well as an
excercise in futility (as you are finding out). Why do you think you
need to do this?
 
The order in which i put the records is the ad in which the physical files
are organized in the folder.

The folder is the main form, the files the subform. And in need to know the
order of the files inside the folder.

Beetle said:
Trying to store row numbers in a table is bad practice as well as an
excercise in futility (as you are finding out). Why do you think you
need to do this?
--
_________

Sean Bailey


Vin Antonello said:
I need to number the rows in a subform.

I used Stephen Lebans mdb but since i need to save the row number in a table
his code is not helping me. It show the row order, but if I try to copy the
value to another textbox (the one from the table) access freezes...

Currently im using the default value of the text = max([Order])+2, but
everytime something is deleted it gets messed up.

im using access 2003. Thanks for any help!
Click to expand...
Click to expand...
 
Now that was poor english, sorry.

I need to know the order in which the files are organized inside the folder,
hence the row number.

Vin Antonello said:
The order in which i put the records is the ad in which the physical files
are organized in the folder.

The folder is the main form, the files the subform. And in need to know the
order of the files inside the folder.

Beetle said:
Trying to store row numbers in a table is bad practice as well as an
excercise in futility (as you are finding out). Why do you think you
need to do this?
--
_________

Sean Bailey


Vin Antonello said:
I need to number the rows in a subform.

I used Stephen Lebans mdb but since i need to save the row number in a table
his code is not helping me. It show the row order, but if I try to copy the
value to another textbox (the one from the table) access freezes...

Currently im using the default value of the text = max([Order])+2, but
everytime something is deleted it gets messed up.

im using access 2003. Thanks for any help!
Click to expand...
Click to expand...
Click to expand...
 
If there's a better way to know the order of files inside a folder, please
let me know!
Beetle said:
Trying to store row numbers in a table is bad practice as well as an
excercise in futility (as you are finding out). Why do you think you
need to do this?
--
_________

Sean Bailey


:

I need to number the rows in a subform.

I used Stephen Lebans mdb but since i need to save the row number in a table
his code is not helping me. It show the row order, but if I try to copy the
value to another textbox (the one from the table) access freezes...

Currently im using the default value of the text = max([Order])+2, but
everytime something is deleted it gets messed up.

im using access 2003. Thanks for any help!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top