Why does Calendar Pop-Up when clicking other ComboBox?

[WDSnews]

In Access 2007, the form wizard gives me a nice pretty blue area at the top
where the title of the form can be seen. This is where I usually put my
"find" comboBoxes that the combobox wizard builds for me.

On one form, at the top center of the white area, I have a date field,
directly below my "find" comboboxes. Whenever the cursor is in the date
field and one of the "find" comboboxes is clicked, the Calendar pops-up.
I've used the form's 'Open' event to first put focus in the comboBox, but
eventually the user clicks on the date field, followed by clicking on a
"Find" comboBox, and the user becomes annoyed.

The date field doesn't have any code attached to any events. The "Find"
comboBox only has the normal After_Update code created by the wizard.

The calendar doesn't always pop-up. For example if you click on the right
side of the field, outside the direct vertical alignment of the date field.

What causes this and how can I fix it?

 

[Tom Wickerath]

Hi WDS,

Are you talking about the new built-in calendar, introduced with Access 2007
(the one that doesn't allow selection of the year)? If so, consider disabling
it. I think this is a property of a text box, although I'm not positive, as I
mostly use Access 2003.

If you want a decent calendar, with a button next to this text box, have a
look at Access MVP Allen Browne's popup calendar:

Popup Calendar
http://allenbrowne.com/ser-51.html

I'm fairly certain this one won't activate automajically ;-)


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Arvin Meyer [MVP]]

If you want a decent calendar, with a button next to this text box, have a
look at Access MVP Allen Browne's popup calendar:

Popup Calendar
http://allenbrowne.com/ser-51.html

I'm fairly certain this one won't activate automajically ;-)

Or my popup Calendar form which is global to your database and has worked
perfectly in every version of Access since I originally wrote it almost 15
years ago:

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

 

[Tom Wickerath]

Hi Arvin,

I'm sure your example is excellent as well. Allen's sample is also global to
the database. You import the form and a module, and then you can call this
calendar form from any form in the database.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[WDSnews]

Thank you. I'll see if there's a way to disable this bug-ridden calendar
pop-up in Access 2007.

 

[Tom Wickerath]

Hi WDS,

Thank you. I'll see if there's a way to disable this bug-ridden calendar
pop-up in Access 2007.

See Access MVP Allen Browne's page here:
http://allenbrowne.com/Access2007.html#Bugs

Look for the entry that reads: Date picker shows in queries. You should see
the following:

"In table design, you can set the Show Date Picker property to No for a
Date/Time field, but in a query the field still has the date picker."

I *think* you can also disable it at the form level, as a property of a text
box, but you might as well kill it at the table level.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Melanie Martin]

why are I having problems with this live.com, I can't delete anything, I
can't send emails out with outlook, what is this its driving me carzy.

 

[John W. Vinson]

why are I having problems with this live.com, I can't delete anything, I
can't send emails out with outlook, what is this its driving me carzy.

You may want to post your question in a group supporting live.com. This isn't
one; this group is for questions about the database software Microsoft Access.