?
Solved

How to open Word templates from Access

Posted on 2008-10-22
3
Medium Priority
?
775 Views
Last Modified: 2013-11-27
I want Access to open a document as a blank using a template I define. Right now I have this code and it works and it opens the correct document, but if I work it as a *.dot ( Word template), then it opens the template for editing, not a blank document.

How can I open the template as a blank, like when you do Word manually?

>>>
    Dim word As word.Application
   
    Set word = CreateObject("Word.Application")
    word.Visible = True
    word.Documents.Open ("\\ctx\Joblog\Word Docs\STATECOMPLIANCE blank.doc")
0
Comment
Question by:onepiolin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
Jupiler78 earned 2000 total points
ID: 22779487
Hello onepiolin,

you should use:
word.documents.add()
the first param then is: The name of the template to be used for the new document. If this argument is omitted, the Normal template is used
the second: True to open the document as a template. The default value is False

Regards,

Jupiler78
0
 
LVL 16

Expert Comment

by:Sheils
ID: 22780021
The is a good easy mail merge that you can incorporate into your database.

http://www.members.shaw.ca/AlbertKallal/wordmerge/index.html

0
 
LVL 8

Expert Comment

by:Jupiler78
ID: 22802132
Glad I could help.
Thanks for the points & grade.
Good luck.

Jupiler78
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Course of the Month8 days, 22 hours left to enroll

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question