How do I get to VBA Code in a Word doc?

[Kevin]

I know little about mail merge. I took over an mdb that has many mail merge
docs associated with it. The same mdb has many people using it, so it locks
up. I know how to fix the lock issue, however I need to change the path of
the data source the word docs use as a data source. When I use the GUI tool
in Word, I can't change the data source and get it all to work. Can I go
into VBA on a Word.doc and type in the correct path, table names and queries
to use? This was built by someone else who was a Word/Excel wiz but knew
little about Access. I would have done it through reports and never touched
Word. I want to fix the lock up issue but can't without altering the Word
docs.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?S2V2aW4=?=,

Which version of Word is involved, here?

Are you referring to the default folder Word goes to when one uses a command to
link a Word document to the data source? Or something else?

I know little about mail merge. I took over an mdb that has many mail merge
docs associated with it. The same mdb has many people using it, so it locks
up. I know how to fix the lock issue, however I need to change the path of
the data source the word docs use as a data source. When I use the GUI tool
in Word, I can't change the data source and get it all to work. Can I go
into VBA on a Word.doc and type in the correct path, table names and queries
to use? This was built by someone else who was a Word/Excel wiz but knew
little about Access. I would have done it through reports and never touched
Word. I want to fix the lock up issue but can't without altering the Word
docs.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

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

 

[Kevin]

It's Word 2000.

It's not the default folder. It's the folder the data resides in (the mdb).
I want to change the path where the data resides. The GUI option, following
Word's prompts to locate the data source, don't allow me to select the
correct query. The query the original programmer used exists but isn't
selectable. I want to go behind the scenes and tell Word what to do.

Thanks-Kevin