Results 1 to 5 of 5

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

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jun 2005
    Posts
    90

    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.

  2. #2
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    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.

    BOFH Now, BOFH Past, Information on duplicates

    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...

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jun 2005
    Posts
    90

    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

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Jun 2005
    Posts
    90

    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

  5. #5
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

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

    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.
    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
  •  



Click Here to Expand Forum to Full Width