ActiveX Slider no longer working on Access 2013

[jrajul]

I have a form that uses the Microsoft Slider control 6. I wrote it a few years ago in Access 2010.
I put some VBA code in the slider's Scroll event.
When I copy the database to a computer with Access 2013, the code in the Scroll event does not fire.
The control and any other sliders added after it do not have a scroll event, only the five or so generic events like OnEnter, OnExit, etc.


I have tried:


docmd.acCmdRegisterActiveX controls
I made sure the file is in a trusted folder in the Trust Center


I am using Windows 8.1 on a laptop 64 bit, while the office installation is 32 bit, Office Professional 2013.
How can I get the Scroll event to work for a slider control in Access 2013? If the answer is to register or re-register the control then please provide instructions on how to do so.

I have read on the internet already of people saying that these ActiveX controls are outdated or not best. If that is the content of your reply, I would appreciate a specific alternative instead simply saying "Don't use that".

[jonh]

No idea. Using controls that aren't part of an applications standard installation is always risky business and at your own risk. That's why I never used them.

[HiTechCoach]

Have you verified that the ActiveX control is installed properly in Windows?

[jrajul]

How does one do that?

[HiTechCoach]

Where did you get the ActiveX slider? Without knowing where you got the slider and how it gets installed it is difficult to know.

Also, are you running the 32-bit or 64-bit version of Access 2013? If the 64-bit then that is the issue. Unfortunately 32-bit ActiveX controls will not work with any Access 64-bit versions.

[jrajul]

I got the slider from clicking on Design > Controls > More (drop down arrow)> ActiveX Controls > Microsoft Slider Control, Version 6.0.

I am using 32bit Office 2013 on 64bit windows 8.1 on a laptop.

Previously I was using 32bit Office 2010 on 32bit XP Professional desktop. That is where I created the application and where the sliders worked well.

[HiTechCoach]

Unfortunately when you go to:

Design > Controls > More (drop down arrow)> ActiveX Controls >

The list shows you all the controls that are installed on your PC. Not just what was installed with Access or should be used with Access.

This list includes what is installed by other software application and you may not have the proper license to use them in Access. These ActiveX controls from another source may work but you probably do not have the required developer rights to deploy them to other PCs. For one application I worked on the ActiveX my client wanted to use was from a software application that they had purchased for every PC that would need to use it from Access.

The Slider you used was probably installed with some other application that was created with VB6 that was installed on the XP machine.

Assuming you have not purchased a Microsoft Visual Basic 6.0 and/or Microsoft Visual Studio 6.0 license:

In my opinion the proper way to get this control is to purchase a license or move it from the XP machine so you can install the same program on the new PC that was also installed on the XP machine.

If you have purchased a Microsoft Visual Basic 6.0 and/or Microsoft Visual Studio 6.0 license then try installing this

Microsoft Visual Basic 6.0 Common Controls
(includes the slider co

http://www.microsoft.com/en-us/download/details.aspx?id=10019




This package updates two Microsoft Visual Basic 6.0 Common Controls: mscomctl.ocx and comctl32.ocx to address the issues described in the KB articles noted in the Related Resources section on this page.
This package will not install these Common Controls if they do not already exist on the target system. This package cannot be uninstalled.

This package is provided under the terms of the End User License Agreement and is intended for the following customers:



Customers who are Microsoft Visual Basic 6.0 and/or Microsoft Visual Studio 6.0 licensees.

Customers who are not licensees of Microsoft Visual Basic 6.0 nor Microsoft Visual Studio 6.0 but are using older versions of the two Common Controls.



Mainstream Support for Microsoft Visual Basic 6.0 ended on March 31, 2005. However, we are releasing this non-security related package because it contains improvements that were ready for release just prior to the end of Mainstream Support. Microsoft Visual Basic 6.0 has transitioned to Extended Support which runs through March 31, 2008. Microsoft is not extending the Mainstream Support phase for Microsoft Visual Basic 6.0 in any way.

[jrajul]

Thank you, HiTechCoach, for your attentive reply. I have downloaded and installed the update package in the link you have posted and have not noticed any difference in the slider controls. When I add a slider control, the onchange and onscroll events are not available in the VB editor window.

For anyone who came across this post from a search engine because they are having the same issue, I have found a partially successful workaround. I used the ActiveX scrollbar instead of the ActiveX slider control. It does not respond to mouse clicks and mousewheel movements the same way as a slider control, but with some extra coding, it can be used for mostly the same purpose.