Overdue month, but not on a date field

[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.

 

[Brendan Reynolds]

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.

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

 

[Tom van Stiphout]

On Mon, 15 Dec 2008 08:24:35 -0500, "H J" <[email protected]>
wrote:

Then convert it to a date, using the DateSerial function.

-Tom.
Microsoft Access MVP