Calander Set Date to End Of Current Month

M

Mickey Wells

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

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?
 
M

Mickey Wells

My calander now defaults to an April 10th date, I am guessing that somewhere in the form is this date. Would you agree
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Lock File .LACCDB / Now shows as a notepad file 0
Countdown macro - display settings 2
Current Office 365 Subscription vs. New One? 0
Show 'month' on each day in monthly view 2
Flag duplicate emails 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
How do I make the month display on the month view on MS Outlook 20 1
Macro for Dates 5

Top