Slider Control & Audit Stamp

[Becca]

Hullo

I am wanting to use a slider control (ActiveX) to update the status of an entry. The three statuses I have:
Unauthorised (the default)
Authorised
Finalised
I would like to be able to use the control for the user to slide between Unauthorised to Authorised and Finalised. I would aslo like it to (on update of slider position) to update a table with the userID and Now().
Finally I would also like it to prompt for a value entry for the Finalisation Number when the user slides to Finalised.
I know, I know, I don't have simple needs, but I cannot find any info on Slider control use anywhere. If anyone can either give me some pointers on where to find info.. or some pointers on how to go about what I would like to do, please please please let me know.

Thanks

 

[Rich]

Why not use an option group, make life easy

 

[OJ]

Becca
your probably better off using the option buttons and then adding them to a frame. This way you can only select one option at a Time.

If you find this helpfull you owe me one (Date)

 

[Becca]

Thanks Guys - Looks like the option group is the way to go.

OJ: Your place(UK?) or mine (Oz)......

 

[boblarson]

To go back to your slider control problem for just a second. You can use it for what you are trying to do, however the option group is the easier of the two.

However, to use the slider control, what you need to do is to set the possible values and for most ActiveX controls, you can find a CUSTOM property which will let you set things like that. To find it, either look on the properties list and click on the builder ... that is next to it, or try right-clicking on the control itself and sometimes it pops up by double-clicking the control.

So, once you find the Min and Max, set it to the values you will want. Then, if you may be able to bind it to the field you want to update, but a lot of times you may need to put an invisible text box on your form somewhere and then set the OnChange event of the slider to update that bound text box to the value of the slider. That way, it will change the field that you want.

I've done a lot of experimenting with ActiveX controls but I'm finding that it is a lot less hassle to work without them if possible. Especially, if you have to use the same database on different computers. You'll run into Missing Reference problems ALOT if using ActiveX controls (at least I have had that experience). I have a lot less problems with the databases with which I haven't used the extra ActiveX controls.

BL
hth

 

[Rich]

You can create a slider control without the dreaded ActiveX.

 

[Becca]

Rich & Others
Thanks for the suggestions.
The slider control would be my first option, as it would then operate in a similar way to other programs the users operate. However, the org I work for has scrimped on licensing, so the ActiveX won't work on any pcs in the group except my own. I guess one way around it is to make it run-time, but that sounds a little too technical for my very amateur status.
Building my own slider seems a nice idea, as I have seen it suggested elsewhere in the forums, anyone have any pointers on where I could start?

 

[Becca]

The other Q I have in this scenario is how to have controls enabled=false while the form is in focus. Currently I have to go out of the form and back into it in order for the fields to be un-enabled where "Finalised"(3) has been selected for the status. It won't occur while the form and controls are in focus. At the moment I have the following statement in OnCurrent and AfterUpdate of the form:

If Me.Status = 3 Then
Me.TransactionType.Enabled = False
Me.Category.Enabled = False
Me.Variation_Title.Enabled = False
Me.Source.Enabled = False
Me.Additional_Comments.Enabled = False
Else
Me.TransactionType.Enabled = True
Me.Category.Enabled = True
Me.Variation_Title.Enabled = True
Me.Source.Enabled = True
Me.Additional_Comments.Enabled = True
End If
Me.Form.Refresh

I don't know what else I am missing here, or if its in the wrong event field. Please let me know if you are aware of where I am going wrong.

Thanks to all

 

[Rich]

In the FormCurrent event
If Me.Status = 3 Then
Me.TransactionType.Enabled = False
Me.Category.Enabled = False
Me.Variation_Title.Enabled = False
Me.Source.Enabled = False
Me.Additional_Comments.Enabled = False
Else
Me.TransactionType.Enabled = True
Me.Category.Enabled = True
Me.Variation_Title.Enabled = True
Me.Source.Enabled = True
Me.Additional_Comments.Enabled = True
End If
In the AfterUpdate event of Status
Form_Current

 

[SunWuKung]

Rich,
you said

You can create a slider control without the dreaded ActiveX.

how could you do that?

SWK