I’m creating a Word 2003 doc from Access 2003. I am using a Word template with bookmarks.
I need to add several tables to display data. What’s the best way to add data to tables?
Example of Table:
Sample Location Quantity
1 Kitchen 230SF
2 Den 300SF
3 Bath 100SF
Here is some VBA code in Access I have so far.
TIA
DougP, MCP, A+
I need to add several tables to display data. What’s the best way to add data to tables?
Example of Table:
Sample Location Quantity
1 Kitchen 230SF
2 Den 300SF
3 Bath 100SF
Here is some VBA code in Access I have so far.
Code:
Set objWord = CreateObject("Word.Application")
With objWord
.Visible = True
.Documents.Open (strDocPath)
'move to each bookmark, and insert correct text.
.ActiveDocument.Bookmarks("ProjectNumber").Select
.Selection.Text = (CStr(Forms!frmReport!txtProjectNumber))
.ActiveDocument.Bookmarks("WordyStuff").Select
.Selection.Text = (CStr(Forms!frmReport!txtWordyStuff))
.ActiveWindow.View.ShowBookmarks = True
End With
TIA
DougP, MCP, A+