Mail Merge - not seeing all queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

R.Sandhofer - 22 Jul 2004 14:30 GMT

Using an Access DB which is link to a SQL server DB. The
link files do not show up in the merge to be selected.
Though some of the queries that use the link files show
up. Not all of the queries show up - why?

Reply to this Message

Ilan - 22 Jul 2004 14:59 GMT

i think because your query probably is an open query
which asks the user to input something in order for the
query to run. i am having the same problem.

Ilan

>-----Original Message-----
>Using an Access DB which is link to a SQL server DB. The
>link files do not show up in the merge to be selected.
>Though some of the queries that use the link files show
>up. Not all of the queries show up - why?
>.

Reply to this Message

- 22 Jul 2004 15:23 GMT

Ilan,
Thanks, I had not thought of that. The query uses a form
for parameter entry. So, that might be correct. Wonder,
if there is a way around this?

>-----Original Message-----
>i think because your query probably is an open query
[quoted text clipped - 12 lines]
>>
>.

Reply to this Message

Ilan - 22 Jul 2004 15:34 GMT

i dont know i posted also - if i find out i'll let you
know and i hope i'll do the same.

-Ilan

>-----Original Message-----
>Ilan,
[quoted text clipped - 19 lines]
>>
>.

Reply to this Message

Ilan - 26 Jul 2004 15:30 GMT

hello,
i received a response to my post in access.queries (etc).
it was from a gentleman who is an "MVP" who has a website
for help. The site has a sample access program which puts
a button on a form so you can press it to merge a single
record. here is the website (download the file to see how
it wokrs)
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

(ps-it works with VB modules)

Good Luck.

Ilan

>-----Original Message-----
>i dont know i posted also - if i find out i'll let you
[quoted text clipped - 29 lines]
>>
>.

Reply to this Message

Peter Jamieson - 23 Jul 2004 09:51 GMT

Certain types of query/table do not show up when you are connecting using
OLEDB (the default method in Word 2002/2003) or ODBC. For example,
a. UNION queries
b. parameter queries
c. queries containing user-defined functions
d. queries containing certain predefined functions (Mainly financial, I
think)

Your best bet, assuming you actually have Access on the machine, is to
change the connection method to DDE (check Word
Tools|Options|General|"Confirm conversions at open", go through the
connection process again, and select DDE as the connection method.

Signature

Peter Jamieson

> Using an Access DB which is link to a SQL server DB. The
> link files do not show up in the merge to be selected.
> Though some of the queries that use the link files show
> up. Not all of the queries show up - why?

Reply to this Message