Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kevin - 23 Aug 2005 22:14 GMT
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- - 24 Aug 2005 09:06 GMT
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
[quoted text clipped - 6 lines]
> 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 - 24 Aug 2005 21:55 GMT
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

> Hi =?Utf-8?B?S2V2aW4=?=,
>
[quoted text clipped - 21 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail :-)

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.