I'm having a goofy error with Word and Access from a VB6 app.  I hope
someone out there can shed some light on the issue.

I'm getting the error:

"Word could not merge the main document with the data source because
the data records were empty or no data records matched your query
options."

when the data is present and perfectly fine. This error is sporadic and
closing the app and restarting it usually works fine.

The app imports (appends) records from a text file into an Access
table. Prior to the import the the table is cleared of previous
contents (ie DELETE * from tblName.)

The app then launches Word, opens my mail merge document (datasource is
already set) and executes the merge:
   ...Code snippet...
   If oWord Is Nothing Then Call OpenWord
    oWord.Documents.Open (oParameters.ReferralForm)

    ' Run the Word mail merge
    With oWord.ActiveDocument.MailMerge
        .Destination = wdSendToNewDocument
        .Execute
    End With

Any help would be greatly appreciated.

Kurt

Sent via Deja.com http://www.*-*-*.com/
Before you buy.