Full Version: Lebans Calendar
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
hma543
Would like an explanation:
I have three instances of the calendar to fill three date fields- OrderDate, TcDate and CallBackDate on one form all set to open with onClick. Everything worked. Added Got focus event to all three. Things worked as expected except OrderDate- it opend onGotFocus but I had to click the calendar twice to insert the date. The other two opened on GotFocus and inserted date on single click. Did not like that-commented out the GotFocus events. The TcDate on click event stopped working. The fix was to comment out the TcDate onclick event and re-enable the GotFocus event for it and everything works again. Why ? All of the code seems right for all 6 events (now three events being used)- it's exactly the same except the field names. Also, when the TcDate was not working, the calandar position would change back to upper left corner everytime the database was closed and re-opened. Don't really need a fix for it as everything works now, but I think I'm missing an access fundamental somewhere and I'd like to find out what that is.

Now, what I would like to do to the calendar is change it's caption to reflect the name of the date field and remove the properties and close buttons. Found how to change the calender title but not how to change it for the three different fields. Haven't a clue where to start.

Thanks to all in advance.
HiTechCoach
I use this http://allenbrowne.com/ser-51.html

It already does exactly what you want.
Aquadevel
hma543,

You might take a look at the ReturnDate
demo that is attached to one of my posts in that thread.

It works great, has 2 different sized calander forms for you to use, and works great within forms, subforms, and sub-subforms.

Just a thought, good luck with your project. sad.gif
HiTechCoach
I forgot top mention that Leban's code using the TITLE of the form to work properly. I am not sure it the code will still work properly if you start changing the title. If you do want to use his calendar solution, you might consider adding the text for the field to the form where the property and clode button were.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.