|
-
Aug 10th, 2005, 09:22 PM
#1
Thread Starter
Lively Member
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
Last edited by Astro; Aug 10th, 2005 at 10:57 PM.
-
Aug 11th, 2005, 03:23 AM
#2
Re: Generating a word doc. from access form. Help help!
Mailmerge?
Or via vba coding (ADO) and word automation?
The latter being harder but perhaps giving you more control.
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Aug 11th, 2005, 08:03 PM
#3
Thread Starter
Lively Member
Re: Generating a word doc. from access form. Help help!
Hey Ecniv,
I'll take a look at both of them in detail before getting back to you.
Thank you =)
Astro
-
Aug 14th, 2005, 06:43 AM
#4
Thread Starter
Lively Member
Re: Generating a word doc. from access form. Help help!
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
-
Aug 14th, 2005, 07:12 PM
#5
Frenzied Member
Re: Generating a word doc. from access form. Help help!
 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.
Tengo mas preguntas que contestas
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|