hello,
I have an open query which asks the user to input
month and year (in format ##/####) for when individuals
join a particular professional organization.
Basically in my criteria for the query i use the [ ]
operators to prompt the user for to imput a month and
year.
Now, i use a RunApp Macro to send the results of the
query to Word for a mail merge. However, when i am
setting up my main document, i cannot select my query
because it is not listed.
I believe it is not listed because it is an open
query. I am using Access and Word versions 2002 and i
found that it worked successfully in office 2000.
Does anyone have any solutions on how to get this to work?
Much appreciated,
Ilan
Rsandhofer - 22 Jul 2004 16:30 GMT
Ilan,
Look at in Microsofte knowledge base at article
833064 "word was unable to open the data source error
message in word mail merge when you use an access
parameter query in access 2002". When I try the method
1, I see my query. My query has multiple parameters and
I had some problems. So, I am trying method 2 - saving
to a file. I Still have other issues to work throught.
I hope the article might help you some with your problem.
Good luck.
R.Sandhofer
>-----Original Message-----
>hello,
[quoted text clipped - 17 lines]
>Ilan
>.