dating...

[yessir]

i have searched about dates, and checked other access sites by reference of others, and unfortunately i am here to ask help.

does anyone know of a module, set of table, code, link to any of the like, for the processing of dates to fill in cbo's properly based on month (ie correct days based on month and if leap year or not)

thanks

InDebeted

 

[Mile-O]

to fill in cbo's properly based on month

What do you mean?

 

[yessir]

ok

i have a combobox for month, day, year respectively

each are populated from a table.'

If i choose the month as feb, there should only be 28 days avail. unless it is a leap year.

as well 30 days has september, april june and november, all the rest have 31....

along this line, i was wondering about code, a module, or something that would do these checks

thanks

 

[Mile-O]

If Not IsDate(DateSerial(Me.cboYear, Me.cboMonth, Me.CboDay)) Then
    MsgBox "Not a valid date.", vbExclamation, "Example"
End If

 

[Rich]

Why not just use a Calender control, or Date Time picker?