Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Data Entry for Remote Reviewers

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    We have an Access 2000 Database in place to record information about hundreds of documents. We want to be able to send to multiple users nationwide a data entry form of some kind that they can use to record the information that the database calls for. They would then submit the form to me and I will add the data to the Database without having to re-key it. How do I create a form that users can fill in quickly and return electronically? Is there a way to use the existing Access form for this?

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi MIMF,

    There are myriad ways to do this, including creating a form directly in Access and merging the results of all the access tables that are returned with the forms. There are probably forums like this one elsewhere on the 'net where you could get specific help with this approach.

    This can also be done quite easily in Excel, having users enter the data into a spreadsheet, and processing all the returned spreadsheets in Excel VBA to merge them into a single Excel spreadsheet before importing the results to Access, or using Access VBA to just import the results directly into Access tables. This is pretty easy, and if you should decide to go this way you could get a lot of help here at MrExcel.com.

    Another possibility, and one I favor (even thought my first love is Excel), is to use Word. Word has a pretty good forms capability (check into Word "Form Fields"), and it is quite easy from Access VBA to read a whole folder full of Word forms, reading the values from all the form fields and populating an Access table with them.

    I realize that my answer is very general, but hope is helps.

    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you so much.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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