Graphic illustration

[Dave]

Further to my recent post, I have a database used to track vials of
frozen cells. They are stored in small triangular trays. Each tray has
56 spots for vials. There are many trays. What I would like to do is
show a graphical representation of each tray that will show the cell
name in its proper position. I've got something that works now but to
do that I had to use 56 separate subforms. It works pretty good but it
does load kinda slow and I'm sure it's not as efficient as it could be.
Are there any other ways I could do this? I guess it would sort of be
like building an interactive calendar with 56 days instead of 30.
Thanks in advance for the great help I know is coming.

Dave B

 

[Douglas J. Steele]

While you may not be able to get the exact triangular shape, you could build
a form that has 56 text boxes, or 56 toggle buttons, or 56 labels or...well,
you get the idea.

If you use a naming convention for your controls (Text1, Text2,
Text3...Text56), you can address the specific control you want by
Me.Controls("Text" & intCounter)

Of course, this would have to be unbound, so it would be a bit more work.

 

[Dave]

I did initially try 56 text boxes, but the problem was that in each box
I wanted to show 3 lines of text to identify what was in that Spot. It
didn't work well and certainly no better or faster than 56 subforms.
I've set up the subforms to appear as text boxes however.

Dave B

 

[Dave]

I did initially try 56 text boxes, but the problem was that in each box
I wanted to show 3 lines of text to identify what was in that Spot. It
didn't work well and certainly no better or faster than 56 subforms.
I've set up the subforms to appear as text boxes however.

Dave B

 

[Dave]

I did initially try 56 text boxes, but the problem was that in each box

I wanted to show 3 lines of text to identify what was in that Spot. It
didn't work well and certainly no better or faster than 56 subforms.
I've set up the subforms to appear as text boxes however. I was hoping
there might be an activeX type control (or 56) that might do the job.
Anybody know of something?

Dave B

 

[David F Cox]

My first thought: I would do this with 56 option buttons and have a pop-up
window to show the contents when clicked upon.

to go the other way I would have a combo box with the descriptions in it,
and "flash" the option button true/false corresponding to that description.

 

[David F Cox]

or use control tip text on the option buttons (under other in the
properties), using ctr+enter to insert carriage control characters to make
them mutiline. This will pop up the required text as the mouse hovers over
the control.