Export access report to word .... problems plz, help me :(

  • Thread starter Thread starter Martyn Kobli
  • Start date Start date
M

Martyn Kobli

Hello,
I have spent 4 days reading newsgroups and I could not find solution
for my problem. I know here is a lot of ideas how to export to word
but no one suits to me. Acctualy some of them are not working properly
or are to slow.
So if you have time I would very appreciative your help or ideas.

I am working for College. We need to print certificates when you can
find fields as: name, course, type of certificate .... this is header
and then list of modules and their marks or grades. So my first
problem is, that I am using grouping in access report.

Name: xxx
Student Number: xxx
Course Name: xxx
CourseCode: xxx

Module Title Module Code
C Programming Concepts l (Java) ITA403
Production of Sound for Multimedia 3637CK
Introduction to CD-Rom 3637AC
Production of Video for Multimedia 3637CL
Production of 2D Animation for Mm 3637CM

So very easy would be just publish report to word but we need special
structure and graphics elements on report for first and second
sometimes the report must be editable. It's mean change some name of
field or change position of logos etc. So I decided to export report
to word to the template. But it's not easy at all. :(( I tried mail
merge with sophisticated merge field (if ..) so I was able to get
similar structure but it was vere paintfull and I know for sure, that
my user is not able prepare different template by him self. And it was
very slow as well. Then I tried bookmarks, but I was not able run
recordset with my query for records because it contains two parametrs
.... I find some solutions find eval function but it wasn't working. I
still get mismatch error ....
So I am totaly broke ... and this time I hate access and word ...
could you help me please .... Martyn
 
You either need to switch to PDF or look into Word Automation
and basically code how data transfers into a word file (bigger challenge).

Checkout our products they may help,
Mark
RPT Software
http://www.rptsoftware.com

PS: The next version of Access could have a solution exporting to XML
which works well in Word.
 
Hello,
I can't switch to pdf because I'am not able do the same certificate in
access (visualy - borders around reports) and then export. If I could
I would stay in access and I don't need export anywhere.
And very important for me is, that in time the report can change and
user must be able does this chnges ..... :((((

What you mean word automation can me tell more, plz ....

Martyn
 
Back
Top