Access 2003 Query to Word 2003

[hbaggs]

I am wanting to merge data from a specific record in Access. I have created a query in which I have placed a parameter in the criteria [Enter a file Number] in the appropriate field in the query. The query works properly.
I have then merged it with Word and selected an existing document. Unfortunately my recipients are shown as being from the actual database rather than from the specific query and then the whole process fails.
However if I remove the criteria in the Access query and perform the same processes I do get the desired result excepting that I get 2 thousand results because I get every record....not just the one record I need.
Why will Word not link to that specific record if it saved in the query.
I have been following this process in more than 100 other Word 2000 and Access 2000 queries and when I converted and upgraded to 2003 they all stopped working. Is there any quick fix for such a problem or do I have to resave all my queries and word documents again?
thanx

 

[Adrianna]

Word 2003 Allows you to create your query or filter inside of Word as well, so when you design the mail merge, you can implement the file number selection there.
If your users have access to the database, then just provide them a form to input their "file number" and then use an embedded report, Access report, or launch Word from access. I would try doing the filtration in word first.

 

[hbaggs]

query problem

Thank you for your advice.
I really want to be able to select the particular letter from within Access and start an inatnce of Word which then uses the existing Access query which is set to locate a particular record thru the criteria input to populate the letter with the correct data. I have been doing this quite successfully in Access and Word 2000 so I have presumed the same would apply.
I have a hundred of these preset letters which extracts the data from my database and merges the data into a word document. This is not the typical mail merge use for a long list of recipients as our use is usually for a single recipient.
Has anyone any ideas?
Thanx

 

[Adrianna]

So, at the moment you're using a form to launch Word 2003 and prompt the user for the criteria field? Is it pulled from a form? If you provide the user with the ability to provide the criteria prior to the merge, then I would assue that you can declare the parameter and then make the data connection.

Id like to try this myself as I haven't used Access/Word merges in the past 4 years, so I'm pretty rusty myself. My SQL Server is down at the moment for maintenance, or I'd test this theory.

If I get a chance...I'll post again!

 

[hbaggs]

Yes basically thats the idea. A command button on an Access form calls a particular word document which runs an instance of word and the word document has as its data source an access query which has a criteria required i.e. a file number which then gets just that record and merges it all into a single letter/document which we then print and send to the client.
As I mentioned- all works beautifully in Word and Access2000.
Is there some sort of setup needed for me to be able to see a list of queries in the source data wher at the moment I can only see tables when trying to create a word merge document with a data source.?
Thanx