Question for Albert Kallal, merging updated record

[Guest]

Albert -
Another little query re the WordMerge:
If you're in a record and update some of the data (say, part of the
address), and then save the record, then go to use WordMerge, it still pulls
through the original data.
It seems necessary either to leave the record and then come back into it
before using WordMerge, in order to get the updated data. Or hit
Tools/Refresh. This is not ideal. OK, our users know about it now, but it's a
little messy.
Can the Refresh process be incorporated into WordMerge?
Many thanks
CW

 

[Albert D. Kallal]

good suggestion.

Actually, my code does have a disk write force in it by default...
I assume to merge to word, you placed the following code behind a "word
merge" button:

MergeSingleWord.

The above is all you need, and my code *does* force a disk write BEFORE it
launches the merge.

You might want to post how your merge code looks, but as a default setting,
it does do a disk write of the current record...

however, the code does NOT by default do a disk write if you supply you OWN
sql. The reason for this is when you supply you own sql, then you might not
even BE ON A FORM WITH data!! (You can make a merge menu, or form that has
no data, but in fact simply uses a query).

So, if you are merging from a form that can edit data, then go

me.Refresh
MergeAllWord "my cool sql statement here"

While mergesingleWord does do a disk write, Merge DOES NOT, and this due to
as the above mentioned issue that you might be called mergeAllWord from a
NON bound form (unbound form with no data).

I could/should perhaps do a disk write, but then My code would have to
determine if the calling code (mergeAllWord) is bound to a form with data
(this is possible, but I currently leave it up to the programmer to write
out the data when using MergeAllWord. However, as mentioned, MergesingleWord
DOES do a disk write for you....