I fumbled on the use of the OLE class - Calendar (under class property it says MSCAL.Calendar.7) to put the date chosen on the calendar to a field in a form. I'm using Access 2000 on a Windows 2000 computer. It seems to work fine with two details that I wish I could do something about. I'm hoping you can help me with.
1. Right now if I click on a date on the calendar, all I have to do is to click on the date field and I will get the date to enter in this field (I know, why not enter it straight in...some users like to use the calendar). The slight problem I have is that upon entering in a new set of values on the same form, if the date is the same as the previous set, when I click on the field, nothing happens. I have to click on a different date on the calendar then the date I want then it will work. How do I fix this?
2. I don't know how to set the default date on the Calendar to be today's date. I have to set a hard date in it right now.
Any help will be greatly appreciated.
Thanks In Advance,