Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    easiest form to import (XP)

    I've been asked to create an electronic form that could be imported into an Access database for queries and reports. The form would have about 10 fields to fill in. And one field that could have multiple answers. Would it be easier to import from Word or Excel? I have created forms in Word but not Excel. However, I have only imported to Access from Excel. Is it possible to import from Word?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: easiest form to import (XP)

    Since a fill-in form will not be in a format that is directly understandable to Access, you're going to need code to get the data into Access anyway, so I don't think it makes much difference. Form fields in Word are associated with bookmarks, and it it relatively easy to retrieve the value of bookmarks in code. Cells in Excel can be retrieved using their cell address.

    Added: why not do the data input in Access too?

  3. #3
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: easiest form to import (XP)

    These are people who are scared by the word Excel, much less teaching 20 people to use Access. I'm thinking after listening to them groan since I posted this I will have to do it in Word and use code to import it. Thanks for the info though.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: easiest form to import (XP)

    If you build a form in Access, they don't ever need to know they are using Access. I find forms and data validation much easier in Access than with forms in Word or Excel. The hitch is they need either Access installed on their PC, or a run-time version built and deployed using the Developer version of Office. To do data entry in Word and then import it into Access is a significantly more complex development in my view. If you want a review of the issues with doing data entry in Word, post back.
    Wendell

Posting Permissions

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