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

x
?
Solved

MSCAL.OCX Version Conflict

Posted on 2004-03-29
5
Medium Priority
?
344 Views
Last Modified: 2011-09-20
I have a database that has been using the Calender Control 9.0 (mscal.ocx).  When I installed it on a computer running Access XP, when they attempt to use the control it crashes Access.

I am running office xp on my development machine, but have no problem with it on this machine.  When I checked the version of MSCAL.OCX that the other machine has, it is version 10.0.  The only way to get it to work is to do a repair of the Office installation, and then it changes the reference from the 9.0 to 10.0, but I don't want to require this of my endusers each time they install the software.

Is there a way that I can configure the calendar to work regardless of what version of Access and what version of MSCAL.OCX they are running? Keep in mind that I need this to work in the Access 2000 runtime version as well. I am looking for another free activex control to use in stead, but if there's an easy way around this, it would be preferred.
0
Comment
Question by:earthman100
5 Comments
 
LVL 34

Accepted Solution

by:
flavo earned 2000 total points
ID: 10709973
try http://www.mvps.org/access/search.htm

and search for calendar... This site is full of little goodies for access, i recommend bookmarking it for future use!

Dave
0
 
LVL 4

Expert Comment

by:goliak
ID: 10712648
You can use DatePicker control. It is rather kind. Also i advise you to make your DBs in Access2000 as far as most users have it and it is very stable.
0
 
LVL 2

Expert Comment

by:rhems
ID: 10712907
Hi earthman100,
I have had an identical problem.  I have 2 solutions for you.
1)  I created an access 2000 mdb front end and an access xp mdb front end.  Then I created a visual basic script that determines that version of office installed on a client's machine and loads the appropriate mdb.  works well.  let me know if you want more info.  Only problem is that if you make development changes, you will then have to convert the access2000 version to access 2002 and distribute both.

2)  check out http://www.glump.net/content/accessdatepicker  This is a sample mdb with a form that I have started to use for the exact reason as you specify above.  I am tired of trying to get an activex control to work in all situations.  This is a custom form that acts as a calendar control.  I quite like it.  You place a call to a function on a button click and it will update either a textfield or a variable with the selected date.  I have encountered no problems running it on access 97/2000/xp.

Hope that helps.
Rich
0
 
LVL 2

Expert Comment

by:rhems
ID: 10712923
Oh, one other thing.  Just to stress what Goliak said.

What is the lowest version of office your clients will use?  ALWAYS develop your databases on the 'lowest version'.  That way you ensure that all users will be able to access it (i.e. what would happen now if a user opened your mdb using Access 97??).
0
 

Author Comment

by:earthman100
ID: 11076807
Thanks I have found an alternate method for a calendar instead of active-x, much happier now!

Thanks to all for suggestions!
0

Featured Post

Industry Leaders: 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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

916 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