Prev: Round a number/ Access 2007
Next: Form Dirty question when used with unbound textbox and VB Code.
From: swas on 9 Feb 2010 09:57

Jack,

Thanks for your thoughts.

The problem as I see it is though, that it is only the current record that
has the position set. All other records sliders will jump to the same
position as an unbound control.

I'm only trying to get the visual effect of multiple slider positions.

Classes and are new for me, so I am trying to explore my logic before trying
to actually trial.

I think...


swas
From: Jack Leach dymondjack at hot mail dot on 9 Feb 2010 10:24
I see... that's why you want it bound.

Well, good luck! Far beyond my scope. I haven't the slightest idea how to
go about this one.

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"swas" wrote:

>
> Jack,
>
> Thanks for your thoughts.
>
> The problem as I see it is though, that it is only the current record that
> has the position set. All other records sliders will jump to the same
> position as an unbound control.
>
> I'm only trying to get the visual effect of multiple slider positions.
>
> Classes and are new for me, so I am trying to explore my logic before trying
> to actually trial.
>
> I think...
>
>
> swas
From: Marshall Barton on 9 Feb 2010 11:03
swas wrote:
>The problem as I see it is though, that it is only the current record that
>has the position set. All other records sliders will jump to the same
>position as an unbound control.
>
>I'm only trying to get the visual effect of multiple slider positions.
>
>Classes and are new for me, so I am trying to explore my logic before trying
>to actually trial.


That is the problem doing this kind of thing. The slider,
however you do it, is just a single control so there is only
one set of properties (value, color, width, etc) that you
can manipulate. To get it to display differently on
different rows in a continuous form, it must be bound to one
or more record source fields.

The way I have done something like that (ghantt chart) is to
use a text box with an expression like:
=String(positionfield, "I")
That will display the letter I the number of times in each
record's position field.

To make that look more like a bar, you need to use a font
that displays a solid block instead of a letter. There is a
public domain font designed to do just that job at:
http://www.mvps.org/access/forms/frm0055.htm

I have not tried to make a mouse dragable slider out of that
but it sounds like you have so it should work.

--
Marsh
MVP [MS Access]
From: Banana on 9 Feb 2010 11:04
swas wrote:
> Jack,
>
> Thanks for your thoughts.
>
> The problem as I see it is though, that it is only the current record that
> has the position set. All other records sliders will jump to the same
> position as an unbound control.
>
> I'm only trying to get the visual effect of multiple slider positions.
>
> Classes and are new for me, so I am trying to explore my logic before trying
> to actually trial.
>
> I think...
>
>
> swas

To be honest, I'm not clear why we want to have a custom slider when we
could just use scrollbar builtin to the subforms?

Assuming you really want to go down this path, (note I've never worked
with slider) I would imagine you need to use the AbsolutePosition
property to tell you where you are relative to the first row/last row
and you can set the AbsolutePosition to "move" to that row when the
scroll moves.
From: swas on 9 Feb 2010 16:55
Thanks for the responses.

I will have to look more closely at what could be involved here, and make a
value decision of time v result - or consider alternative solutions to
providing a visual position effect.

Thanks for the help and thoughts.


swas
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Round a number/ Access 2007
Next: Form Dirty question when used with unbound textbox and VB Code.