Access 2010 Calendar Control

[burrina]

What happened to my calendar(s) ? Just updated to 2010. It's my birthday present. Now, my calendars are gone.Cant find the calendar control either. Where is this picker they talk about too? I am missing a reference some kind of way! Who makes these kind of goofy decisions?

[RuralGuy]

If you bind a control to a date field, the calendar shows up.

[burrina]

Explain that to me.All my calendars are gone. I told it to use the date picker, where is it? It does not show up on my form or when I try and click on any date field?

It show sup when I am in design mode and open the form but NOT when I open the db normally ???

[RuralGuy]

Access should put a small calendar next to the control on your form that is bound to a DateTime field. You are saying it does not?

[burrina]

Yep, it does NOT

[RuralGuy]

My Calendar only shows up when the control has the focus.

[burrina]

Man, I try like crazy clicking on it stomping on it, nothing happens!!! Grrrrr... ONLY when I am in design mode and open it normally there does it work right. Open the db normally and nothing. New software blues, Radical difference from 2000. NOT easier for sure.

[RuralGuy]

Hmm...try opening your db while holding down a <SHIFT> key. Maybe you have some global setting set the wrong way. I don't know which one it would be though.

[RuralGuy]

Have you already set your Trusted Locations?

[burrina]

They are set as they came.I also told it to allow macros and activex, nothing helped. I am missing a Reference I think, just dont know which one. Stupid Microsoft, should not be having this problem on a new install.

Only other thing I can come up with is, I have a date filter that runs when the for opens.

Here is my code, will this mess it up? I hope not.

(Year([OrderDate])=Year(Date()) And Month([OrderDate])=Month(Date()) And Day([OrderDate])=Day(Date()))


(Filter used when main form opens,i.e OrderDetails)

[RuralGuy]

You have to set your Trusted Locations or code will not run: http://www.btabdevelopment.com/ts/2010TL

[burrina]

Thanks, Tried that, NO difference.

[RuralGuy]

If you want to post a test db, I could try it. If it works then there must be some difference. Maybe a re-install will make a difference. Are you using an MDB or did you import your db to an ACCDB?

[burrina]

Tried dumbing it down and go figure, the stupid thing works. What is it , I don't know.At the point where I am not going to post the whole db here.I realize there is only so much you can do for me without seeing the whole thing, sorry! No doubt everybody her could write something better but I have put a lot of hard work into this thing.

I will continue trying to figure it out. This version is NOT user friendly! I may wind up un-installing and going back. That would be a shame since when I bought it today for $74.00, they gave me the whole office suite for FREE.

Bear with me for a while.

Thanks,

Dave

[Rod]

Stick with it! Upgrades to 2007/10 really are a 'culture shock;' everything's in a different place or accessed in a different way. However on balance it's worth it. As Rural Guy says, date picker only shows up for fields formatted as dates when the field has the focus. Paul (pkstormy) and I have both submitted date pickers in the sample code section of this forum.

Calendar Control v12.0 is available under ActiveX controls from the form design window.