Results 1 to 12 of 12
  1. #1
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179

    Question Unanswered: Microsoft Forms 2.0 and MS Access 2007

    Hi all,

    I'm trying to migrate some forms from MS Access 2003 to MS Access 2007. Some of these forms have the the ActiveX "Spin Button" control from "Microsoft Forms 2.0" (FM20.DLL).

    In MS Access 2003, the spin button works fine, but MS Access 2007 won't execute the code behind the "updated" event.

    Anyone know why? Any insight is appreciated.

    Thanks,
    JT

  2. #2
    Join Date
    May 2010
    Posts
    601
    First, is the database in a trusted location to enable the VBA code?
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    It wasn't initially, HiTechCoach, but before posting here I put the mdb in a trusted location. I also tried digitally signing it. No joy with either approach.

  4. #4
    Join Date
    May 2010
    Posts
    601
    Do you have all the lated Service Packs for Office 2007 installed. Are you at SP2?

    Also see:
    Description of the 2007 Microsoft Office suite Service Pack 1
    Last edited by HiTechCoach; 10-05-10 at 10:32.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  5. #5
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    I'm on a Windows Server 2003 box, SP2.
    With MS Office Access 2007, SP2.

  6. #6
    Join Date
    Oct 2009
    Posts
    27
    ActiveX "Spin Button" control may not work due to any missing reference. You can check this by going to the code section of it and go to Tools-->References.. In the opened popup, it will indicate as MISSING if there is no reference for it.

  7. #7
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    sql-programmers,

    I have 5 references selected, none are missing:
    Visual Basic for Applications
    Microsoft Access 12.0 Object Library
    Microsoft DAO 3.6 Object Library
    Microsoft Visual Basic for Applications Extensibility 5.3
    Microsoft Forms 2.0 Object Library

    The Microsoft Forms 2.0 Object Library has the "Spin Button" control.

  8. #8
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    I finally resorted to using "premium" microsoft support. Microsoft confirmed the spin button updated event is a known issue in Microsoft Access 2007 but not Microsoft Access 2010. A suggested workaround is to use the change event, which works in both Microsoft Access 2003 and Microsoft Access 2007, but has a drawback: the change event is not a listed property. I found the same problem with the Microsoft Forms tab strip control. Same (unattractive) workaround applies.

    I'm pressing microsoft to post something on microsoft.com. While it may be a known issue to the premium support team, it's clearly not a known issue to those of us who tried to resolve the problem. If microsoft actually does end up posting something (I'm told this can take weeks), I'll post back here.

    Thanks to all who offered suggestions.

  9. #9
    Join Date
    May 2010
    Posts
    601
    Thank you for the update!
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  10. #10
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    A final update, 4 weeks later... the Microsoft KB:
    The Updated event does not fire for some controls in Microsoft Access 2007

  11. #11
    Join Date
    May 2010
    Posts
    601
    Thanks for the link.

    This is why I have always avoided using custom controls in all versions of Access.

    I would just use command buttons to chreate/simulate the spin buttons.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  12. #12
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    I tend to follow that approach too, HiTechCoach. As you can see, I have only the bare-bones references in my application.

    With one glaring exception: Microsoft Forms 2.0. And even of those, I only use tabstrip and spinbutton.

    Silly me for making an exception though eh? I figured since they were bonafide Microsoft controls, not 3rd party or anything, and always pre-installed (at least I don't remember seeking them out via downloads), I'd be safe.

    But no.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •