Bob Gajewski
rbgajewski at adelphia.net
Sun Jul 6 18:27:56 CDT 2008
Thanks William! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman Sent: Sunday, July 06, 2008 16:30 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How do I change the default month inLeban'sMonthCalendar module? Bob ...Lebans frequents the ms.public.access forums and usually responds to questions about his code posted there. William -------------------------------------------------- From: "Bob Gajewski" <rbgajewski at adelphia.net> Sent: Sunday, July 06, 2008 9:22 AM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: [AccessD] How do I change the default month in Leban'sMonthCalendar module? > Hi Folks > > I have attempted to use Leban's "MonthControl" solution > (http://www.lebans.com/monthcalendar.htm) for populating a date field > on a form. Of course, it works wonderfully - as programmed. > > However, for the purposes of my specific form, the user will almost > always be entering data from the previous month. If I double-click on > my IncidentDate field today, the popup shows July, August and > September - but they will probably need June. > > Does anyone know where/how I can insert the DateAdd("mm",-1,Date) code > to have the it default to June, July and August (last month, this > month and next month)? I tried to work with the dtStart value, but my > code keeps failing ... > > TIA, > Bob Gajewski > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com