S
Steven Greenberg
Greetings,
I finally figured out how to get that calendar boxes on my report to print
out the correct dates. I would have been able to do it much easier via VB
directly, but I used a variation on the method. It is not as bad as I had
first thought.
the main concept is to use a loop to cycle through 42 text boxes names
sequentially and build the reference like:
me("text" & intnum).text = intnum
this i placed on a grid of textboxes on my calling form and hid them by
shrinking them way down and setting the bg and fg colors to match the form.
on the report, i have the same kind of grid with 42 text boxes each with
the control source set to one of the text boxes on the form.
it is a simple matter to figure out which weekday that particular
month/year combo falls out on and offset the starting date by that amount.
then just have to account for the end of the month. right now it is a
select case for 28, 29 30 or 31 days. I would like to use the trick to go
to the first of the next month and subtract 1 day, but i would have to see
the sample code again. right now it works fine.
I thank all for their suggestions and samples.
Regards
Steve
I finally figured out how to get that calendar boxes on my report to print
out the correct dates. I would have been able to do it much easier via VB
directly, but I used a variation on the method. It is not as bad as I had
first thought.
the main concept is to use a loop to cycle through 42 text boxes names
sequentially and build the reference like:
me("text" & intnum).text = intnum
this i placed on a grid of textboxes on my calling form and hid them by
shrinking them way down and setting the bg and fg colors to match the form.
on the report, i have the same kind of grid with 42 text boxes each with
the control source set to one of the text boxes on the form.
it is a simple matter to figure out which weekday that particular
month/year combo falls out on and offset the starting date by that amount.
then just have to account for the end of the month. right now it is a
select case for 28, 29 30 or 31 days. I would like to use the trick to go
to the first of the next month and subtract 1 day, but i would have to see
the sample code again. right now it works fine.
I thank all for their suggestions and samples.
Regards
Steve