Hello world
I have a database table called "people" with a field called "location". There are hundreds of records in that table.
Example values in "location" would be:
bed
breakfast
car
work
lunch
shower
etc (PS, I am not big brother!)
I would like a very visual way of showing where all the people are, in chronological order, something like this:
Bed...............Shower.................Work
John
.....................Andrew
....................Timmy
.....................Jane
...................................................Mr Keen
Initially, I tried using continuous forms, and programmatically setting the "left" property of a bound text box on a per record basis, through the detail paint event.
This does not work (not sure why not yet)
The only other way I can think to do this is to programmatically create a text box per record in a blank form, and adjust the left property of that control according to the "location" value (by using a "choose" structure probably).
However, I have read that over a form's lifetime, it is limited to 754 controls, so this doesn't seem very scalable to me. I could create 700 at the start, then unhide as required, but it seems to run out of steam quite quickly.
Does anyone have any ideas? I have thought about a flexgrid control, or embedded spreadsheet. I have a feeling I am missing something....it feels like conditional formatting, but is really conditional positioning.
Hope my example is clear - it is really about tracking products chronologically through a production line
I have a database table called "people" with a field called "location". There are hundreds of records in that table.
Example values in "location" would be:
bed
breakfast
car
work
lunch
shower
etc (PS, I am not big brother!)
I would like a very visual way of showing where all the people are, in chronological order, something like this:
Bed...............Shower.................Work
John
.....................Andrew
....................Timmy
.....................Jane
...................................................Mr Keen
Initially, I tried using continuous forms, and programmatically setting the "left" property of a bound text box on a per record basis, through the detail paint event.
This does not work (not sure why not yet)
The only other way I can think to do this is to programmatically create a text box per record in a blank form, and adjust the left property of that control according to the "location" value (by using a "choose" structure probably).
However, I have read that over a form's lifetime, it is limited to 754 controls, so this doesn't seem very scalable to me. I could create 700 at the start, then unhide as required, but it seems to run out of steam quite quickly.
Does anyone have any ideas? I have thought about a flexgrid control, or embedded spreadsheet. I have a feeling I am missing something....it feels like conditional formatting, but is really conditional positioning.
Hope my example is clear - it is really about tracking products chronologically through a production line