Report or Word Doc from Access Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ted - 10 Mar 2005 17:37 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

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

Reply to this Message

Tim Ferguson - 10 Mar 2005 18:55 GMT

> 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

Reply to this Message