resolved:Suppress Merge Field Calculation Errors in Word 2000

[dglienna]

What do you mean, the table calculates dates? Is it a macro, or VBA code?
Or does is a program used? What are the calculations?

[RobDog888]

I formatted your code for easier reading.

If your query is generating an error from calculating dates then you need to resolve the error in Access since
you already have displayalerts off.

Also, when you do ThisDocument.Saved = True you do realize that its not actually saving the document but
turning off the flag that tells Word if the macro class "ThisDocument" is saved. Dont know why you need
that when your not modifying the macro code.

[xentaur]

Thanks for the reply

Dates are calculated using field codes within the Word document that use bookmarks as a reference. Only the original date for the calcuations is retrieved from an access table. This date is referenced in the word document as a bookmark (fromdate). This bookmark is then used in field code calcuations to determine the week-end date for 13 consecutive weeks from 'fromdate'. There is no error in the formatting or calculations of the access data, nor any visible problem with the date calcuations in the word fields - but if I remove the table from the word document which contains the calculations, then what remains in the main document merges to formletters with no errors.

I'd like to avoid rewriting the date calculations in vba because, as previously stated, the field codes are generating the correct result however something which i cannot pinpoint is causing the merge error.

If the 'mail merge errors' doc cannot be suppressed I'd appreciate a recommendation on the appropriate forum/website to post the field-codes I'm using for scrutiny by superior users.

Much appreciate the response so far.

Cheers

Xentaur.

PS. FYI, the ThisDocument.Saved=true is historic code from the original document which only needed to merge one record, used to prevent users from saving the merged document over the original (I've got some fairly ill-educated end-users).

[dglienna]

What errors occur if you turn display errors back on?

You may have to post your code and the table so we could look at it.


M$ probably has a service to resolve bugs with their software, unless it turns out not to be a bug, then they charge you. Either way, it'll get fixed, though

Good Luck!

[RobDog888]

You do realize that "ThisDocument.Saved=true" is referring to your macro code and not the actual document.
To save the actual document you need to do like ActiveDocument.Save to save it or bypass the dirty flag
by doing ActiveDocument.Saved = True.

Without seeing your data calculations or other code it makes it harder and I dont want to be guessing. Can you
attach your document?