If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Calendar" Form to insert Month and Year
I am using a VB calendar to insert dates on many forms. It works very
well. However on a monthly budget form I only need month and year. I am using a calendar form and formating date field mmm/yyyy. When user selects month and year and clicks enter, it inserts correctly. BUT, the days section of the calendar is confusing users. Is there a "calendar" form without days? thanks |
#2
|
|||
|
|||
Use two comboboxes, the first for year and the second for month. Put the
following code in the AfterUpdate event of the month combobox: Me!MydateField = Me!NameOfMonthCombobox & ", " & NameOfYearCombobox -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "eb1mom" wrote in message ... I am using a VB calendar to insert dates on many forms. It works very well. However on a monthly budget form I only need month and year. I am using a calendar form and formating date field mmm/yyyy. When user selects month and year and clicks enter, it inserts correctly. BUT, the days section of the calendar is confusing users. Is there a "calendar" form without days? thanks |
#3
|
|||
|
|||
Thank-you for your help. Form is now much less confusing and users are
pleased. I appreciate you taking the time to answer my post. "PC Datasheet" wrote: Use two comboboxes, the first for year and the second for month. Put the following code in the AfterUpdate event of the month combobox: Me!MydateField = Me!NameOfMonthCombobox & ", " & NameOfYearCombobox -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "eb1mom" wrote in message ... I am using a VB calendar to insert dates on many forms. It works very well. However on a monthly budget form I only need month and year. I am using a calendar form and formating date field mmm/yyyy. When user selects month and year and clicks enter, it inserts correctly. BUT, the days section of the calendar is confusing users. Is there a "calendar" form without days? thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
2 calls (month and year) to be combined as date in single cell | Andigo | General Discussion | 1 | August 5th, 2004 03:28 PM |
Access Calendar | lost | General Discussion | 2 | July 7th, 2004 04:58 AM |
Add a FIXED MONTH and DAY with the CURRENT YEAR | texcel | General Discussion | 1 | June 23rd, 2004 01:36 AM |
date conversion | web_time | Worksheet Functions | 10 | December 25th, 2003 06:51 PM |