• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

Calender not working in 2010 ms access

Hi Experts, I am getting 'Run time error 2683' when I am running the 2007 access form in 2010 version, it is happening when i am trying to open the calender - open calender property is calling  on my combo box 'mouse down' event. Please help, I have to use the calender in 2007 and 2010.
Thanks
0
gtmathewDallas
Asked:
gtmathewDallas
  • 9
  • 8
  • 3
1 Solution
 
MacroShadowCommented:
Check to see if you have a missing reference. If you use mscal.ocx see this http://community.spiceworks.com/how_to/show/5517-how-to-solve-missing-mscal-ocx-reference-in-microsoft-access-2010
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
MSCAL.OCX is no longer included in A2010. There is now a built in Calendar - part of any Text Box property sheet ... called Date Picker.

However, if you really want to ... and you have a legal copy of <=A2007, you can get MSCAL.OCX from a system, put the file say in the same folder as your app, then set a Reference to it ... and your original Calendar will still work.

mx
0
 
gtmathewDallasAuthor Commented:
is any other way than copying MSCAL.OCX, because lot of users are using this database, some of them are in 2007 and some of them in 2010.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Not that I can think of ...
It's highly unfortunate that Microsoft did not provide this OCX in A2010 for backward compatibility !
0
 
gtmathewDallasAuthor Commented:
I am sorry, i copied the ocx file to C:\Windows\SysWOW64, but not sure how to set a reference
0
 
MacroShadowCommented:
Instructions in the link in my first post.

I. Click on the Windows Start menu and select 'Run'
II. In the Run command window enter: regsvr32 %SystemRoot%\syswow64\mscal.ocx
III. Select OK to execute the command
0
 
gtmathewDallasAuthor Commented:
i did it but showing error dllregisterserver failed
0
 
MacroShadowCommented:
open cmd.exe as admin and then enter: regsvr32 %SystemRoot%\syswow64\mscal.ocx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"but not sure how to set a reference"
Open the VBA Editor>>Tools>>References>>Point to the file.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Not to be confused with Registering ... no need for that.
0
 
gtmathewDallasAuthor Commented:
file name, directory name or volume label 1 syntax is wrong - i typed it correctly as you provide
0
 
gtmathewDallasAuthor Commented:
I will try that way too.. sorry i just missed your post "Open the VBA Editor>>Tools>>References>>Point to the file."
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Do not Register ... Set a VBA Reference to it.
You may not be able to do Registry settings on user's systems.
0
 
gtmathewDallasAuthor Commented:
It still showing the error 2683 object missing :(
0
 
gtmathewDallasAuthor Commented:
in the reference it showing the calender control 2007 as selected..
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Humm ... I've done this before. I must be forgetting a step.
I think ... on the Form, you have to delete the original control, then ... from the menu - select ActiveX control - point to the Calendar - and put back on the Form ... something like that.

mx
0
 
gtmathewDallasAuthor Commented:
Ok I ll do that, thanks a lot...
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Did that work ?
0
 
gtmathewDallasAuthor Commented:
It didnt work really, because may be i didnt try well, the reason is they are upgrading every users system from 2007 to 2010, so I removed the 2007 calender control and integrated the 2010 (with text box) with the same name. It is now working fine.. Thanks a lot for helping..
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
That was the best move ... use  the 2010 Calendar control.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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