Calendar Control works in Access 2003 but not Access 2007

[kware100]

I have a database where Access 2003 the uses can open a calendar control
which will populate a field when selected. When a new user (using Access
2007) carries out this action, the calendar does not open and they get an
error message.
Any help appreciated.

 

[Arvin Meyer [MVP]]

Access 2007 has it's own built-in calendar. Instead of using an ActiveX
control, try using this Calendar form. It works in every version of Access:

http://www.datastrat.com/Download/Calendar2K.zip

 

[Tony Toews [MVP]]

I have a database where Access 2003 the uses can open a calendar control
which will populate a field when selected. When a new user (using Access
2007) carries out this action, the calendar does not open and they get an
error message.

What's the error message?

Tony

 

[Gina Whipp]

kware100,

Sounds like you are using the built in calendar control and the end-users do
not have that file on their computer. (Of course, without the error message
this is a guess.) This is one of the reasons I don't use the built in
calendar control. Try... http://allenbrowne.com/ser-51.html it goes
wherever the database goes, no worries about References or whether or not
the end-user has the calendar control.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[kware100]

Error message is 'Run-time error 2165' You cannot hide a control that has the
focus. Odd thing is that anybody using Access 2003, doesn't have this problem.

 

[Gina Whipp]

Right because the calendar control comes with Access 2003 and it's a
different one for 2007.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm