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

[Chris K]

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??

 

[David W. Fenton]

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).

 

[Chris K]

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

 

[Doug Robbins - Word MVP]

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

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

 

[Chris K]

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

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

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

 

[Lisa Wilke-Thissen]

Hi Chris,

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