Solved

Calender not working in 2010 ms access

Posted on 2013-06-13
20
277 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
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 - Microsoft MVP, Access and Data Platform) 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

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!

Question has a verified solution.

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

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…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

623 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