can't use a control selected from More Controls - ADO DAO RDO RDS

This is a discussion on can't use a control selected from More Controls - ADO DAO RDO RDS ; 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 ...

+ Reply to Thread
Results 1 to 7 of 7

can't use a control selected from More Controls

  1. Default can't use a control selected from More Controls

    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

  2. Default Re: can't use a control selected from More Controls

    Allen_N <AllenN@discussions.microsoft.com> wrote:

    >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/

  3. Default Re: can't use a control selected from More Controls

    In news:EFC5395D-AC2F-4765-9B15-C3E66B73D20E@microsoft.com,
    Allen_N <AllenN@discussions.microsoft.com> wrote:
    > 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.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)



  4. Default Re: can't use a control selected from More Controls

    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?


    "Dirk Goldgar" wrote:

    > In news:EFC5395D-AC2F-4765-9B15-C3E66B73D20E@microsoft.com,
    > Allen_N <AllenN@discussions.microsoft.com> wrote:
    > > 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.
    >
    > --
    > Dirk Goldgar, MS Access MVP
    > www.datagnostics.com
    >
    > (please reply to the newsgroup)
    >
    >
    >


  5. Default Re: can't use a control selected from More Controls

    Allen_N wrote:
    > 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.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com



  6. Default Re: can't use a control selected from More Controls

    In news:AB3C09B3-90B6-4455-9F30-2255DD48AF4E@microsoft.com,
    Allen_N <AllenN@discussions.microsoft.com> wrote:
    >
    > 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.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)



  7. Default Re: can't use a control selected from More Controls

    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

    "Dirk Goldgar" wrote:

    > In news:AB3C09B3-90B6-4455-9F30-2255DD48AF4E@microsoft.com,
    > Allen_N <AllenN@discussions.microsoft.com> wrote:
    > >
    > > 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.
    >
    > --
    > Dirk Goldgar, MS Access MVP
    > www.datagnostics.com
    >
    > (please reply to the newsgroup)
    >
    >
    >


+ Reply to Thread

Similar Threads

  1. Listview control / selected blue line
    By Application Development in forum CSharp
    Replies: 1
    Last Post: 11-30-2007, 09:59 AM
  2. Replies: 3
    Last Post: 10-18-2007, 10:53 AM
  3. Finding Controls in User Control
    By Application Development in forum DOTNET
    Replies: 5
    Last Post: 08-03-2007, 09:34 PM
  4. Volume control does not adjust and stay where selected
    By Application Development in forum Hardware
    Replies: 3
    Last Post: 01-17-2007, 01:51 PM
  5. Replies: 0
    Last Post: 01-08-2007, 04:04 PM