Solved

Slider Control MSaccess on update

Posted on 2009-07-01
7
800 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
ID: 24752598
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
ID: 24752617
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24752962
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 24760514
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
ID: 24761929
Thanks
0
 
LVL 77

Expert Comment

by:peter57r
ID: 24762967
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

910 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

16 Experts available now in Live!

Get 1:1 Help Now