create word document form a record in a form

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Hi see below

Dim AppWord As New Word.Application

AppWord.Documents.Add "\\server\db_files\Templates\~BQPO.dot"

With AppWord
..ActiveDocument.ShowSpellingErrors = False

..Selection.GoTo wdGoToBookmark, Name:="bmkDesc"
If IsNull(Me!subformPurchaseDetail!Description) Then
..Selection.TypeText ""
Else:
..Selection.TypeText Me!subformPurchaseDetail!Description
End If
AppWord.Visible = True

End With

Hi

I am using this code to create a word document from the field data of an
access form using bookmarks in a word template. The form contains one record
from the purchase table however the purchase detail subform can have several
records from the purchase details table. This code will only show the first
entry of the descrition field in this subform in the word document. This
there any easy way of modifying the code so that it picks up the other
description entries. Hope this makes sense.


Thanks

Matt
 
I'M HAVING A PROBLEM WITH SETTING UP MY WINDOWS MAIL FROM MY LAPTOP THAT HAS
WIRELESS INTERNET BUILT IN TO IT. CAN SOMEONE HELP ME WITH THAT PROBLEM.
PLUS I NEED THE PROGRAM OF MICROSOFT OFFICE 2007 IN ENGLISH FORM. I HAVE THE
SPANISH VERISON THAT A PASTOR LET ME DOWNLOAD INTO MY LAPTOP AND THERE IS NO
TRANSLATION VERISON PROGRAM FOR IT.
 
Wrong group.
Try alt.I.have.pirated.software.



Michael said:
I'M HAVING A PROBLEM WITH SETTING UP MY WINDOWS MAIL FROM MY LAPTOP
THAT HAS WIRELESS INTERNET BUILT IN TO IT. CAN SOMEONE HELP ME WITH
THAT PROBLEM. PLUS I NEED THE PROGRAM OF MICROSOFT OFFICE 2007 IN
ENGLISH FORM. I HAVE THE SPANISH VERISON THAT A PASTOR LET ME
DOWNLOAD INTO MY LAPTOP AND THERE IS NO TRANSLATION VERISON PROGRAM
Click to expand...
 
Back
Top