calendar button?

[darksniper]

I would like to add a button, that on click it would open a mini calendar with current date, where if I need to change the date I could and then I could click ok and it would set the date in the proper field.

 

[boblarson]

I like this one:

http://www.access-programmers.co.uk/forums/showthread.php?t=103387

 

[burrcm]

The included Activex calendar writes it's value to a table which you can query. Here is a demo...

Chris B

 

[boblarson]

The included Activex calendar writes it's value to a table which you can query. Here is a demo...

Chris B

Chris:

Yes, that works (if it works). And what I mean by that is that I tend to avoid using ActiveX controls if at all possible because I've been burned too many times where reference problems rear their ugly heads because a user's computer isn't configured exactly right. So, if I can avoid using ActiveX controls then I never have to worry about it. But, you can use that one if you don't mind the risk and potential pain of having to go fix it where it ends up not working.

Just my reasoning for not using the ActiveX controls.

 

[darksniper]

Looks nice, allthough, it is hard for me to avoid not using it, when I used just a date field, I had french people enter the date one way and english enter it another way, and in the end it was all the mess. And when it came to do reports I had check to make sure the dates were in correct format. For now that activeX calendar is quite neat and it makes sure that everyone enters the date in the same format. I have to use about 5 of those on one form. I dont think thats too bad. Thanks!

edit: If there is another way that I could use without activeX I would gladly use if there is a way like that. In java I could just code a panel that looks like the calendar, and send the data to source on close event, but in access... Oh well.

 

[georgedwilkinson]

When discussing internation date formats I'm way out of my league but I have to wonder two things:
1. Are the regional settings on the front end machines set up correctly?
2. Are the fields you're having problems with true date fields or just text fields disguised as date fields?

Like I said, I'm out of my depth but I would expect that if data in a true date field were entered using the correctly set up regional settings, it would take it whether it were in France, the UK, or the USA.

 

[darksniper]

ok, what happends is for one language the date standard is month-day-year, for the other is the day-month-year. and even that I directly mention the date format I am still having people that mix them up and when ever there is an issue I am getting bugged. It just got to the point that I need to make it simple enough that everyone just uses the same format. and the activeX seems to be a good solution.

 

[boblarson]

I wasn't meaning to say that the ActiveX control couldn't work for you, just that you need to be aware of the potential problems when using them.

 

[missinglinq]

Bob's point is particularly important here, since you obviously have multiple users, possibly in multiple sites. The popup , non-ActiveX calendar he gave you a link to (and there are many others out there) works in basically the same way as the native Access ActiveX calendar does. His point , however, is that it will work with any version of Access. If one or more of your users upgrade to a different version of Access, or for that matter, if one or more of them are using a different version than you are now, the Access ActiveX calendar may very well fail! If you insist on going this route, keep the URL for this forum handy, you're going to need it again!

 

[wiklendt]

as a related aside... i am working with access 2007, which has the calendar button built-in to any fields with "date/time". what i want to know is, how can i disable this feature on certain fields? b/c some are date, but some i just want the time entered, and the calendar button would just confuse (when it pops up, it only shows a calendar, not a clock) - but i also don't want ot confuse previous versions of access either...


OR if it could show a clock of some sort? dunno, maybe just leave it as no calendar button...