Super Easy Word Merge (Access module)

[pilopilo9]

How is this issue resolved? I'm having the same 438 run-time error
when I copy the 2 modules, 2 forms and add the MergeSingleWord code to
a button in an existing form.

thanks.
p.

 

[Guest]

I have looked at Alberts word merge and 483 doesn't sound like it is caused
by this. What folder are you storing the the word docs in - have you linked
to this before. Are you printing the file/doc at the time, etc, etc

Do a google on the problem and you will get some fixes.

Good luck

--
Wayne
Manchester, England.

How is this issue resolved? I'm having the same 438 run-time error
when I copy the 2 modules, 2 forms and add the MergeSingleWord code to
a button in an existing form.

thanks.
p.

 

[Albert D. Kallal]

A few things:

first, try the sample download. (and, try it in the same directory as your
application).

If you can't get the sample to work, then there is LITTLE USE trying to get
YOUR application to work.

If the sample don't work, then try manually creating a directory called
"word" in eh same dir as were the application resides.

Another possible failure point is that your form has some ole embedded
fields. While my code is supposed to skip those, often it gets hung up.

so,

a) try the merge in your application on a form without the ole field, or
better yet, base the merge on a query that has ONLY the fields you need/want
for the merge

So, build the query, add the pk field + any other fields you need. then in
code go:


dim strSql as string

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

So, I have about 3 things to try...give them all a run..and see what
happens...

 

[pilopilo9]

a little bizarre--I got the merge to work after I deleted a label
bound to one of the two check boxes on the form (same 438 problem if I
deleted the label for the other check box. Don't know what the logic
behind that is since the check boxes and labels seem pretty similar to
me)

The sample worked fine.

Thank you.