Creating a Word Doc from an Access Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ted - 10 Mar 2005 17:45 GMT

Hi all,

I need to create a document from an Access record. I don't think I can use a
report because there are so many variables. If certain things are checked it
will be in the document if it isn't i need the document to shift so there
won't be any white space.

The problem is I may print [InsuredName] on one line and then at column 130
on the same line I need to print the [CompanyName]. I tried tabbing after
[InsuredName] but that won't work bc some letters are wider than others.
There is no way to know how many Tabs I'll need after [InsuredName] to
get to column 130.

I tried using objWord.selection.Information(wdFirstCharacterColumnNumber)
but Access didn't recognize the constant wdFirstCharacterColumnNumber.

Any help would be very much appreciated!

TIA
Ted

Reply to this Message

Chuck - 11 Mar 2005 15:35 GMT

Not sure I understand how you can get the information from Access into Word
(aside from copy typing) if you can't generate a report "because there are
too many variables". If you can extract a single record in Access, that
means you're running a query and if you 've got a query, you've got what you
need to build a report.

It would be a lot simpler to do what you want in Access, not least because
it will allow you to re-use and automate your query/report.

If you're only doing whatever you're doing once, with one record, and for
whatever reason you can't build a query to extract the data, then it's
probably simpler to just type it into a Word document.

> Hi all,
>
[quoted text clipped - 16 lines]
> TIA
> Ted

Reply to this Message