need guidance: reports or word automation ?

  • Thread starter Thread starter Xavier
  • Start date Start date
X

Xavier

Hello,

I am new to Access and looking for some guidance.

I am currently developping an application in which I can manage customers
and the work I perform for these customers. Each month I need to produce a
report summarizing, day by day, the work I performed for the customer. The
monthly report needs to be formatted in such a way that it displays stuff
like company logo, customer address (formatted in such a way that, once
printed, the sheet can be put in a A4 window enveloppe -not sure about this
traduction, sorry-), and a two column table containing dates and work
performed on the corresponding dates.

I wonder what would be the best way to have access producing these reports ?
I am considering two approaches

1. using Access reports but from what I saw so far, listboxes don't seem
that easy to customize (row heights, ...)
2. using automation and from Access, opening a Word template and putting the
data in a Word table.

I would like to hear some expert advice about the feasibility (and
complexity) of these approaches. Or, is there other ways to produce what I
want ?

Any help or suggestion would be appreciated.

Thanks,

Xavier
 
Xavier ,

I think the best solution is to use the Acces report. Why are you
considering listboxes for reports?
Just put bound textboxes in the detail section of the report and simulate
table headers with labels in the Page header section.
You can add the Logo/Address in the Report header.
You'll have to play around a bit with the location of the address textbox to
make it fit your window envelope but this should be fine.
 
Hi,

"listboxes" was a typo. I meant textboxes. I'll follow your advice and
further experiment the Access reports.

Thanks.

Xavier
 
Back
Top