[AccessD] Emailing Form Data

...everyone has a browser ...export the data to a csv ...attach an html form 
using the csv as source with js ...they update the data and send it back 
...you dump the form and import the csv file directly into your tables 
...write once, use forever.

...you could post the form to a web site tied to an mdb and have them just 
update it ...then you dl the data and do what you will ...or just a plain 
old form submit if the data is only a few records

William

----- Original Message ----- 
From: "Boyd, Mark Thomas (US - Philadelphia)" <mboyd at deloitte.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Tuesday, November 15, 2005 11:49 AM
Subject: [AccessD] Emailing Form Data


>I need to send database data to end-users, have them modify, and return
> back to me.
> My table contains 2 fields, [ProjectName] and [ProgressPrct].  I have a
> form with 2 controls per record, txtProjectName (textbox) and
> cmbProgress (combo box).  The data on the combo box needs to be updated
> on a weekly basis, with values of 0 - 100%, in increments of 10.
>
> What is the easiest way to send this data for user reponse?
> I'm thinking that sending a user form as an attachment would work, but
> I'm not sure what kind of form to use.  We've considered Outlook forms,
> but creating this form from code is very time-consuming, and uploading
> the returned data within customized fields sounds daunting.
> InfoPath would be ideal, but not all users have this program installed.
>
> Because the sending of this form will occur on a weekly basis, I'd like
> to automate it as much as possible.
> Any direction is greatly appreciated.
>
> Thanks.
>
> Mark Boyd
> Senior Consultant
> Enterprise Risk Services
> Deloitte & Touche LLP
>
> Tel: +1 215 405 5576
> mboyd at deloitte.com
> www.deloitte.com <http://www.deloitte.com/>
>
>
> This message (including any attachments) contains confidential information 
> intended for a specific individual and purpose, and is protected by law. 
> If you are not the intended recipient, you should delete this message.
>
>
> Any disclosure, copying, or distribution of this message, or the taking of 
> any action based on it, is strictly prohibited. [v.E.1]
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>