Missing Calendar

[Jon]

Hi All,

The company I work for has an Access 97 database on a file
server. This was working OK until we upgraded the workstations. The
main form for creating a new record has a date box and the only way to
enter data into this is to double click to get the calendar and select
a date. But now the calendar doesn't come up, it produces a runtime
error 438. This only happens on the laptop machines, the desktops are
fine so I'm guessing that Access has been installed differantly on the
laptops. I'm not a programmer but have looked through the code and
found that double clicking on the box makes a call to something called
ActiveXCt10.
So now I'm stuck. I've tried searching and found lots of info
on how to use the calendar but not on where it comes from. Could it be
a dll that contains the ActiveXCt10 routing is missing ? Or, something
that just occured to me, could it be that ActiveX isn't installed at
all ? How can I tell ?
Any help appreciated.

Thanks,

John.

[Mike Storr]

You'll need to install the Calendar control from the Office (or Access)
installation disks. I can't remember where it's contained in the setup, but
it's there. If they are not available, I beleive MS has (at least had) a
Calendar control that you could download and distribute. However, you may
need to fix references in any DBs that you install this for.

Mike Storr
www.veraccess.com
"Jon" <jo*@jrussell.plus.com> wrote in message
news:g3********************************@4ax.com...

Hi All,

The company I work for has an Access 97 database on a file
server. This was working OK until we upgraded the workstations. The
main form for creating a new record has a date box and the only way to
enter data into this is to double click to get the calendar and select
a date. But now the calendar doesn't come up, it produces a runtime
error 438. This only happens on the laptop machines, the desktops are
fine so I'm guessing that Access has been installed differantly on the
laptops. I'm not a programmer but have looked through the code and
found that double clicking on the box makes a call to something called
ActiveXCt10.
So now I'm stuck. I've tried searching and found lots of info
on how to use the calendar but not on where it comes from. Could it be
a dll that contains the ActiveXCt10 routing is missing ? Or, something
that just occured to me, could it be that ActiveX isn't installed at
all ? How can I tell ?
Any help appreciated.

Thanks,

John.

[Tony Toews]

Jon <jo*@jrussell.plus.com> wrote:

I'm not a programmer but have looked through the code and
found that double clicking on the box makes a call to something called
ActiveXCt10.
So now I'm stuck. I've tried searching and found lots of info
on how to use the calendar but not on where it comes from. Could it be
a dll that contains the ActiveXCt10 routing is missing ? Or, something
that just occured to me, could it be that ActiveX isn't installed at
all ? How can I tell ?

Yup, I'd agree that it's not installed. And that Mike's suggestion of locating and
re-installing is a good one.

An alternative is to just get rid of the control and use something else. Such as the
API call which is the same as the control or use forms.

See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[NB]

It might have been a missing library

Check this out on Allen's web site

http://members.iinet.net.au/~allenbrowne/ser-38.html

NB

[Jon]

On 3 Mar 2004 21:40:04 -0800, ni******@lycos.com (NB) wrote:

It might have been a missing library

Check this out on Allen's web site

http://members.iinet.net.au/~allenbrowne/ser-38.html

NB

Thanks Mike and NB,

Yep, that was the problem, a missing file. Didn't need to use the
install disks, once I'd found out what file it was (mscal.ocx) just
copied it from one of the desktop machines to all the laptops that
need it and registered it with windows.
Thanks again.

John.