missing query bug?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JethroUK - 27 Oct 2005 08:53 GMT

tired to connect a document to an access database and the window only a
shows the tables and one query (the 2 other database queries are not shown)

so i can't connect the doc to the query it needs - is this a bug?

Reply to this Message

JethroUK - 27 Oct 2005 15:33 GMT

Have investigated the bug - Microsoft Word won't merge with some Access
queries ?????????????

Assumed it was a software suite - You should be alright if you dont use any
criteria - stick to the simple criteria in Word only

Only been using the tool about 10 seconds and it is already falling apart at
the seems - obviously not for professional use

> tired to connect a document to an access database and the window only a
> shows the tables and one query (the 2 other database queries are not
> shown)
>
> so i can't connect the doc to the query it needs - is this a bug?

Reply to this Message

Doug Robbins - Word MVP - 27 Oct 2005 19:25 GMT

What sort of criteria are you talking about, I have used select queries
with criteria that controls which records from the table are returned by the
query as the datasource for mailmerges hundreds of the times.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Have investigated the bug - Microsoft Word won't merge with some Access
> queries ?????????????
[quoted text clipped - 10 lines]
>>
>> so i can't connect the doc to the query it needs - is this a bug?

Reply to this Message

JethroUK© - 27 Oct 2005 21:03 GMT

The query criteria is from a form e.g.

[Forms]![Form1]![Control]

query on it's own works fine - just M.S. Word mailmerge won't see it as a
datasource (doesn't even appear in the database tables/queries window as a
datasource) unless i remove the criteria - i assume the sql statement is too
complex for it

i tried removing the criteria - attaching it as a datasource - replacing the
criteria - but mailmerge doc just loses it as a datasource & of course you
can't re-attach it

i did a google and discovered that others have already noticed that word
cant/wont see some Access queries

is it possible to pass just the 'where' part of the sql statement direct to
the mailmerge doc (hence bypassing the need for a form.control to store it)?

> What sort of criteria are you talking about, I have used select queries
> with criteria that controls which records from the table are returned by the
[quoted text clipped - 22 lines]
> >>
> >> so i can't connect the doc to the query it needs - is this a bug?

Reply to this Message

Doug Robbins - Word MVP - 28 Oct 2005 05:04 GMT

I would guess that you are running up against the same "issue" that occurs
in Access when you open such a query when the Form is not open.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> The query criteria is from a form e.g.
>
[quoted text clipped - 48 lines]
>> >>
>> >> so i can't connect the doc to the query it needs - is this a bug?

Reply to this Message

JethroUK - 28 Oct 2005 08:08 GMT

i've already tried it both with the form open and closed - either way the
query does not appear as a possible mailmerge datasource

the database isn't populated yet (handful records) & i seemed to remember an
option not to show empty records/recordset - that might be the problem -
would you know of such an option?

>I would guess that you are running up against the same "issue" that occurs
>in Access when you open such a query when the Form is not open.
[quoted text clipped - 55 lines]
>>> >>
>>> >> so i can't connect the doc to the query it needs - is this a bug?

Reply to this Message

Doug Robbins - Word MVP - 28 Oct 2005 10:51 GMT

From the Tools menu, select Options and then on the General tab, check the
box for "Confirm conversions at open" and then try the different connection
methods that will be offered when you attach the data source to the main
document.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> i've already tried it both with the form open and closed - either way the
> query does not appear as a possible mailmerge datasource
[quoted text clipped - 65 lines]
>>>> >>
>>>> >> so i can't connect the doc to the query it needs - is this a bug?

Reply to this Message