D
Dudley
I created a command button to open a mail merge document in a backup copy of
my database with code
DoCmd.GoToRecord , , acNext
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
oApp.Documents.Open "c:\My Documents\Word Documents\......DOC"
(The acNext is to ensure that changes to the record are saved)
This worked fine so I did the same in the active database and Word then read
the records twice very slowly and took an age to open the document. I solved
the problem by creating a new folder for the database, but when I created
another command button to open another document the problem came back. The
fast command is still almost instant and the second is very slow but the only
difference is the document name.
Any suggestions?
Thanks
Dudley
my database with code
DoCmd.GoToRecord , , acNext
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
oApp.Documents.Open "c:\My Documents\Word Documents\......DOC"
(The acNext is to ensure that changes to the record are saved)
This worked fine so I did the same in the active database and Word then read
the records twice very slowly and took an age to open the document. I solved
the problem by creating a new folder for the database, but when I created
another command button to open another document the problem came back. The
fast command is still almost instant and the second is very slow but the only
difference is the document name.
Any suggestions?
Thanks
Dudley