G Guest Nov 24, 2003 #1 I currently have a calander set to default to today when opened. Is there a way to set the code to default to last day of current month Mickey
I currently have a calander set to default to today when opened. Is there a way to set the code to default to last day of current month Mickey
P PC Datasheet Nov 24, 2003 #2 Put this code in the OnOpen event of your calendar form: Me!NameOfCalendarControl.Value = DateSerial(Year(Date()), Month(Date())+1, 1-1) -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications (e-mail address removed) www.pcdatasheet.com Mickey Wells said: I currently have a calander set to default to today when opened. Is there a Click to expand... way to set the code to default to last day of current month?
Put this code in the OnOpen event of your calendar form: Me!NameOfCalendarControl.Value = DateSerial(Year(Date()), Month(Date())+1, 1-1) -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications (e-mail address removed) www.pcdatasheet.com Mickey Wells said: I currently have a calander set to default to today when opened. Is there a Click to expand... way to set the code to default to last day of current month?
G Guest Nov 25, 2003 #3 My calander now defaults to an April 10th date, I am guessing that somewhere in the form is this date. Would you agree
My calander now defaults to an April 10th date, I am guessing that somewhere in the form is this date. Would you agree
