Search results

i appreciate the picture, im going to try and implement this. By building this query and using expressions, is the use of the calendar even necessary anymore?

to be honest i havent. But i plan to take a stab at this approach. ill post up the results.

When you say build a query on the dates, are you referring to set dates? Because these dates will change on a weekly basis. Will this format you suggested work easier with that scenario?

For some reason i still cant get the calendar to recognize the day. Heres a snippet of what i have put into one of my combo boxes that hold a date.If cboStartDate = WeekdayName(3, True, vbTuesday) Then intResponse = MsgBox("This is Not a sunday", vbYesNo)

I have imported a calendar from within vba into two comboboxes. These combo boxes will hold different dates once selected from the calendar. I want the user to only select dates on the calendar that fall on a sunday and a saturday. Is there a way i can get the calendar to recognize and prompt...