Inser Access Query in Word 2000 vs 2003

[Bu]

Hello,

Under Word/Access 2000 i used a query to input Access data into into a
Word document (joining).
In the Access query i had a criteria for wich a message box opened so
i could input the selection criteria. So when i opened the Word
document the criteria message box popped up.

This works fine if i copy both the joining Word document and the
Access database (including the query) onto a system with Office
professional 2003.

However when i make a new Word document in which i want to use the
same query it does not work. I do not get the possibility to select
the query.
When i remove the selection criteria from the query i can select the
query in the Word document and get access to the whole query. But this
is not i want because i want only selections.

Can somebody tell me where i go wrong or is there a difference between
Office 2000 and 2003?
Bu

 

[Guest]

Assuming you've created a new connection in the new Word document as well you
should be able to use the same query as well. How are you creating the
connectionstring to retrieve the query?

 

[Bu]

Assuming you've created a new connection in the new Word document as well you
should be able to use the same query as well. How are you creating the
connectionstring to retrieve the query?

The problem is that when i add a criteria in the query using a message
box (to input a value like: criteria is: =[input value]) i can not
establish a link/connection to that query from Word.
When i remove the criteria message box and make it a solid criteria
(like: criteriais: =5) or remove the criteria all together than i can
establish a link/connection in word!
Hope you have any suggestion

Bu

 

[Guest]

Bu,

Sorry for the late response. But I think that your inputbox is the one
creating the problem. The inputbox comes from Access. Why not create an
inputbox in word asking for the parameter and passing that back to your
query. That might mean that you have to create the query from code. If you
don't know how to let me knwo and I can help you further.

hth
--
Maurice Ausum

Assuming you've created a new connection in the new Word document as well you
should be able to use the same query as well. How are you creating the
connectionstring to retrieve the query?

The problem is that when i add a criteria in the query using a message
box (to input a value like: criteria is: =[input value]) i can not
establish a link/connection to that query from Word.
When i remove the criteria message box and make it a solid criteria
(like: criteriais: =5) or remove the criteria all together than i can
establish a link/connection in word!
Hope you have any suggestion

Bu

 

[Bu]

Bu,

Sorry for the late response. But I think that your inputbox is the one
creating the problem. The inputbox comes from Access.

I figured out that indeed the inputbox causes the problem (This is
only true in Word/Access 2003, in 2000 it works OK).

Why not create an
inputbox in word asking for the parameter and passing that back to your
query.

Thanks for the suggestion.
When i make the link in Word with the Access query (without the input
message box removed from the query) i can also make criteria rules.
The problem with this is that other users (computer layman) not easy
can work with this work around.

That might mean that you have to create the query from code. If you
don't know how to let me knwo and I can help you further.

Thanks for the offer but i will first try to do this myself.
Question remains. Why does it work in Office 2000 and not in 2003!?

Thanks for the reaction.
Bu