Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Calender not working in 2010 ms access

Posted on 2013-06-13
20
Medium Priority
?
282 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 28

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
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!

 
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 28

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 28

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 1500 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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

772 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