P
pipers4323
Hi,
I hope this is the right section. We currently have an Access database
managing our inventory. When you need to generate a Sales Invoice you click
on a button that launches this Macro:
Private Sub SalesInvoice_Click()
On Error GoTo Err_SalesInvoice_Click
Dim stDocName As String
stDocName = "frmSalesInvoice"
DoCmd.OpenForm stDocName, acNormal
Exit_SalesInvoice_Click:
Exit Sub
Err_SalesInvoice_Click:
MsgBox Err.Description
Resume Exit_SalesInvoice_Click
End Sub
The macro then links to a Word template that pulls all the data from the
Access table and populates the Invoice in word.
I need to update the Invoice by removing one field and replacing it with a
new field. I have added the new field to our main table but I can't get it
to show up in the Word document. I have tried to edit the template and
replace the field name but no luck.
I am not very Access savy and could really use some help with this. Oh, and
I am using Access 2007 and Word 2007 on a Windows 32bit Vista Home Preimum OS
Thanks!
I hope this is the right section. We currently have an Access database
managing our inventory. When you need to generate a Sales Invoice you click
on a button that launches this Macro:
Private Sub SalesInvoice_Click()
On Error GoTo Err_SalesInvoice_Click
Dim stDocName As String
stDocName = "frmSalesInvoice"
DoCmd.OpenForm stDocName, acNormal
Exit_SalesInvoice_Click:
Exit Sub
Err_SalesInvoice_Click:
MsgBox Err.Description
Resume Exit_SalesInvoice_Click
End Sub
The macro then links to a Word template that pulls all the data from the
Access table and populates the Invoice in word.
I need to update the Invoice by removing one field and replacing it with a
new field. I have added the new field to our main table but I can't get it
to show up in the Word document. I have tried to edit the template and
replace the field name but no luck.
I am not very Access savy and could really use some help with this. Oh, and
I am using Access 2007 and Word 2007 on a Windows 32bit Vista Home Preimum OS
Thanks!