Merging MS Word document with MS Access 2002 criteria query

[Shawnee]

I have created a document to pull data from my Access database. If I leave
the query in Access as a Select query with no criteria, Word pulls in the
data, but if I add a criteria statement to the query, Word cannot locate the
query to execute it. I have changed my general option to "confirm conversion
on open" to try to use DDE and that changes nothing.
HELP!!!!!!!!!!!!!!!!!!!!!

 

[Doug Robbins]

What is the criteria that you are using? I use select queries with criteria
on a daily basis without problems.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Shawnee]

What is the criteria that you are using? I use select queries with criteria
on a daily basis without problems.

-- Each offering of a course is called a section, and each section has a unique section number in my database. I want my user(s) to be able to pull the data for just a specific section, so the criteria statement is [type section no] and then the query pulls only the students who took that section.
Shawnee
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

I have created a document to pull data from my Access database. If I leave
the query in Access as a Select query with no criteria, Word pulls in the
data, but if I add a criteria statement to the query, Word cannot locate
the
query to execute it. I have changed my general option to "confirm
conversion
on open" to try to use DDE and that changes nothing.
HELP!!!!!!!!!!!!!!!!!!!!!

 

[Shawnee]

Any ideas yet? I want my users to open Word, open a document, the document
as a merge will open my database, the query in my database will ask for the
section number as criteria, then forward the pertinent data to the word
document. If I leave the criteria statement out of the query, Word and
Access merge beautifully. If I put the criteria statement back in the query,
the query is no longer visible. I have many documents created prior to
Access 2002 that use this process and work fine.

What is the criteria that you are using? I use select queries with criteria
on a daily basis without problems.

-- Each offering of a course is called a section, and each section has a unique section number in my database. I want my user(s) to be able to pull the data for just a specific section, so the criteria statement is [type section no] and then the query pulls only the students who took that section.
Shawnee
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

I have created a document to pull data from my Access database. If I leave
the query in Access as a Select query with no criteria, Word pulls in the
data, but if I add a criteria statement to the query, Word cannot locate
the
query to execute it. I have changed my general option to "confirm
conversion
on open" to try to use DDE and that changes nothing.
HELP!!!!!!!!!!!!!!!!!!!!!

 

[Doug Robbins]

From the Tools menu in Word, select Options and then go to the General tab
and check the box against Confirm Conversions at Open and then when you
attach the data source, use DDE as the connection method.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

Any ideas yet? I want my users to open Word, open a document, the
document
as a merge will open my database, the query in my database will ask for
the
section number as criteria, then forward the pertinent data to the word
document. If I leave the criteria statement out of the query, Word and
Access merge beautifully. If I put the criteria statement back in the
query,
the query is no longer visible. I have many documents created prior to
Access 2002 that use this process and work fine.

What is the criteria that you are using? I use select queries with
criteria
on a daily basis without problems.

-- Each offering of a course is called a section, and each section has
a unique section number in my database. I want my user(s) to be able
to pull the data for just a specific section, so the criteria statement
is [type section no] and then the query pulls only the students who
took that section.
Shawnee
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
I have created a document to pull data from my Access database. If I
leave
the query in Access as a Select query with no criteria, Word pulls in
the
data, but if I add a criteria statement to the query, Word cannot
locate
the
query to execute it. I have changed my general option to "confirm
conversion
on open" to try to use DDE and that changes nothing.
HELP!!!!!!!!!!!!!!!!!!!!!

 

[Shawnee]

As I exlained in my original post, I have already used this suggestion and it
didn't change a thing, other than ask me to select the connection, and when I
select DDE Word and Access still won't communicate as long as I have a
parameter in the Access query.

Shawnee

From the Tools menu in Word, select Options and then go to the General tab
and check the box against Confirm Conversions at Open and then when you
attach the data source, use DDE as the connection method.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

Any ideas yet? I want my users to open Word, open a document, the
document
as a merge will open my database, the query in my database will ask for
the
section number as criteria, then forward the pertinent data to the word
document. If I leave the criteria statement out of the query, Word and
Access merge beautifully. If I put the criteria statement back in the
query,
the query is no longer visible. I have many documents created prior to
Access 2002 that use this process and work fine.

:

What is the criteria that you are using? I use select queries with
criteria
on a daily basis without problems.

-- Each offering of a course is called a section, and each section has
a unique section number in my database. I want my user(s) to be able
to pull the data for just a specific section, so the criteria statement
is [type section no] and then the query pulls only the students who
took that section.

Shawnee
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
I have created a document to pull data from my Access database. If I
leave
the query in Access as a Select query with no criteria, Word pulls in
the
data, but if I add a criteria statement to the query, Word cannot
locate
the
query to execute it. I have changed my general option to "confirm
conversion
on open" to try to use DDE and that changes nothing.
HELP!!!!!!!!!!!!!!!!!!!!!

 

[Shawnee]

You replied that you use parameter queries every day with no problem--are you
using them to populate a Word document? I use parameter queries all the time
in my database and the Word documents I created before Office XP that get
populated by parameter queries still work even after my XP installation, but
any documents created since the XP installation cannot find parameter queries
in my database.

From the Tools menu in Word, select Options and then go to the General tab
and check the box against Confirm Conversions at Open and then when you
attach the data source, use DDE as the connection method.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

Any ideas yet? I want my users to open Word, open a document, the
document
as a merge will open my database, the query in my database will ask for
the
section number as criteria, then forward the pertinent data to the word
document. If I leave the criteria statement out of the query, Word and
Access merge beautifully. If I put the criteria statement back in the
query,
the query is no longer visible. I have many documents created prior to
Access 2002 that use this process and work fine.

:

What is the criteria that you are using? I use select queries with
criteria
on a daily basis without problems.

-- Each offering of a course is called a section, and each section has
a unique section number in my database. I want my user(s) to be able
to pull the data for just a specific section, so the criteria statement
is [type section no] and then the query pulls only the students who
took that section.

Shawnee
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
I have created a document to pull data from my Access database. If I
leave
the query in Access as a Select query with no criteria, Word pulls in
the
data, but if I add a criteria statement to the query, Word cannot
locate
the
query to execute it. I have changed my general option to "confirm
conversion
on open" to try to use DDE and that changes nothing.
HELP!!!!!!!!!!!!!!!!!!!!!