Report or Word Doc from Access Record

[Ted]

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

btw...my company is in the Stone Age....we're still using Office 97

 

[Tim Ferguson]

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.

Surely these are all primary reasons to use an Access report? It's likely
to be much easier than programming a Winword document.

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

Either, you can look up the value for wdFirstCharacterEtcEtc, or you can
set a reference to the appropriate library in the References tool.
Probably Winword.10 or something.

Hope that helps



Tim F