populate 2003 Word doc table from Access query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nycdon - 19 Jul 2007 16:48 GMT

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!

Reply to this Message

Russ - 22 Jul 2007 09:08 GMT

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.

> I'm trying to populate a variable list of staff names, phone #s, and blank
> boxes for Hours and signature.
[quoted text clipped - 6 lines]
> what might be good strategy?
> thanks!

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Reply to this Message

donnyc - 22 Jul 2007 17:30 GMT

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

> In Word you can play with
> Format/Tabs...
[quoted text clipped - 15 lines]
> > what might be good strategy?
> > thanks!

Reply to this Message

Russ - 22 Jul 2007 21:05 GMT

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

> Thanks Russ - how might I accomplish this from Access with VBA?
>
[quoted text clipped - 18 lines]
>>> what might be good strategy?
>>> thanks!

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Reply to this Message