Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Sep 2002
    Location
    Toronto, Ontario, Canada
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Create a data form (XP)

    I would like to prompt the user with a list of options (i.e Display Name, Title, or Company Name) and have them choose which ones they want. The results are then used to create a merge data file - with the options chosen used as Field Names. I know in theory it sounds good...implementing it might be a whole different issue. How easy/difficult would this be?

    Thanks,
    Diana

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create a data form (XP)

    It's relatively easy, but you'll be drawing on several "knowledge sets". First, you'll have to determine the presentation approach: a document form or a VBA userform. Document forms are easy to implement (but difficult to implement well) and userforms are harder to learn (since you need to learn some VBA) but are more reliable in the long run. Second, you need to decide on the data file format: a simple CSV text file or something more "binary" like a mdb or xls or maybe even xml! Have fun.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Create a data form (XP)

    If you are only going to generate one document, you don't need to add the complexity of Word's merge features. Instead, you can use a little bit of code to insert the information. Look for a couple of lengthy threads started by kerryg. They discusses a few different ways to collect, store, and insert information into a document.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •