Month and Year selection

[Matt Reed]

Want to do a form to Select the Month and Year for a report.

Would like to use the Calendar controll, but do not want the user to pick
the day.

Is there an easy way to do this or would it be easier to just setup a form
with a couble of ComboBoxes?

Reason for picking, user needs to select month and day of reports. Will run
several reports for that month so I do not want to pick at the start of each
report.

TIA.

Matt

 

[PC Datasheet]

Consider building a 3x4 block of buttons for picking the months and a small
lisybox beside them for picking the year.

 

[John Vinson]

would it be easier to just setup a form
with a couble of ComboBoxes?

Yep.

 

[Paul Falla]

Dear Matt
Consider using a combo box for the months and a text box
for the year. Using a text box for the year will save you
having to re-code your form in a few years time when you
run out of years in the combo box/option group - That is
unless you cannot ensure that your users will type the
year correctly!

Hope this helps

Paul

 

[Matt Reed]

Thanks to all who replied.

I did get it to work, by using code in the UPDATE button to automatically
change the day to the first day of the month no matter what day was picked.

Works great.

Thanks again.

Matt

Want to do a form to Select the Month and Year for a report.

Would like to use the Calendar controll, but do not want the user to pick
the day.

Is there an easy way to do this or would it be easier to just setup a form
with a couble of ComboBoxes?

Reason for picking, user needs to select month and day of reports. Will run
several reports for that month so I do not want to pick at the start of each
report.

TIA.

Matt