Billy Pang
tuxedoman888 at gmail.com
Wed Sep 13 14:23:35 CDT 2006
what happens if we rearrange the values in the value list? does it still come up as "current week"? On 9/13/06, JWColby <jwcolby at colbyconsulting.com> wrote: > > I use a highly modified version of Julie Schwalm's date picker code. I > use > a combo instead of the radio button group that she used and added a bunch > of > new possibilities. The combo I use to select the date range I want has a > row source type of "Value list" and a row source of: > > 1;Include All Dates;12;Custom Date Range;14;Current Week;2;Current > Month;3;Current Quarter;4;Current Year;5;Month To Date;6;Quarter To > Date;7;Year To Date;15;Last Week;8;Last Month;9;Last Quarter;10;Last > Year;11;Last 12 Months;13;Today;16;Yesterday > > In my time tracking / billing database I want to open a time data entry > form > to filter to today. If I put a default value of 1 in the combo (the > "ordinal value" for "Include all dates"), I get the correct thing, > "include > all dates". If I put 2 in there, I get "CURRENT WEEK", which is wrong, it > should select "CURRENT MONTH". IOW, the integer value should select the > text immediately AFTER the integer value (in the value list string), but > seems to be selecting the value immediately BEFORE the integer value. > > Any thoughts on this? > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Billy Pang http://dbnotes.blogspot.com/ "Once the game is over, the King and the pawn go back in the same box." - Italian proverb