can't use a control selected from More Controls

[Allen_N]

I'm trying to use the "Microsoft UpDown Control, version 6", which is in the
list that appears under 'More Controls' in Form Design view. I can put in on
a form and open its Properties window, but Access won't recognise the
UpDown_Change event, so I can't see how to use the control.

Also, clicking Help on the UpDown Properties window raises the message
"Cannot find the C:\WINDOWS\system32\cmctl298.chm file".

I don't understand why the control is available under 'More Controls' if it
is only partly there. Am I missing a step?

Thanks!
-- Al

 

[Tony Toews [MVP]]

I'm trying to use the "Microsoft UpDown Control, version 6", which is in the
list that appears under 'More Controls' in Form Design view. I can put in on
a form and open its Properties window, but Access won't recognise the
UpDown_Change event, so I can't see how to use the control.

Also, clicking Help on the UpDown Properties window raises the message
"Cannot find the C:\WINDOWS\system32\cmctl298.chm file".

I don't understand why the control is available under 'More Controls' if it
is only partly there. Am I missing a step?

I have no idea as to your particular problem. However, if at all
possible or reasonable, we strongly discourage the use of controls
given the distribution or version problems that you are likely to
have.

As an alternate idea consider using the KeyPress event and responding
to the + and - keys appropriately.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Dirk Goldgar]

In

I'm trying to use the "Microsoft UpDown Control, version 6", which is
in the list that appears under 'More Controls' in Form Design view. I
can put in on a form and open its Properties window, but Access won't
recognise the UpDown_Change event, so I can't see how to use the
control.

Also, clicking Help on the UpDown Properties window raises the message
"Cannot find the C:\WINDOWS\system32\cmctl298.chm file".

I don't understand why the control is available under 'More Controls'
if it is only partly there. Am I missing a step?

I think the "More Controls..." list will show all ActiveX controls that
are registered on your system, whether they'll work with Access or not.
Lots of them don't. It may be that you could get this particular
control to work, but I couldn't advise you as to how.

I agree with Tony: you'd do better to avoid non-native controls where
possible, at least for an Access application that will be distributed to
other users, because they are subject to versioning and licensing
problems.

 

[Allen_N]

Thanks Tony, Dirk.

Good advice, I'm sure, but I was encouraged by a Microsoft Knowledge Base
page that described the set of controls that this one belonged to as having
been created for VBA (Office 97, I think). Am I being naive?

 

[Rick Brandt]

Thanks Tony, Dirk.

Good advice, I'm sure, but I was encouraged by a Microsoft Knowledge
Base page that described the set of controls that this one belonged
to as having been created for VBA (Office 97, I think). Am I being
naive?

The vast majority of controls you see there either don't work in Access or you
are not licensed to use them even if they do work. As Dirk stated it is simply
a list pulled from the registry of all ActiveX controls on your system.

Many of those that could be made to work will have no documentation for you to
understand HOW to make them work.

Lastly, ActiveX controls should almost universally be avoided in any app that
will be used on more than one machine since the proper distribution and
registration of those controls is usually more trouble than the control is
worth.

 

[Dirk Goldgar]

In

Good advice, I'm sure, but I was encouraged by a Microsoft Knowledge
Base page that described the set of controls that this one belonged
to as having been created for VBA (Office 97, I think). Am I being
naive?

I don't know about this particular control. But Office 97 and *Access
97* are two different things. For example, Excel (and probably Word can
have "userforms" which are completely different from Access forms. So
the fact that a control was created for Office 97 doesn't mean that it
will work in Access 97.

I'll see if I have this control on my system and can get it to work in
Access.

 

[Allen_N]

I've actually found another, older control from Microsoft Forms 2.0, called
SpinButton (class = "Forms.SpinButton.1"), which I got to do the job. I
ensured that it works on another user's PC. However, the issues that have
been raised about ActiveX controls have me thinking I need to do some
research before going any further with such things.

-- Al