I've created a form that has several fields that each use the updown ActiveX control. The actual name of the control is "Microsoft UpDown Control 6.0 (SP4)" - as it appears in the tools list. Works great. Here's the problem: If I take the database and copy it to a machine at my office, it won't work. The file "mscomct2.ocx" was missing, so the reference was broken. So I copied the .ocx file to the Windows/System directory on the work machine. Still won't work. Interestingly, after copying the .ocx file, the control appears in the tools list as "Microsoft UpDown Control 5.0 (SP2)" - not the same as on my home machine. So I tried deleting the updown controls from my form (on the work machine) and replacing them with v.5.0 controls, but that won't work either, I get a "you don't have the license to use this control" message.
Apparently I've installed something on my home machine which gives me access to the UpDown control, but it isn't installed on the office machine (I'm using Office XP on both) - but I don't know what the UpDown control came with! I'm not using the Developer edition of Office, which would explain the license error message.
I could use the Microsoft Forms 2.0 SpinButton instead (or just a plain 'ol combo box), but I like the appearance and functionality of the UpDown control better. What should I do? Thanks for any advice...
Ken S.
Apparently I've installed something on my home machine which gives me access to the UpDown control, but it isn't installed on the office machine (I'm using Office XP on both) - but I don't know what the UpDown control came with! I'm not using the Developer edition of Office, which would explain the license error message.
I could use the Microsoft Forms 2.0 SpinButton instead (or just a plain 'ol combo box), but I like the appearance and functionality of the UpDown control better. What should I do? Thanks for any advice...
Ken S.