I have a 5 record database for learning purposes, with a MS Calendar Contol, I believe its 8.0 the compress file has it. I can retrive records using If then with the value of the calendar, but that would require I have a if then for thousands of dates. I can not seem to find the right syntax for a select Statment. What I need from coder is that code to make it find the record to go with that date. Also is there a way to have the calendar add a record for a date that is not in the datbase already?
1. code to have calendar control find record that matches that date.
2. code to have calendar control add record not in database already.
MS Access 2002