PC Review


Reply
Thread Tools Rate Thread

Access Macro links to Word Template - NEED TO UPDATE DATA - HELP

 
 
pipers4323
Guest
Posts: n/a
 
      3rd Dec 2009
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!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filling Word Template with Access Data =?Utf-8?B?Q2FyeWw=?= Microsoft Access 1 9th Jul 2007 04:56 PM
Exporting data from Access into a Word template =?Utf-8?B?TVNNb25rZXk=?= Microsoft Access External Data 0 28th Sep 2006 12:05 PM
export excel data to a word template using a macro =?Utf-8?B?Um9zczE=?= Microsoft Excel Programming 1 25th Mar 2005 04:31 AM
Exporting Data From Access To a Word Template Heather Irvin Microsoft Access Form Coding 4 25th Sep 2003 01:23 PM
Exporting Data From Access To a Word Template Heather Irvin Microsoft Access Macros 4 25th Sep 2003 01:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:42 PM.