2007 Merge Data

[Karen]

I used Albert D. Kallal's most updated simple word merge in AC2000 software.
It works fine in 2000. The database is maintained on a server.

However, on AC2000 I cannot view the query or the records on the form with
the "MERGE THIS RECORD" button. When I click on this button, it doesn't
combine the data with the merge template.

What would prevent the data source from working properly in AC2007?

 

[Karen]

FYI - the query is producing results in 2007. However, the form is not
reading the data from the query.

 

[Albert D. Kallal]

Usually in these cases the form has picture, or a attachment type field.
Sometimes, even a sub-form control can mess this up...

The best solution in these cases is to build a query with ONLY the primary
key field + ONLY the fields you need in the merge.

You then use MergeAllWord in place of MergeSingleWord.

eg:

dim strSql as string

strSql = "select * from MyNewQueryIJustBuilt where id = " & me!id
MergeAllWord strSql

And, when you build that new query, base it on the table (not another
query), and make sure there are no parameters etc. for that query.

Test the query BEFORE you try the above code and make sure it returns ALL
RECORDS from the table. And, of course, make sure the code compiles....

 

[Karen]

Thanks for all your efforts, Albert.

I simply recreated the form and added the command button. Those on AC2007
are able to view the data and the merge works perfectly now. I don't know
why it didn't work on the old form.