Version Difficulty in VB?

[Guest]

Hello,

I asked earlier for assistance in creating a Word document that I had more
control over in exporting Access records to. Alex Ivanov provided valuable
assistance, and an example: http://www.aleksoft.net/samples/Access_Word.zip

This example uses a module with a line of code that reads:
Set doc = .Documents.Add(Left(CurrentDb.Name, Len(CurrentDb.Name) - 8) &
"report.dot")

The example dB was created in an earlier version of Access than I have
(2003), and works beautifully. However, if I convert the dB to 2003 (which
allows me to edit it), the module creates an error when it is executed:
Run-timer error 5151, Word was unable to read this document. It may be
corrupt...

Any thoughts? Much appreciated.
Seth

 

[Alex Ivanov]

Already answered in original thread.
If len(currentdb.name)<>8 it will not resolve the path properly.
try set doc=.documents.add("your\path\to\report.dot")