I have an Access database. I run a macro that opens a Word document with
merge fields already in the Word document. In spite of the fact that I have
saved the data source in the Word file (I thought), Word asks which query,
in the database, to load. I can understand that since I have two separate
queries for two separate documents and I guess Word just needs to verify
which one goes with which document.
Is there any way to pass the query along with the Word document so the end
user doesn't have to make that choice? I just want them to click the
Switchboard button and have the Word document open to the correct query.
Thanks,
John Orban
The Country School
Easton, MD
Peter Jamieson - 24 Feb 2004 08:31 GMT
Which version of Word (and Access) is this?
If you open the Word document manually in Word (i.e. without going via
Access) does it ask for the data source?
You can always consider getting your Access macro to automate Word and open
the correct query using OpenDataSource.
--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/
> I have an Access database. I run a macro that opens a Word document with
> merge fields already in the Word document. In spite of the fact that I have
[quoted text clipped - 12 lines]
> The Country School
> Easton, MD