Hi Sally,
When you say "There is NO ActiveX references associated in the code window under Tools / References" - that's not quite true. In Access 2002/2003, you'll see a reference to the Microsoft Calendar Control (mscal.ocx).
Unfortunately there is no calendar control in Access 2010, so you'll need to do one of the following:
- use the Access 2010 textbox (which can display a calendar);
- purchase a third-party control;
- use one of the solutions provided by MVP Tony Toews (http://www.granite .ab.ca/access/calendars.htm); or
- create your own.
"Sally NZ" wrote in message news:*** Email address is removed for privacy *** .com...
I have an Access database developed years ago and upgraded with new software releases. Currently the database is in 2002-2003 format. It is being used on Access 2003 and Access 2007 software versions successfully. There is NO ActiveX references associated in the code window under Tools / References but runs well on Access 2003 and Access 2007.
The client has just upgraded 3 computers to Access 2010. When the userform containing the calendar control opens it won't display.
Is there a control that I can activate to allow Access 2010 to use the Calendar Controls. The database will still need to be accessed from Access 2003 and Access 2007 computers.
Thanks
Regards, Graham R Seach Microsoft Access MVP Sydney, Australia
1 person found this reply helpful
·
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Thanks Graham. I'll remove the calendar control and revert to a textbox with a calendar pick list.
Thanks for your help, and very speedy it was too! Excellent service, as always.
SJG
3 people found this reply helpful
·
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
There is a built in date picker for access now. So, if you place a text box on a form, and click on it, you see a calendar icon that you can use. No installs needed. You can see/find the settings for this in the "format" tab of the properties sheet, you see a show date picker option. I think everyone been asking for this feature for years, and it great we have this built into access now WITHOUT the need for ActiveX controls which tend to be a real pain during deployment (as you just found out).
Since you need to used this application in a mixed environment and previous versions don't have this built in date calendar, then you have to resort to using something that works in both environments.
So, some suggestions that would work:
-- Don't use access 2003, but install the free runtime for access 2010, and thus everyone would be on the same version.
--
Use the calendar control here by Stephan
The above will work in all recent versions.
-- Consider ensuring that the mscal.Calendar.7 activeX control is correctly installed on all computers. If you do this, then there no reason why this does not work in access 2010. So, it is not at all clear as to how/when/where/who been ensuring that the calendar.7 control is being installed correctly on the target machines. Someone has to manage this installing and ensuring that the activeX control is installed on that target computer and this is NOT the responsibility of Access nor is access equipped to installed ActiveX controls for you.
So, just "hoping" that the control might be installed certainly is not a reliable approach as your question itself demonstrates.
At any rate, my above suggestions gives about 3 possible approaches and solutions. Another possible is to grab some non activeX examples, Tony has some links here:
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
*** Email address is removed for privacy ***
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
I've not tried it, but there seem to be a large number of reports where it fails to register. I've also read where the ocx interface changed at v10 (Office 2002) -http://support.microsoft. com/kb/311219. Much of what I've read suggests that the ocx is just not redistributable. Have you tried it Albert?
"Albert D. Kallal [MVP]" wrote in message news:*** Email address is removed for privacy *** .com...
There is a built in date picker for access now. So, if you place a text box on a form, and click on it, you see a calendar icon that you can use. No installs needed. You can see/find the settings for this in the "format" tab of the properties sheet, you see a show date picker option. I think everyone been asking for this feature for years, and it great we have this built into access now WITHOUT the need for ActiveX controls which tend to be a real pain during deployment (as you just found out).
Since you need to used this application in a mixed environment and previous versions don't have this built in date calendar, then you have to resort to using something that works in both environments.
So, some suggestions that would work:
-- Don't use access 2003, but install the free runtime for access 2010, and thus everyone would be on the same version.
--
Use the calendar control here by Stephan
The above will work in all recent versions.
-- Consider ensuring that the mscal.Calendar.7 activeX control is correctly installed on all computers. If you do this, then there no reason why this does not work in access 2010. So, it is not at all clear as to how/when/where/who been ensuring that the calendar.7 control is being installed correctly on the target machines. Someone has to manage this installing and ensuring that the activeX control is installed on that target computer and this is NOT the responsibility of Access nor is access equipped to installed ActiveX controls for you.
So, just "hoping" that the control might be installed certainly is not a reliable approach as your question itself demonstrates.
At any rate, my above suggestions gives about 3 possible approaches and solutions. Another possible is to grab some non activeX examples, Tony has some links here:
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
*** Email address is removed for privacy ***</ A>
Regards, Graham R Seach Microsoft Access MVP Sydney, Australia
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
"Graham R Seach [MVP]" wrote in message news:*** Email address is removed for privacy ***...
I've not tried it, but there seem to be a large number of reports where it fails to register. I've also read where the ocx interface changed at v10 (Office 2002) -http://support.microsoft. com/kb/311219. Much of what I've read suggests that the ocx is just not redistributable. Have you tried it Albert?
Most activeX controls have a licensing scheme built in and thus you can't just "copy" them to the target machine (and I suspect are well aware of this issue).
So, without using a developer edition of the control, it can't be just copied to other computers and registered (else we would be lifting all controls from any application installed on my computer). Note that you can often use controls from other applications that been installed on your computer. However, you can lift + copy these controls to other computes.
I don't know if the msacal.ocx has license controls, but the only simple solution that comes to mind is to build something in VB6 or c++ that installs on the target computer and thus registers the activeX control that was original an developer edition (as opposed to a simple copy + register of a activeX control that been "installed" that as mentioned often not work).
So, I not tried the above, but I do believe the above should work to correctly install the control. As noted, access PW does not support activeX controls (to be fair, it did prior to 2003).
In my case, I would likely build a inno script that installs both the front end + the mscal. However, to be honest, I have not done either of the above.
So, if I had to place my bets on this, and had to use an ActiveX, then I would attempt one of the above approaches. And, I freely admit I not done or tested the above.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
*** Email address is removed for privacy ***
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
I'll beat your recieving an error 438. Object not support for that action. According to Microsoft the calendar control which was supported in previous versions of Access has been removed from Access 2010. I was having the same issue in running my report as the calendar control was not operational in 2010 but worked fine in Access 2007. Apparently, microsoft has taken a harder stance in protecting users databases as this control was prone to a security risk.
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Mr Kallal,
Perhaps you can assist me, I can get the date picker set up in Access 2010, but it only scrolls month to month. I need a calendar that will also go year to year, in order to choose a birthdate (some go back a ways and month by month click takes forever.
I have been searching and forums show 2010 is missing a calendar ocx for active x. I am not much more than a beginner to intermediate in Access and am not sure about trying to implement the VB coding, etc.. for the other calendar fixes I see.
Is there a way to fix the active x or is there a way to make the date pciker add year scrolling?
Is there some better way to do this?
Thank you.
1 person found this reply helpful
·
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
I would add three additional fields, each with a drop down (combo box) for day, month, year. Popular the list with days 1 - 31 and months Jan - Dec and years whatever you think would cover the range.
After you have enter the day, month and year, concatenante the three together and convert to a date for your date of birth.
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Source: https://answers.microsoft.com/en-us/msoffice/forum/all/access-2010-not-using-activex-control-calendar/913421e6-a3c0-451f-bf2e-1c2c4da68bcb
Posted by: maisiekuehne0194027.blogspot.com
