Export Logo into header in Word

[Guest]

Hi all,

I dont know if it is possible to do what i intend to...

Once i created the report, i want to export it to the Word file, modify and
save to a location.

Here i got 4 problems:

1 - the Logo from my Report wouldnt export to Word

2 - i want some fields to appear in header/footer of the Word file - is it
possible to do that?

3 - i want some fields to appear as a table within the Word file - is it
possible to do that?

4 - can i somehow store back to the database the link to location where the
file was saved?

....Too many questions for 1 thread, but still would be greatfull if somebody
could help...

Thank you.
Lana

 

[SA]

Lana:

The answer to all your questions is no, none of them are possible as an
Export from Access. That said, the way you probably want to go about doing
this is to create a Word Mail Merge Template with your log, table etc. The
link to the Access data that would populate the Word template via the mail
merge capabilities.

HTH

 

[Guest]

The couple of times i worked with mail merge didnt bring too much fun.
I was trying to simplify the procedure for not advanced users by the means
of Access... Thought Access could have more capabilities and could be
compatible with Word in certain features....

Cannot I at least export the report into .PDF read only file?

Lana

 

[Peter R. Fletcher]

SA is correct, as far as his response goes. You can, however, do all
the things you want to do in VBA with Word Automation. It is not
trivial to write the necessary code, but it is not horrendously
difficult, either. It frequently helps to start with a Word .dot file
(which could already contain your logo) with Bookmarks in it where you
want the contents of the Access fields to appear. Your VBA code then
finds and replaces the Bookmarks. About half the output generated by
one of my commercial applications is created this way.

As usual, (!) I would recommend that you start by reading the relevant
sections in Litwin et al.'s Access 2002 (or 2000) Desktop Developer's
Handbook.

The couple of times i worked with mail merge didnt bring too much fun.
I was trying to simplify the procedure for not advanced users by the means
of Access... Thought Access could have more capabilities and could be
compatible with Word in certain features....

Cannot I at least export the report into .PDF read only file?

Lana

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