Calendar Deault to Todays Date

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I am using a calendar on a form. What code is needed to
have the calendar focused to todays date? What code would
be needed so the calendar would be focused on the last
date entered?
 
Bill,

To make today's date the fefault, put this code in your form's OnActivate event:

Me!NameOfCalendarControl.Value = Date()

For part 2 of your post, you would need to save that date somewhere and then
modify the above code to:

Me!NameOfCalendarControl.Value = DLookup.... <Wherevever you saved the date>


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
 
You must log in or register to reply here.

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

Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Adding Record to Table 1
Excel Worksheet_BeforeDelete code not working as expected. 1
Calendar & Access 2002 3
Outlook 2016 Calendar printing monthly view 0
Escape from Access Calendar. 3
Outlook Shared Calendar declining appointments 0
Smart Calendar 3

Back
Top