I can not connect a word document to an access prompt query (e.g. includes
[What date was it booked?])

The query does not even appear in the list of connections

Is there any work around for this??

"Chris K" <(E-Mail Removed)> wrote in
news:vdZ7o.1635$L84.1383@hurricane:

> I can not connect a word document to an access prompt query (e.g.
> includes [What date was it booked?])
>
> The query does not even appear in the list of connections
>
> Is there any work around for this??

Likely the query has an Access function in it that is not accessible
from outside Access. Can you post the SQL of the Access query? That
way we can tell you what in it won't be accessible, and suggest
alternatives (if possible).

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

"David W. Fenton" <(E-Mail Removed)> wrote in message
news:Xns9DCFB471C4B21f99a49ed1d0c49c5bbb2@74.209.136.81...
> "Chris K" <(E-Mail Removed)> wrote in
> news:vdZ7o.1635$L84.1383@hurricane:
>
>> I can not connect a word document to an access prompt query (e.g.
>> includes [What date was it booked?])
>>
>> The query does not even appear in the list of connections
>>
>> Is there any work around for this??
>
> Likely the query has an Access function in it that is not accessible
> from outside Access. Can you post the SQL of the Access query? That
> way we can tell you what in it won't be accessible, and suggest
> alternatives (if possible).
>

SELECT JHPclients.[First Name], JHPclients.[Last Name], JHPclients.Booked
FROM JHPclients
WHERE (((JHPclients.Booked)=[What date are they Booked in?]))
ORDER BY JHPclients.[First Name];

Like I say, it's prompt query - where the database prompts for an entry

And that is why it cannot be used. How about initiating the mail merge from
Access, or use an Access report instead?

--
Hope this helps,

Doug Robbins - Word MVP
dkr[atsymbol]mvps[dot]org

"Chris K" <(E-Mail Removed)> wrote in message
news:hR%7o.71368$zT3.26703@hurricane...
>
>
> "David W. Fenton" <(E-Mail Removed)> wrote in message
> news:Xns9DCFB471C4B21f99a49ed1d0c49c5bbb2@74.209.136.81...
>> "Chris K" <(E-Mail Removed)> wrote in
>> news:vdZ7o.1635$L84.1383@hurricane:
>>
>>> I can not connect a word document to an access prompt query (e.g.
>>> includes [What date was it booked?])
>>>
>>> The query does not even appear in the list of connections
>>>
>>> Is there any work around for this??
>>
>> Likely the query has an Access function in it that is not accessible
>> from outside Access. Can you post the SQL of the Access query? That
>> way we can tell you what in it won't be accessible, and suggest
>> alternatives (if possible).
>>
>
> SELECT JHPclients.[First Name], JHPclients.[Last Name], JHPclients.Booked
> FROM JHPclients
> WHERE (((JHPclients.Booked)=[What date are they Booked in?]))
> ORDER BY JHPclients.[First Name];
>
> Like I say, it's prompt query - where the database prompts for an entry

Yes - it will have to be an access report i think - thanks

"Doug Robbins - Word MVP" <(E-Mail Removed)> wrote in message
news:i3q4dc$gv$(E-Mail Removed)...
> And that is why it cannot be used. How about initiating the mail merge
> from Access, or use an Access report instead?
>
> --
> Hope this helps,
>
> Doug Robbins - Word MVP
> dkr[atsymbol]mvps[dot]org
>
> "Chris K" <(E-Mail Removed)> wrote in message
> news:hR%7o.71368$zT3.26703@hurricane...
>>
>>
>> "David W. Fenton" <(E-Mail Removed)> wrote in message
>> news:Xns9DCFB471C4B21f99a49ed1d0c49c5bbb2@74.209.136.81...
>>> "Chris K" <(E-Mail Removed)> wrote in
>>> news:vdZ7o.1635$L84.1383@hurricane:
>>>
>>>> I can not connect a word document to an access prompt query (e.g.
>>>> includes [What date was it booked?])
>>>>
>>>> The query does not even appear in the list of connections
>>>>
>>>> Is there any work around for this??
>>>
>>> Likely the query has an Access function in it that is not accessible
>>> from outside Access. Can you post the SQL of the Access query? That
>>> way we can tell you what in it won't be accessible, and suggest
>>> alternatives (if possible).
>>>
>>
>> SELECT JHPclients.[First Name], JHPclients.[Last Name], JHPclients.Booked
>> FROM JHPclients
>> WHERE (((JHPclients.Booked)=[What date are they Booked in?]))
>> ORDER BY JHPclients.[First Name];
>>
>> Like I say, it's prompt query - where the database prompts for an entry
>

Hi Chris,

"Chris K" wrote

> Yes - it will have to be an access report i think - thanks

an Access report will be the best solution. But I think using DDE to
connect Access and Word should also work:
http://support.microsoft.com/kb/888697/en-us

--
Greetings
Lisa [MS MVP Word]