G
Guest
Hi all,
I want to create a new Word document base on my template from within Access
form. Any ideas will be appreciated.
I want to create a new Word document base on my template from within Access
form. Any ideas will be appreciated.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
pietlinden
Khoa said:Hi all,
I want to create a new Word document base on my template from within Access
form. Any ideas will be appreciated.
Within a form? here's a link to open the template through Access...
http://www.mvps.org/access/modules/mdl0043.htm
then I guess you could stick it into an unbound OLE control...
G
Guest
Thanks. I've tried to copy code from the link, create a Merge.dot in default
template folder, etc ... But when I click the Command1 button, I get the
Msgbox: "Compile error ; User-defined type not defined". I tried both Access
2000 and Access 2002. For more info, when I use the Command Button Wizard to
open MS Word, this is the sample code:
'---------------------------------------
Private Sub Command2_Click()
On Error GoTo Err_Command2_Click
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
Exit_Command2_Click:
Exit Sub
Err_Command2_Click:
MsgBox Err.Description
Resume Exit_Command2_Click
End Sub
'-----------------------------------------
Thanks for your concern
template folder, etc ... But when I click the Command1 button, I get the
Msgbox: "Compile error ; User-defined type not defined". I tried both Access
2000 and Access 2002. For more info, when I use the Command Button Wizard to
open MS Word, this is the sample code:
'---------------------------------------
Private Sub Command2_Click()
On Error GoTo Err_Command2_Click
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
Exit_Command2_Click:
Exit Sub
Err_Command2_Click:
MsgBox Err.Description
Resume Exit_Command2_Click
End Sub
'-----------------------------------------
Thanks for your concern