Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date picker

Status
Not open for further replies.
kwill

kwill

Technical User
Aug 15, 2001
49
US
Anyone know how to set a default date on the activeX date picker in a manner such as default to 60 days before today. ?????
 
Sort by date Sort by votes
use the Form's Load Event

Private Sub Form_Load()
DatePickerControlName.value = date - 60
End Sub

PaulF
 
Upvote 0 Downvote
Not too shabby, not too shabby. Thank you sir. that works just fine.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
426
dhookom
dhookom
kmsohn
  • Locked
  • Question
Reservations prevent double booking on same date-Access
Replies
1
Views
269
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
Can't call procedure on Report... Working on detecting out of date objects for auto update
Replies
3
Views
292
lameid
lameid
digitalias
  • Locked
  • Question
Temporarily retain Date value in data entry form
Replies
0
Views
225
digitalias
digitalias
1DMF
  • Locked
  • Question
Date field in SQL not working on form with UK date
Replies
4
Views
262
1DMF
1DMF

Part and Inventory Search

Sponsor

Back
Top