|
 |
access thread: mail merging into word
Message #1 by Robert Stein <Robert.Stein@B...> on Tue, 25 Sep 2001 22:22:28 +1000
|
|
Hi group,
This may seem a simple question but I am having alot of trouble with it.
I want to merge only one record in MS word from Access. I tried restricting
the query by making it refer to the ID of the record on the Access form.
so my query criteria is something like ID = forms![form name]!txtID
This works fine for Access 97 and word 97,
but with Access 2k and Word 2k, word seems to open another instance of A2k
and then it doesn't know which is the current record!
I get the query parameter box appearing asking for the a value for
forms![form name]!txtID !!!
Does anyone have any suggestions to work around this problem for A2k??
Thanks in advance and I hope you can understand what I mean.
Robert
Message #2 by "Arjan v. Huizen" <ajvhzn@p...> on Wed, 26 Sep 2001 22:55:36 +0200
|
|
Hello. I'm not sure about this. But do you open MS Word from within Access?
Or vice versa?
Because when you fist open Word and than Access, it could cause trouble. But
not reverse I think!
Ps. include the Open word or Open Access code.
Arjan.
.
----- Original Message -----
From: Robert Stein <Robert.Stein@B...>
To: Access <access@p...>
Sent: Tuesday, September 25, 2001 2:22 PM
Subject: [access] mail merging into word
> Hi group,
>
> This may seem a simple question but I am having alot of trouble with it.
> I want to merge only one record in MS word from Access. I tried
restricting
> the query by making it refer to the ID of the record on the Access form.
> so my query criteria is something like ID = forms![form name]!txtID
> This works fine for Access 97 and word 97,
> but with Access 2k and Word 2k, word seems to open another instance of A2k
> and then it doesn't know which is the current record!
> I get the query parameter box appearing asking for the a value for
> forms![form name]!txtID !!!
> Does anyone have any suggestions to work around this problem for A2k??
>
> Thanks in advance and I hope you can understand what I mean.
> Robert
Message #3 by Brian Skelton <brian.skelton@b...> on Thu, 27 Sep 2001 00:15:49 +0100
|
|
Hi Robert
There's a known bug in Access 97 that causes this to happen, although
you describe your problem as happening when you upgraded to 2000 it
might be worth a look at Knowledgebase article Q199963.
If thats not helpful, and you only ever need to merge a single record to
a document, consider using automation code along with a Word template
containing bookmarks. This article gives some sample code Q210271.
Hope this helps.
-BDS
|
|
|
View Cart
