Instead of writing to a csv file, which not write directly to the an Access database on the web, and
you would have to format the data prior to it being inserted in the database or whenever you display
the data. You can not verify that a email address is valid, unless you send to it. Depending on what
you are doing, you have folks complete the form, submit, and then they must wait to receive an
email, which has a link back to your site, that they would click on, which then would confirm the
email address used at that point in time was a valid one.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
"bkeelane" <(E-Mail Removed)> wrote in message
news:C42D5617-066A-4752-9C11-(E-Mail Removed)...
> okay now i have another problem... the form is delivering the form results to
> a csv file. We then import the records into an access database.
> Is there a way to format the fields either in the csv file or in access to
> be the correct format (for a ssn the format would be 111-11-1111). I would
> leave it up to the applicants to enter this information in but i've tried
> that and still get a deluge of ssn's not formatted correctly.
>
> keep in mind that our access database already has records in it that are
> formatted correctly (with the dashes) so i don't know if formatting a column
> or group of cells in access (if that's even possible) would mess up the
> records we already have saved.
>
> also, is there a way to verify that the person has entered a valuable email
> address? we have several applicants who just enter their screenname without
> the domain.
>
> thanks.
>
> becky
>
> "Thomas A. Rowe" wrote:
>
>> Set field validation to text, then check "Other" only and type in 0123456789
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WEBMASTER Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "bkeelane" <(E-Mail Removed)> wrote in message
>> news:8EED914C-ADB3-4C64-AA42-(E-Mail Removed)...
>> > When validating form fields in front page i want to only allow numbers for
>> > the person's phone number (without dashes). when i go into form field
>> > validation i understand that i can change the input type to text, number or
>> > integer but even if i change the type to one of those it still accepts
>> > hyphens as a character. is there a way to disallow this? or is there a way
>> > for format the 10 digit number as xxx-xxx-xxxx?
>> >
>> > thanks
>> > becky
>>
>>
>>
Similar Threads
