new_guy_tom
Registered User.
- Local time
- Tomorrow, 03:45
- Joined
- May 14, 2010
- Messages
- 13
I need to lock the first row of data in a Form Datasheet View so that when the user scrolls down it always appears, it also has to stay there when columns are filtered.
The reason for this is that the column headings are a number from a crosstab query. The first row contains the actual proper column headins that relate to a product. This is the reason that they have to remain fixed while the user is scrolling down.
I have tried 2 subforms, one that shows only the headings (first row of data) and one that shows the the rest of the data however I need to freeze the first 5 columns. This means that when you move the scoll bar on the data the headings do not move with it.
I have thought about a continuos form however there will be around 100 columns and the form in form view will not go wide enough.
I usually like to solve these problems myself however I am not sure where to start, I am pretty sure it will have be fixed with code however I am stumped on this one.
The reason for this is that the column headings are a number from a crosstab query. The first row contains the actual proper column headins that relate to a product. This is the reason that they have to remain fixed while the user is scrolling down.
I have tried 2 subforms, one that shows only the headings (first row of data) and one that shows the the rest of the data however I need to freeze the first 5 columns. This means that when you move the scoll bar on the data the headings do not move with it.
I have thought about a continuos form however there will be around 100 columns and the form in form view will not go wide enough.
I usually like to solve these problems myself however I am not sure where to start, I am pretty sure it will have be fixed with code however I am stumped on this one.
