I have an access 2003 database (service pack 2) with which i am trying to create a calender on a form using the "microsoft date and time picker control 6.0 (SP4)". As long as i only open the form that has the calender on my computer there is no problem.
But as soon as i open the form on another computer, i loose the control for the calender.
I installed service pack 2 on this pc. Which then resulted in an error message informing me that there was a missing reference for "miscrosoft windows common controls-2.6.0 (SP4)", file "mscomct2.ocx" was missing from "c:\windows\system32\". So i copied the file over from another computer but now i am getting the error message "there is not object in this control" whenever i try to open the form with the calender on it.
Once doing this if i try to open the form on my original computer the control is no longer there, just an empty textbox.
Any ideas why this is happening?
Once i have completed this database it is going to need to be run off multiple people's computers.
Is there any way of coding this problem into a module so i can aviod going to each computer to fix this??
Thanks in advance.