Hello
I want a textbox which is placed in a column in the "table looking form"(like a list). I want the textbox to show the row number of the list.
It shall look something like this:
(textbox)
1. The title1 more text1
2. The title2 more text2
3.
4.... and so on.
I am able to get the ammount of lines by entering this to the data of the textbox: =Antal(*) & "."
Thank you.:)
ajetrumpet
03-13-2009, 06:58 AM
I think the easiest way would be to add a column to your table if you don't already have one, as a primary key indicator, that runs in order, from 1 to whatever. include this field on your form, but make it invisble. Then, make a query with this as a new column:dcount("PK field", "table", "PK field <= " & [PK field of the query])
as [Row Number]then base your form off the query
Here is an example of how to use a unique field in the table to get the row numbers in a query, then base the continuous form off of that query...
I think the easiest way would be to add a column to your table if you don't already have one, as a primary key indicator, that runs in order, from 1 to whatever. include this field on your form, but make it invisble. Then, make a query with this as a new column:dcount("PK field", "table", "PK field <= " & [PK field of the query])
as [Row Number]then base your form off the query
Here is an example of how to use a unique field in the table to get the row numbers in a query, then base the continuous form off of that query...
Thank you so much for the help and I appreciate the time you've spend on this.
It works great, a really smart solution. :)
ajetrumpet
03-13-2009, 04:15 PM
No problem. Good luck, and I like your name =)
Mike375
03-13-2009, 04:39 PM
That's a real neat solution.