Exporting a report to word (advanced)

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hello,

I have a problem that I'm hoping someone can help me with. I'm not very
experimented with reports in access so I need a step by step or example if
possible.

I have created a report in access that is a compilation of several small
reports. In it I have a page header including logo and lines that form a
table. The baulk of the report is a tabulation of information that with the
aid of lines appear to be in a table.

I have been asked to program it so the report is automatically exported
into word so that the user can edit/modify or add information as they chose.
The problem is that when I have tried to do so it gives horendous results.
The graphic...lines ... etc do not appear (just does not work).

Only two options come to my mind and would like your help:
1- I have no clue as to what I am doing and someone knows how this can be
done?! (hopefully)
2- Create a base template in word and populate it with the data originating
from my query in access?! Once again, just a thought, but do not know how
this can be achieved.

Please, any help is welcome! And thank you in advance!!!!!

Daniel
PS: why is it every time you think you've finished developing the customer
has to throw a curve ball?!
 
Exporting to Word (actually to RTF) is hopeless if you need to
maintain layout and/or include graphics - it's not that you are not
doing it properly!

Using "vanilla" Office applications, you can either use a Word
mail-merge template and your Access query as a data source - this
works well only for relatively simple reports, and it sounds as if
yours may not be - or use Office Automation to (in effect) write the
Report in Word from Access. You can do virtually anything with this
approach, but it often requires quite a lot of VBA coding. I believe
that there are sone "packages" (commercial and non-commercial) that
automate this process or help in other ways, but I have not used them
- one of the MVPs may jump in with details.

Hello,

I have a problem that I'm hoping someone can help me with. I'm not very
experimented with reports in access so I need a step by step or example if
possible.

I have created a report in access that is a compilation of several small
reports. In it I have a page header including logo and lines that form a
table. The baulk of the report is a tabulation of information that with the
aid of lines appear to be in a table.

I have been asked to program it so the report is automatically exported
into word so that the user can edit/modify or add information as they chose.
The problem is that when I have tried to do so it gives horendous results.
The graphic...lines ... etc do not appear (just does not work).

Only two options come to my mind and would like your help:
1- I have no clue as to what I am doing and someone knows how this can be
done?! (hopefully)
2- Create a base template in word and populate it with the data originating
from my query in access?! Once again, just a thought, but do not know how
this can be achieved.

Please, any help is welcome! And thank you in advance!!!!!

Daniel
PS: why is it every time you think you've finished developing the customer
has to throw a curve ball?!
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top