Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2005

Tip: Looking for answers? Try searching our database.

Populate Table from Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MTechG - 15 Dec 2005 17:57 GMT
I've got a template document I'm setting up and would like to populate a
table from Access.  I already populated fields inside the template from
Access with VBA.  Using Word/Access XP

Any hints?

TIA
Doug Robbins - Word MVP - 15 Dec 2005 22:13 GMT
What do you want to populate the table with? - Data from a single record? -
Data from Multiple Records? - Data from all of the Records? - of just some
of them?  If the latter, what is the criteria for selecting the ones from
which the data is to be used?

Sorry, more questions than answers.

Signature

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

> I've got a template document I'm setting up and would like to populate a
> table from Access.  I already populated fields inside the template from
[quoted text clipped - 3 lines]
>
> TIA
MTechG - 15 Dec 2005 22:24 GMT
Doug

I'm looking to populate the table with multiple records for a query.  I
tried mail merge and I have six records that are in the query now and I add
the field project in the table and the document is created six times.  From
what I've been reading I believe it can be done in mail merge it's just I'm
doing something wrong.

Dennis

> What do you want to populate the table with? - Data from a single record? -
> Data from Multiple Records? - Data from all of the Records? - of just some
[quoted text clipped - 10 lines]
> >
> > TIA
Doug Robbins - Word MVP - 16 Dec 2005 05:30 GMT
Why not use an Access Report?

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Articles

http://support.microsoft.com/default.aspx?scid=kb;en-us;302665

http://support.microsoft.com/default.aspx?scid=kb;en-us;294686

Signature

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

> Doug
>
[quoted text clipped - 26 lines]
>> >
>> > TIA
MTechG - 16 Dec 2005 14:15 GMT
Doug

Thanks for those links I'm looking into them now.  I wish I could use a
report but the template that I'm populating is for a Quoting system so there
is a lot of text to add and each one is different.  

I'm looking at the compound merge right now.  What I was thinking about was
maybe a looping scenario to populate the table on the fly.  Create the table
based on knowing how many rows and columns and insert the data using the loop
and offsets.  I've done something like this in Excel but Word is a different
animal.  

I'm going to look at creating a table on the fly in a Word Document knowing
how big the table needs to be.  

The loop would be my next step which is probably going to be the toughest
part of the whole thing.  

Let me know what you think about this scenario if it's worth attempting I
think it is but I don't have a lot of experience with coding with Word.

TIA

> Why not use an Access Report?
>
[quoted text clipped - 43 lines]
> >> >
> >> > TIA
Doug Robbins - Word MVP - 16 Dec 2005 16:14 GMT
It is definitely possible using vba.

Signature

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

> Doug
>
[quoted text clipped - 75 lines]
>> >> >
>> >> > TIA
MTechG - 16 Dec 2005 17:18 GMT
Doug

Just finished up my Create Custom Table Sub and now going to brain storm on
looping through and pasting values into the table.  Have you done anything
like this?  I notice your name quite a bit when I search in Google groups
looking at code samples.

Dennis

> It is definitely possible using vba.
>
[quoted text clipped - 77 lines]
> >> >> >
> >> >> > TIA
Doug Robbins - Word MVP - 16 Dec 2005 18:39 GMT
This code will add a table to the document at the location of the selection
(or some other range object) and populate it with data from the records in
the table in the database.  It is necessary to set a reference in the Visual
Basic Editor (Tools>Reference) to the Microsoft DAO #.# Object Library for
it to work.

Dim myDataBase As Database
Dim myActiveRecord As Recordset
Dim i As Long
Dim dtable As Table, drow As Row
'Open a database
Set myDataBase = OpenDatabase("c:\Access\Procurement Plan.mdb") 'use your
own database
'Access the first record from a particular table
Set myActiveRecord = myDataBase.OpenRecordset("Currencies",
dbOpenForwardOnly) 'use your own table
'Add a table to the document with one row and as many fields as there are in
the database table
Set dtable = ActiveDocument.Tables.Add(Range:=Selection.Range, NumRows:=1,
numcolumns:=myActiveRecord.Fields.Count)
Set drow = dtable.Rows(1)
'Loop through all the records in the table until the end-of-file marker is
reached
Do While Not myActiveRecord.EOF
   'Populate the cells in the Word table with the data from the current
record
   For i = 1 To myActiveRecord.Fields.Count
       drow.Cells(i).Range.Text = myActiveRecord.Fields(i - 1)
   Next i
    'Add a new row to the Word table and access the next record
   Set drow = dtable.Rows.Add
   myActiveRecord.MoveNext
Loop
'The last row will be empty, so delete it
drow.Delete
'Then close the database
myActiveRecord.Close
myDataBase.Close

Signature

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

> Doug
>
[quoted text clipped - 98 lines]
>> >> >> >
>> >> >> > TIA
MTechG - 16 Dec 2005 19:08 GMT
Doug

Thanks a bunch for your help on this issue. I'm pretty much on the same
track as your code.  I will use it as a refernce though.  

Dennis

> This code will add a table to the document at the location of the selection
> (or some other range object) and populate it with data from the records in
[quoted text clipped - 137 lines]
> >> >> >> >
> >> >> >> > TIA
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.