S
SJJ via AccessMonster.com
i have this vba code
row is variable
intOffset = Abs((9 - Weekday(Now)) Mod 7)
List = Format(Now() + 7 + intOffset + 7 * Row, "dd/mm/yyyy")
it is a part of a function. i have a combo box which linked to the function..
however this code prodces the date that i wanted but how can i limit it.
i want the combo box to show the dates between Now()+7 and Dateadd("m",2,Now()
).
i dont no how to..i tried to limit the number of rows but i have problem
there too.
i have a calulation which calculate every 3rd sunday in a month...with in the
criteria it is going to be 2 rows..
do u have any idea how to solve this problem.
row is variable
intOffset = Abs((9 - Weekday(Now)) Mod 7)
List = Format(Now() + 7 + intOffset + 7 * Row, "dd/mm/yyyy")
it is a part of a function. i have a combo box which linked to the function..
however this code prodces the date that i wanted but how can i limit it.
i want the combo box to show the dates between Now()+7 and Dateadd("m",2,Now()
).
i dont no how to..i tried to limit the number of rows but i have problem
there too.
i have a calulation which calculate every 3rd sunday in a month...with in the
criteria it is going to be 2 rows..
do u have any idea how to solve this problem.