Solved

Calender not working in 2010 ms access

Posted on 2013-06-13
20
259 Views
Last Modified: 2013-06-17
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
Comment
Question by:gtmathewDallas
  • 9
  • 8
  • 3
20 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39246022
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
 
LVL 75
ID: 39246030
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
 

Author Comment

by:gtmathewDallas
ID: 39246070
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 75
ID: 39246083
Not that I can think of ...
It's highly unfortunate that Microsoft did not provide this OCX in A2010 for backward compatibility !
0
 

Author Comment

by:gtmathewDallas
ID: 39246118
I am sorry, i copied the ocx file to C:\Windows\SysWOW64, but not sure how to set a reference
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39246124
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
 

Author Comment

by:gtmathewDallas
ID: 39246131
i did it but showing error dllregisterserver failed
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39246136
open cmd.exe as admin and then enter: regsvr32 %SystemRoot%\syswow64\mscal.ocx
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 39246159
"but not sure how to set a reference"
Open the VBA Editor>>Tools>>References>>Point to the file.

mx
0
 
LVL 75
ID: 39246161
Not to be confused with Registering ... no need for that.
0
 

Author Comment

by:gtmathewDallas
ID: 39246165
file name, directory name or volume label 1 syntax is wrong - i typed it correctly as you provide
0
 

Author Comment

by:gtmathewDallas
ID: 39246170
I will try that way too.. sorry i just missed your post "Open the VBA Editor>>Tools>>References>>Point to the file."
0
 
LVL 75
ID: 39246184
Do not Register ... Set a VBA Reference to it.
You may not be able to do Registry settings on user's systems.
0
 

Author Comment

by:gtmathewDallas
ID: 39246244
It still showing the error 2683 object missing :(
0
 

Author Comment

by:gtmathewDallas
ID: 39246252
in the reference it showing the calender control 2007 as selected..
0
 
LVL 75
ID: 39246274
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
 

Author Comment

by:gtmathewDallas
ID: 39246421
Ok I ll do that, thanks a lot...
0
 
LVL 75
ID: 39246578
Did that work ?
0
 

Author Closing Comment

by:gtmathewDallas
ID: 39253616
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
 
LVL 75
ID: 39253656
That was the best move ... use  the 2010 Calendar control.

mx
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question