pre query query

[john dumas]

This is a different question

I am running the following to merge access records into word

ActiveDocument.MailMerge.OpenDataSource Name:= _
"C:\2003\westwooddb\westwood.mdb",
ConfirmConversions:=False, ReadOnly:= _
False, LinkToSource:=True, AddToRecentFiles:=False,
PasswordDocument:="", _
PasswordTemplate:="", WritePasswordDocument:="",
WritePasswordTemplate:= _
"", Revert:=False, Format:=wdOpenFormatAuto,
Connection:= _
"QUERY DoctorAndPatientNamesQuery", SQLStatement:= _
"SELECT * FROM [PatientNameQuery]", SQLStatement1:=""


Can I pre run the "QUERY DoctorAndPatientNamesQuery" query
and :
1. get how many or if any matches
2. save the inputs so they would not have to be re-imputed
this would annoy the user.

 

[Cindy Meister -WordMVP-]

Hi John,

From a discussion already in the list, I think you've
already solved your problem, but just in case you're still
looking for this

Can I pre run the "QUERY DoctorAndPatientNamesQuery" query
and :
1. get how many or if any matches

You could do this using a DAO or ADO connection to the data
source, before initiating the merge link.

2. save the inputs so they would not have to be re-imputed
this would annoy the user.

I don't follow what you mean, here.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail