Synchronize scrollbars on two sub-forms

[Sean]

I did not get too much help with me original question so here is
another.

I am trying to create a ColorPicker form for a Microsoft Access 2000
application.

I will not use the CommonControlsColorDialog as the set of colors are
inconsistent with other Microsoft Applications, so I have a color table
with information for 16 different colors (Name, RGBNumber, ColorIndex,
Red, Blue, Green, etc.).

My first problem was that in addition to this info I would like to
display a box with a sample of the respective color. On my form any
attempt to set the color (based say on the RGBNumber) fails as changing
the background color of a textbox on a continuous changes that textbox
for ALL the records (although it would work for a single form,
unfortunately this is not one of those).
I solved this by doing the following: -
- Form (A) contains the fields from my color table
- Form (B) contains 16 text boxes whose background color it set based
on my color table
- Place these two subforms side-by-side, sized to display ALL the
records on a single form

This worked fine!

UNTIL. The number of colors I needed to use doubled. It was not a
problem to add another 16 text boxes but now that my subform (A) needs
to have a vertical scroll bar, how do I synchronize the subforms so that
the correct color box is in line with the correct color number.

I think I need to know a couple of things: -
i) How can I GET the "first visible record" in subform(A)
ii) How can I SET the "first visible record" in subform(B)

My thinking is that I can achieve ii) using the .SetFocus method, but
how do I find the value for i).
Clear as mud!
----
Sean
"Just press the off switch, and go to sleep!"

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[David Schofield]

On 04 Oct 2004 13:49:38 GMT, Sean <se*********@TimeaIntLtd.hu> wrote:

...
I will not use the CommonControlsColorDialog as the set of colors are
inconsistent with other Microsoft Applications, so I have a color table
with information for 16 different colors (Name, RGBNumber, ColorIndex,
Red, Blue, Green, etc.).

Come on, admit it, you just want to program something different!
My first problem was that in addition to this info I would like to
display a box with a sample of the respective color. On my form any
attempt to set the color (based say on the RGBNumber) fails as changing
the background color of a textbox on a continuous changes that textbox
for ALL the records (although it would work for a single form,
unfortunately this is not one of those).

Well why not display in a format of two rows rather than two columns,
then there is no problem. You could also investigate how to show text
vertically to save space.

Another way would be to display on a single form using a pseudo-array
of controls. You can still drive it from a table and use a variable
number of visible controls if you want to, provided its not too many.
Lots of interesting coding here.

regards
David

[Sean]

Thanks David, however in answer to your points

a) your are probably right
b) you must be joking (save space ???)
c) done that, don't like the look

At the moment I have left the subformy at a fixed size, and added an
option group to select a "page" of colours. It's not the ideal solution,
but what can you do?
----
Sean
"Just press the off switch, and go to sleep!"

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!