Word2003: Some Query's of Access2003 not seen in the mailmerge wizard.

[Jan Verstraeten]

Hi,

When I try to use query's (created in access) to create a mailmerge in
word2003, the wizard don't see most of the query's created in access.
All query's where the Nz function is used (ex: Total:
Nz([price])-Nz([reduction]) ... where "price" and "reduction" is a field
in a tabel ) is NOT seen in the wizard.
So a mailmerge is not possible.
When I delete the field's where this functions are used the query is seen by
the wizard.
When I don't use the Nz function my query is not working fine ... so ...
(maybe I need do investigate why?? ... but this is created a long time ago)

Ps: This is after I did a update from Office2000 to Office2003 (Using the
same database)

Greetings,

Jan

 

[Peter Jamieson]

Hi Jan,

This problem started in Word 2002. Some built-in functions cause queries to
be invisible or unusable when you connect using either OLEDB or ODBC. The
simplest workaround is probably to check Word Tools|Options|General|"Confirm
conversions at open", go through the datsource connection process again, and
choose the DDE option when you are asked for the connection method. And you
will probably have to wade throuh the barrage of questions you get when you
try to open anything these days.

I can't see why the Nz function causes this problem as it doesn't appear
dangerous in any way. However, as far as I can see so far, the problem does
not seem to have anything to do with the prompts about the Jet 4.0
expression service and Jet 4 SP8 that I see when I try to open Access
databases in Access 2003.

 

[Jan Verstraeten]

Peter, ...

Tray to do this ...
chose to open (a test copy) the database in DDE format.

This give a error "This task is taking longer than expected. Do you want to
continue waiting"
You can wait for a long time.

So I converted the database in Access 2003 file format (was still in Access
2000 file format)
Again run the test ... same error.

Indeed, the problem started in word 2002 (I downgraded the soft unit
word2002 and had the same problem)

Greetings

Jan

Hi Jan,

This problem started in Word 2002. Some built-in functions cause queries to
be invisible or unusable when you connect using either OLEDB or ODBC. The
simplest workaround is probably to check Word Tools|Options|General|"Confirm
conversions at open", go through the datsource connection process again, and
choose the DDE option when you are asked for the connection method. And you
will probably have to wade throuh the barrage of questions you get when you
try to open anything these days.

I can't see why the Nz function causes this problem as it doesn't appear
dangerous in any way. However, as far as I can see so far, the problem does
not seem to have anything to do with the prompts about the Jet 4.0
expression service and Jet 4 SP8 that I see when I try to open Access
databases in Access 2003.

--
Peter Jamieson
MS Word MVP

Hi,

When I try to use query's (created in access) to create a mailmerge in
word2003, the wizard don't see most of the query's created in access.
All query's where the Nz function is used (ex: Total:
Nz([price])-Nz([reduction]) ... where "price" and "reduction" is a field
in a tabel ) is NOT seen in the wizard.
So a mailmerge is not possible.
When I delete the field's where this functions are used the query is

seen

by
the wizard.
When I don't use the Nz function my query is not working fine ... so ...
(maybe I need do investigate why?? ... but this is created a long time ago)

Ps: This is after I did a update from Office2000 to Office2003 (Using the
same database)

Greetings,

Jan

 

[Peter Jamieson]

My best guess is that Access is displaying a dialog box "behind" Word and
you need to use Alt-tab to switch to it and respond.

--
Peter Jamieson
MS Word MVP

Peter, ...

Tray to do this ...
chose to open (a test copy) the database in DDE format.

This give a error "This task is taking longer than expected. Do you want to
continue waiting"
You can wait for a long time.

So I converted the database in Access 2003 file format (was still in Access
2000 file format)
Again run the test ... same error.

Indeed, the problem started in word 2002 (I downgraded the soft unit
word2002 and had the same problem)

Greetings

Jan

Hi Jan,

This problem started in Word 2002. Some built-in functions cause queries to
be invisible or unusable when you connect using either OLEDB or ODBC. The
simplest workaround is probably to check Word Tools|Options|General|"Confirm
conversions at open", go through the datsource connection process again, and
choose the DDE option when you are asked for the connection method. And you
will probably have to wade throuh the barrage of questions you get when you
try to open anything these days.

I can't see why the Nz function causes this problem as it doesn't appear
dangerous in any way. However, as far as I can see so far, the problem does
not seem to have anything to do with the prompts about the Jet 4.0
expression service and Jet 4 SP8 that I see when I try to open Access
databases in Access 2003.

--
Peter Jamieson
MS Word MVP

Hi,

When I try to use query's (created in access) to create a mailmerge in
word2003, the wizard don't see most of the query's created in access.
All query's where the Nz function is used (ex: Total:
Nz([price])-Nz([reduction]) ... where "price" and "reduction" is a field
in a tabel ) is NOT seen in the wizard.
So a mailmerge is not possible.
When I delete the field's where this functions are used the query is

seen

by
the wizard.
When I don't use the Nz function my query is not working fine ... so ....
(maybe I need do investigate why?? ... but this is created a long time ago)

Ps: This is after I did a update from Office2000 to Office2003 (Using the
same database)

Greetings,

Jan