MS Access froms creating Word Docs

Peter B · 10-06-2009 9:28pm #1

Just wondering is it possible to code forms and buttons in forms in MS Access to create word document files from a template?

I reckon it must be possible, do you have to create macros?

cracker · 11-06-2009 8:38am

You can certainly do it using VBA. You just need to enable the MS Word object library and it will give you access to all the methods and properties that you need.
Open up the vba editor and choose tools -> references and then select the Microsoft Word Object library (version 11 is word 2003 I think). Then start coding. Something like this. The Documents.add method allows you to specify a template.

Public Sub test()

    Dim wordApp As New Word.Application
    
    wordApp.Visible = True
    
    
    
    Dim objDoc As Word.Document
    
    Set objDoc = wordApp.Documents.Add
    
    
    objDoc.Save
    
    objDoc.Close
    
    wordApp.Quit
    
    Set objDoc = Nothing
    Set wordApp = Nothing
    
End Sub

MS Access froms creating Word Docs

Comments