[mso] Re: Open Access OLE Word Doc as Template

  • From: Cathy.Evans@xxxxxxxxx
  • To: mso@xxxxxxxxxxxxx
  • Date: Thu, 18 Dec 2003 16:54:39 -0500

Sorry to be so long in reply, this project got temporarily put aside for
other workload.  Are you talking about the Document_Open of Microsoft Word
or on the Microsoft Access side.  My explanation was bad, it's not the
opening as a doc that is a problem, it's that when Access opens the Word
document it opens the template as if you were opening from the file/open
menu in Word instead of opening as file/new.  This causes the automation in
the form to not activate.  I'm not finding on the Access side how to
accomplish this and do not know visual basic on the Word side.  I am barely
making my way through learning Access code by trial and error, so I'm
needing help on the Access side if possible, cause I am very lost in Word.
Also, I've got merge fields in some of the Word forms I'm using that feed
from the Access side, however, is there a way to pass that field data into
the Word form when you open it, thereby doing away with the merge and still
accomplishing the data portion.  Thank you, Cathy


                                                                                
                                    
                    "Dian Chapman"                                              
                                    
                    <dian@mousetrax      To:     <mso@xxxxxxxxxxxxx>            
                                    
                    .com>                                                       
                                    
                    Sent by:             cc:                                    
                                    
                    mso-bounce@free                                             
                                    
                    lists.org            Subject:     [mso] Re: Open Access OLE 
Word Doc as Template                
                    12/14/2003                                                  
                                    
                    04:47 AM                                                    
                              ..... 
                    Please respond                                              
                                    
                    to mso                                                      
                                    
                                                                                
                                    
                                                                                
                                    




Templates are SUPPOSED to open as docs. Just add the automation into the
Document_New event to get it to fire properly. It's probably in the
Document_Open or Auto_Open/Exec events. It should be in the Document_New
event.


Dian D. Chapman
Technical Consultant,
Microsoft MVP & Instructor

Free Tutorials: www.mousetrax.com/techtrax
Free Word Tips & Tricks eBook: www.mousetrax.com/books.html
Learn VBA the easy way, thru video! www.mousetrax.com/techcourses.html




-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Cathy.Evans@xxxxxxxxx
Sent: Sunday, December 14, 2003 12:35 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Open Access OLE Word Doc as Template


Hello, I have an Access 97 database with linked .dot forms.  Clicking the
link opens them in Word as documents, not templates, causing loss of the
automation built into the forms.  Have tried embedding as OLE instead of
link but it still opens .dot as .doc.  Have been searching the net for code
solutions but no answers. Can anyone help?  Thank you! :)




-----------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person
or entity to which it is addressed and may contain confidential
and/or privileged material. If you are not the intended recipient 
of this message you are hereby notified that any use, review,
retransmission, dissemination, distribution, reproduction or any
action taken in reliance upon this message is prohibited. If you 
received this in error, please contact the sender and delete the 
material from any computer.  Any views expressed in this message
are those of the individual sender and may not necessarily reflect 
the views of the company.  
-------------------------------------------------------------------------------------------------------

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: