using slider control in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Horst Graben - 19 Jun 2006 14:58 GMT

I have a question which is so embarassingly sub-moronic, yet, seemingly so
very impossible to find simple documentation for the simpleton such as myself
....

I have a simple table, lets say with 2 fields, a index and an integer
(my_slide_value).

I want a form with a slider control and I want the slider control to update
the interger variable in the table. That's all.

My Access 2003 has a couple of sliders, for example the MS Slider Control,
version 6.0 (MSComctlLib.Slider.2) foir example.

Don't I simply need to use the Expression Builder (Event tab of properties
menu) and define an event such as "On lost focus" ? But an expression like:
=[my_slide_value] does not update the table.

Can someone please contribute to my enlightenment?

Reply to this Message

Douglas J. Steele - 19 Jun 2006 23:20 GMT

Just because controls show up in the ActiveX Controls list through Access
doesn't actually mean that they can be used in Access. That lists all
ActiveX control, but Access isn't capable of working with all ActiveX
controls. See http://support.microsoft.com/?kbid=202104 for what limitations
there are.

That having been said, I don't understand how you're trying to use
=[my_slide_value]. Assuming you named the ActiveX control you added on to
the form "my_slide_value", try referring to the control as Me.my_slide_value

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I have a question which is so embarassingly sub-moronic, yet, seemingly so
> very impossible to find simple documentation for the simpleton such as
[quoted text clipped - 17 lines]
>
> Can someone please contribute to my enlightenment?

Reply to this Message

Horst Graben - 20 Jun 2006 10:57 GMT

Thank you Doug.

I am not at all familliar with Visual Basic, or indeed operating in a
programming environment like Access.

I am trying to create a, conceptually at least, simple application where
users "enter data" into a form using a slider control.

... On a scale of 1 to 10, how much do you like Strawberry ice cream on
Turkey? ...

The user "slides the slider" and this value gets written to the table.

I don't understand why the slider cannot be as easy to use as a text box?

"That having been said, I don't understand how you're trying to use
=[my_slide_value]. Assuming you named the ActiveX control you added on to
the form "my_slide_value", try referring to the control as Me.my_slide_value"

ActiveX Component Categories Supported in Access 2000
• Simple Databinding, which is the ability to bind one property of a control
to a field in a table.
• The Controls component category.

Reply to this Message

diego vinicius - 14 Sep 2006 01:51 GMT

oi jenten eu qeria noticias em portuques ta

Reply to this Message