Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
RSA RSA is offline
external usenet poster
 
Posts: 2
Default Gathering data using a form

I want to develop a form to be sent via email to a large number of
individuals with the intent to have the recipient fill it in and return it
via email. I want to be able to take the completed form and easily download
the information the recipient has supplied in the form into a master
database. Does anyone have a suggestion on a method to employ and what MS
applications to use to accomplish this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default Gathering data using a form

RSA,

You should use Excel and Access combined. The form should be created in an
Excel workbook and can be imported in an Access database.

The design of the form itself is depending on your needs:
For example:
- is the form static or dynamic. In other words can user add line.
- is entry limited to predefined members (for example accounts)


brotha lee

"RSA" wrote:

I want to develop a form to be sent via email to a large number of
individuals with the intent to have the recipient fill it in and return it
via email. I want to be able to take the completed form and easily download
the information the recipient has supplied in the form into a master
database. Does anyone have a suggestion on a method to employ and what MS
applications to use to accomplish this?

  #3   Report Post  
Posted to microsoft.public.excel.misc
RSA RSA is offline
external usenet poster
 
Posts: 2
Default Gathering data using a form

Thank you! If I understand the information returned on the form created can
be imported into Access. I have many data points that neeI need to be
included on the form and subsequently imported. Are there any limitations I
should be cautious of in creating the Excel form?

"Brotha Lee" wrote:

RSA,

You should use Excel and Access combined. The form should be created in an
Excel workbook and can be imported in an Access database.

The design of the form itself is depending on your needs:
For example:
- is the form static or dynamic. In other words can user add line.
- is entry limited to predefined members (for example accounts)


brotha lee

"RSA" wrote:

I want to develop a form to be sent via email to a large number of
individuals with the intent to have the recipient fill it in and return it
via email. I want to be able to take the completed form and easily download
the information the recipient has supplied in the form into a master
database. Does anyone have a suggestion on a method to employ and what MS
applications to use to accomplish this?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gathering data from worksheet whatzzup Excel Discussion (Misc queries) 3 October 31st 07 07:09 PM
Gathering Data from Another Workbook David Excel Discussion (Misc queries) 0 September 13th 06 11:35 PM
Gathering Data from various tabs ask72883 Excel Worksheet Functions 2 April 28th 06 07:29 PM
Gathering Survey data ajw150 Excel Discussion (Misc queries) 1 November 28th 05 01:06 PM
gathering data xak_tay Excel Discussion (Misc queries) 0 September 30th 05 06:18 AM


All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"