Win98SE, Access2000: How to create the combo to select months

  • Thread starter Thread starter Arvi Laanemets
  • Start date Start date
A

Arvi Laanemets

Hi

I need a combo on form, where I can select dates (1st of month) in
"mmmm.yyyy" format - starting from one fixed month, and up to current month.
At moment something like
January.1998
February.1998
....
February.2004
March.2004
The selected date has to be stored into date field (ActiveMonth) of
single-row SetUp table

Are some clever ideas available here?
Thanks in advance
 
Hi

I need a combo on form, where I can select dates (1st of month) in
"mmmm.yyyy" format - starting from one fixed month, and up to current month.
At moment something like
January.1998
February.1998
...
February.2004
March.2004
The selected date has to be stored into date field (ActiveMonth) of
single-row SetUp table

Are some clever ideas available here?
Thanks in advance
Click to expand...

I'd just use Excel fill-down to create a list of dates from January
1998 through the end of 2020 or so; import or copy & paste this into
an Access table containing a date/time field. Create a Combo box based
on the table, and set its Format to mmmm.yyyy.
 
Back
Top