Generating a word doc. from access form. Help help!

Hello there,

i am working on an internship assignment with VBA and am rather new to it.

One of the major concern over the assignment would be generating a word doc. (questionnaire form) from access 03's database table.

For a clearer picture, here are two screen captures.

questionnaire form in word doc. >> http://i13.photobucket.com/albums/a281/Astrov/word1.jpg

mainform in access. >> http://i13.photobucket.com/albums/a2.../mainform1.jpg

As of now, i am completely clueless on the approach to grab data from the database and laying it out in a way that when i convert it into word doc. it'll appear to look like the questionnaire form (word doc.)

Can anyone perhaps shed some light on this, your help will be greatly appreciated.

Thank You Verry Much. =)

Astro

Mailmerge?
Or via vba coding (ADO) and word automation?

The latter being harder but perhaps giving you more control.

Hey Ecniv,

I'll take a look at both of them in detail before getting back to you.

Thank you =)

Astro

hello there,

i have been trying to make use of the dblclick event in a listbox to additem into another listbox.

do i make use of itemsselected property?

thank you

Astro

Quote:

---

Originally Posted by Astro

hello there,

i have been trying to make use of the dblclick event in a listbox to additem into another listbox.

do i make use of itemsselected property?

thank you

Astro

---

Do you know what you're talking about? One question has nothing to do with the other.
And, as an aside, the doubleclick event is almost never used (IME). Nothing wrong with it, but most users expect a simple click event, unless you have a reason to make another thing to occur on double click.