Data Entry for Remote Reviewers

MIMF · Apr 5th, 2002, 08:49 AM

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?

Damon Ostrander · Apr 5th, 2002, 02:41 PM

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.

MIMF · Apr 5th, 2002, 02:44 PM

Thank you so much.

Apr 5th, 2002, 02:41 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	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 (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 08:49 AM	#1
MIMF New Member Join Date: Apr 2002 Posts: 16	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?

Apr 5th, 2002, 02:44 PM	#3
MIMF New Member Join Date: Apr 2002 Posts: 16	Thank you so much.