populate 2003 Word doc table from Access query

[nycdon]

I'm trying to populate a variable list of staff names, phone #s, and blank
boxes for Hours and signature.
I'm able to get the staff names and teles from Access, but not very
readable, and would love to have lines underneath, or be contained in a table
border.
For alignment, tried using vbTab, but seemed when name was longer, the vbTab
wasn;t necessary or pushed beyond what I'd wanted.

what might be good strategy?
thanks!

 

[Russ]

In Word you can play with
Format/Tabs...
To set various kinds of tabs in various positions, with leaders even.
Once formatted like you want the dialog results can actually by recorded
into a macro to do the formatting automatically.
Or if you are comfortable with using Excel, you could go with a Word table.
But I understand that it is easier to format data in Excel before bringing
into Word as a table.

 

[donnyc]

Thanks Russ - how might I accomplish this from Access with VBA?

 

[Russ]

I haven't worked with the interplay between apps, so other may want to chime
in with help. You have to decide which way you want to go. Control Access
from Word (which looked like what you were doing in your first posting) or
Control Word from Access (which is what your last posting suggested).

You can check out this site first to get an overall view of what is
involved.
<http://word.mvps.org/FAQs/InterDev/EarlyvsLateBinding.htm>

Once you have a clearer understanding of which way you want to go, I suggest
that you repost you question to some of these forums at the same time. If
you put them all in the To: field with a comma between them, then the same
question and answers will be linked.
microsoft.public.access.modulescoding,
microsoft.public.access.modulesdaovba, microsoft.public.access.macros,
microsoft.public.access.modulesdaovba.ado, microsoft.public.word.vba.general