asked on

DateTimePicker object in Access 2007

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?

TextReport

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

Papote

ASKER

Are you referring to the DOS command?

TextReport

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

Papote

ASKER

I copied it from my PC since on the PC with Access 2007, I do not have access to the system32 folder.

TextReport

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 Coachman

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

Papote

ASKER

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.

TextReport

Try deleting and recreating the control on one of the forms causing the problem.
Cheers, Andrew

ASKER CERTIFIED SOLUTION

Papote

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

Is there a reason why you ignored my post?

Papote

ASKER

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 Coachman

OK
Thanks for the clarification.