Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1513
  • Last Modified:

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?

0
Papote
Asked:
Papote
  • 5
  • 4
  • 3
1 Solution
 
TextReportCommented:
I suspect you will need to get an administrator to do this or get temporary admin rights to do this.
Cheers, Andrew
0
 
PapoteAuthor Commented:
Are you referring to the DOS command?
0
 
TextReportCommented:
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
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
PapoteAuthor Commented:
I copied it from my PC since on the PC with Access 2007, I do not have access to the system32 folder.
0
 
TextReportCommented:
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
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
0
 
PapoteAuthor 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.
0
 
TextReportCommented:
Try deleting and recreating the control on one of the forms causing the problem.
Cheers, Andrew
0
 
PapoteAuthor 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?
0
 
Jeffrey CoachmanMIS LiasonCommented:
Is there a reason why you ignored my post?
0
 
PapoteAuthor 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.
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK
Thanks for the clarification.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now