Allen Browne's Calendar Access 2003 / 2007 problem

[james_lankford]

let me start off by saying

I am sure the problem is either my coding or with the machine I am using and not with the Allen Browne Calendar's

so, Allen Browne has made this wonderful little calendar form and made it available for public use.

link to calendar
http://allenbrowne.com/ser-51.html

I have been using it in an Access 2003 database with no problem.
But now I open the 2003 database with Access 2007 and I get a problem.

Here's the logic of my form:
The user is supposed to select a date from the calendar. When they select a date a button is made visible that allows them to save the form. (It is a bound form.)

However, I wanted to "catch" the case when they click on the standard record navigation buttons.
As you know, The normal behavior of a bound form is to save the form when the user clicks the navigation button and moves to the next record. So I check in the form's BeforeUpdate event handler to see if the date has been filled in.
If it hasn't then I tell the user that a date is required and I cancel the BeforeUpdate.

Makes sense ?

here are 2 screenshots of Access 2007
this is normal: the use has clicked on Allen Browne's calendar and it has popped up
http://imageshack.us/photo/my-images/14/normalni.jpg/
notice the calendar, notice the image on the command button that opens the calendar

now here's when the problem occurs
instead of clicking on the calendar, the user has clicked the standard recored navigation button for the next record,
no date has been filled in so I tell them, "fill in the date", and cancel the update
when I do that the icon for the calendar's command button CHANGES ! ?

the user clicks the command button to open the calendar and gets
http://imageshack.us/photo/my-images/543/confusedo.jpg/
a completely different calendar ! ?

notice that the image for Allen Browne's calendar is still there, and if press escape to exit this new calendar, then I can carefully click on the button and bring up the old (correct) calendar

so, what the heck is going on ?

first of all I am SURE my logic for the form could be better
I am TERRIBLE at making forms
but I don't think my logic is the problem
and I have not edited anything
the form works fine on a machine with Access 2003, but I get this strange behavior when its opened in Access 2007

 

[xenou]

Just off the top of my head:

1) Uncheck the option to use the calendar drop down (I mean the "normal" one for date fields, which is not normal in Access 2003 since it didn't exist - this is now in the "Options" somewhere in the Office Button).

2) Don't show navigation buttons.

3) Put the actual date field in a hidden field, and only show an unbound textbox as the one that the users enters a date in (the hidden field can be set equal to the visible control).

Other ideas may be better ... I'm shooting from the hip here.

P.S. I think I'm the worst at forms ... we should have a contest!