[AccessD] Emailing Form Data

Boyd, Mark Thomas (US - Philadelphia) mboyd at deloitte.com
Tue Nov 15 11:33:22 CST 2005


Thanks William.  I'd like to lean more towards the 1st suggestion, as
allowing access to a website is not in the client's scope for the
current project.
As I'm a complete novice to JavaScript, and HTML in general, do you have
any examples of attaching a csv file to an HTML form?

Thanks again.


Mark Boyd 
Senior Consultant 
Enterprise Risk Services 
Deloitte & Touche LLP 
  
Tel: +1 215 405 5576
mboyd at deloitte.com 
www.deloitte.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
Hindman
Sent: Tuesday, November 15, 2005 12:23 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list