Solved

Slider Control MSaccess on update

Posted on 2009-07-01
7
799 Views
Last Modified: 2013-12-20
The on update does not seem to work on the activex slider control, any clues ?
0
Comment
Question by:hotathens
7 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 125 total points
Comment Utility
Correct. It doesn't.
Use the Change event instead.
The Change event doesn't show on the properties dialog but you can select it in the code module.
0
 
LVL 39

Expert Comment

by:thenelson
Comment Utility
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
peter57r, (thenelson)

<The Change event doesn't show on the properties dialog but you can select it in the code module.>

Any idea why this happens?

I notice that the same thing happens for certain events with the calendar control as well.
(they are available in the VBE, but not in the property box)

Jeff
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 44

Expert Comment

by:Leigh Purvis
Comment Utility
The events displayed on the property sheet are those of the container control.
The actual activeX control object sits inside this wherein its properties, methods and events are accessible.
Hence why the proper syntax for assignment of such control use is

Set objCtl = Me.ControName.Object

As for the event, well Change is alright, but I'd say the point of a control such as the slider is to make use of its dynamic movement (if you're going to include the potential burden of ActiveX controls, you might as well let them sing ;-)
Consequently, I'd say the Scroll event is more applicable than Change (which won't be raised as continuously, i.e. smoothly).
For example of the effect I mean - have a look at:
http://www.databasedevelopment.co.uk/examples/colourslide.zip
Cheers.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
Thanks
0
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
I don't think the default behaviour of the slider justifies the use of the term 'scroll'!
(Yes I know you can change it)(:-)
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now