T
TIML
I have to create a report that is automated with VBA. I am having an
individual input data into a form and then I want them to be able to email
the information on the form. I don't think you can email a form, but I
wanted to create a report that reflected the data instead. The form is
populating a table, so I could simply pull the data from that table. The
problem is I need to have 6 columns in the report, which are the days, and
then the data for each day in that column. ie.
Monday Tuesday Wednesday Thursday Friday Saturday
8/23/04 8/24/04 8/25/04 8/26/04 8/27/04
8/28/04
Line 1 50 40 25 35
27 34
Line 2 20 24 20 15
56 45
I need to have the VBA code populate the date fields at the top dynamically
and then create formula's, I am guessing, to poplulate each field. I
already have the date's captured in varialbes for my form, so it should be
easy to populate the dates, but I am having a problem with the data for each
Line.
Am I doing this the wrong way, any thoughts would be greatly appreciated.
Tim
individual input data into a form and then I want them to be able to email
the information on the form. I don't think you can email a form, but I
wanted to create a report that reflected the data instead. The form is
populating a table, so I could simply pull the data from that table. The
problem is I need to have 6 columns in the report, which are the days, and
then the data for each day in that column. ie.
Monday Tuesday Wednesday Thursday Friday Saturday
8/23/04 8/24/04 8/25/04 8/26/04 8/27/04
8/28/04
Line 1 50 40 25 35
27 34
Line 2 20 24 20 15
56 45
I need to have the VBA code populate the date fields at the top dynamically
and then create formula's, I am guessing, to poplulate each field. I
already have the date's captured in varialbes for my form, so it should be
easy to populate the dates, but I am having a problem with the data for each
Line.
Am I doing this the wrong way, any thoughts would be greatly appreciated.
Tim