Overdue month, but not on a date field

  • Thread starter Thread starter H J
  • Start date Start date
H

H J

I have a form that the user wanted to have a drop down list of the months
(not a date field formatted as a date, simply a list of the months) they
then want a report based off this field to show overdue reports. How can I
get this to work? I am sure if it was a date field it would be much easier,
but with it being a list I can't use any of the built in date/time
functions.

Thanks.
 
H J said:
I have a form that the user wanted to have a drop down list of the months
(not a date field formatted as a date, simply a list of the months) they
then want a report based off this field to show overdue reports. How can I
get this to work? I am sure if it was a date field it would be much easier,
but with it being a list I can't use any of the built in date/time
functions.

Thanks.
Click to expand...


Here's an example which, given a combo box that lists the English-language
names of the twelve months of the year, places a date in a text box that is
the first day of the selected month in the current year.

Private Sub cmdTest_Click()

Me.txtDate = CDate("1 " & Me.cboMonths & " " & Year(Date))

End Sub

Private Sub Form_Load()

Me.cboMonths.RowSourceType = "Value List"
Me.cboMonths.RowSource =
"January;February;March;April;May;June;July;August;September;October;November;December"

End Sub
 
Back
Top