Home |
Search |
Today's Posts |
#1
|
|||
|
|||
inserting ACCESS fields in a word document
I have a WORD letter I use each month. The name of the person to whom it is
directed changes frequently in this (and other letters). Is there a way to get a field(s) from an ACCESS table - possibly in a drop down box - to insert in the letter when I get ready to print it? I'm sure it is possible, but frankly the info provided by WORD help is not a lot of use. In addition, what is the best "text" book on WORD 2000 available in bookstores. Dot |
#2
|
|||
|
|||
See the article "How to create a
Userform" at: http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm The the following routine will populate a listbox or combobox with data from an Access database Private Sub UserForm_Initialize() Dim db As DAO.Database Dim rs As DAO.Recordset Dim NoOfRecords As Long ' Open the database Set db = OpenDatabase("D:\Access\ResidencesXP.mdb") ' Retrieve the recordset Set rs = db.OpenRecordset("SELECT * FROM Owners") ' Determine the number of retrieved records With rs .MoveLast NoOfRecords = .RecordCount .MoveFirst End With ' Set the number of Columns = number of Fields in recordset ListBox1.ColumnCount = rs.Fields.Count ' Load the ListBox with the retrieved records ListBox1.Column = rs.GetRows(NoOfRecords) ' Cleanup rs.Close db.Close Set rs = Nothing Set db = Nothing End Sub -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "DOGMA-DOT" wrote in message news I have a WORD letter I use each month. The name of the person to whom it is directed changes frequently in this (and other letters). Is there a way to get a field(s) from an ACCESS table - possibly in a drop down box - to insert in the letter when I get ready to print it? I'm sure it is possible, but frankly the info provided by WORD help is not a lot of use. In addition, what is the best "text" book on WORD 2000 available in bookstores. Dot |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please give us REVEAL CODES like WORD PERFECT not reveal codes in. | Microsoft Word Help | |||
Envelope Address | New Users | |||
1st word in heading flush left second word flush right | New Users | |||
Word Document: merging a lot of info from Access | Mailmerge | |||
letters - ask/fillin | New Users |