We help IT Professionals succeed at work.

DateTimePicker object in Access 2007

Papote
Papote asked
on
Medium Priority
1,533 Views
Last Modified: 2013-11-28
I have a PC with Access 2007. My database was created with Access 2003. I have a Date Time Picker object on a couple of forms that I got from the Microsoft Date and Time Picker Control 6.0 (SP4) ActiveX Control. I went in the VBA editor and manually added the MISSING reference (Microsoft Windows Common Controls-2 6.0 (SP6)). Since I DO NOT have administrative access on this PC, I went to Browse and added it from c:\temp\MSCOMCT2.OCX. I no longer get the missing reference error but now I get the following error when I open a form with this control: There is no object on this control. I tried registering the OCX, but get an error with the DOS Command regsvr32.exe C:\temp\mscomct2.ocx. Even in the editor window running the DoCmd.RunCommand acCmdRegisterActiveXControls call.
How can I re-enable this object in Access 2007 without administrative access to the PC?

Comment
Watch Question

I suspect you will need to get an administrator to do this or get temporary admin rights to do this.
Cheers, Andrew

Author

Commented:
Are you referring to the DOS command?
When you aded the missing reference did you copy it from another PC or was it already on the PC? Please note you may need to check the license for this as you may not be allowed to copy the file.

You may need to get an administrator to register the control with regserv but you may need them to install it from its actual source.

Cheers, Andrew

Author

Commented:
I copied it from my PC since on the PC with Access 2007, I do not have access to the system32 folder.
Please note that this file is probably copyrighted and therefore you should not just copy it.
There is info on obtaining the files from MS on there website at http://support.microsoft.com/kb/896559, this refers to VB rather than Access but should work, again please check out the copyright and yes an Admin should be installing it as it resides WINDOWS\SYSTEM32
Cheers, Andrew
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Papote,

1. Please remember if this App will only be run in Access 2007 that Access 2007 has a built in Date Picker.
You could dump yours and just use this one.

2. Or just use one of the many Non-active X data controls, and avoid the whole issue of compatabaility altogether.

Here is a great one:
http://www.lebans.com/monthcalendar.htm

JeffCoachman

Author

Commented:
The database will run on a multi-user environment, Access 2000-2007.
I ran the VisualBasic6-KB896559-v1-ENU.exe as an administrator and I see the ActiveX Control and can even add a new one, but the ones already on the form still get the "There is no object on this control" error message.
Try deleting and recreating the control on one of the forms causing the problem.
Cheers, Andrew
Commented:
Found a good working MSCOMCT2.OCX to register on the PC, but to do it I need to have local administrator privileges.

Any way to do this with having to log in as an admin? Emulate the OCX or something?

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Is there a reason why you ignored my post?

Author

Commented:
Boag2000: My application will be used on PCs with Access 2000 upto 2007. So the 2007's date time picker out of the question. I could use a non activeX form, and in the future I might change it, but right now the powers that be want the ActiveX version.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
OK
Thanks for the clarification.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.