D
Duane
Hello,
I have a question about report design. I have a hazardous material report
that I am trying to make look as close to our department generated (state
wide) form which was made in MS Word. The issue I have has to do with the
entire page is a table with 7 columns and border shading.
Of course, using Access, the report stops as soon as there are no more rows
in the recordset. One report may only have 5 rows a data and another may
have 25 rows. I would like every report to show 30 rows on each page, even
if they are blank.
I am wondering if there is a way using VBA, to either measure the distance
used in the detail section and then have a routine to draw boxes to fill the
rest of the page, OR is it possible to have a routine write the data to an
existing Word document.
I know I can do this if it were in in Excel, with little trouble, but I
would rather learn how to write the data to MS Word document then to have to
recreate it in Excel.
Thanks in advance.
I have a question about report design. I have a hazardous material report
that I am trying to make look as close to our department generated (state
wide) form which was made in MS Word. The issue I have has to do with the
entire page is a table with 7 columns and border shading.
Of course, using Access, the report stops as soon as there are no more rows
in the recordset. One report may only have 5 rows a data and another may
have 25 rows. I would like every report to show 30 rows on each page, even
if they are blank.
I am wondering if there is a way using VBA, to either measure the distance
used in the detail section and then have a routine to draw boxes to fill the
rest of the page, OR is it possible to have a routine write the data to an
existing Word document.
I know I can do this if it were in in Excel, with little trouble, but I
would rather learn how to write the data to MS Word document then to have to
recreate it in Excel.
Thanks in advance.