Database fields in a input form

15 Dec 2005 6:26 PM

Veronika

How can I specify formatting restrictions for special fields like Postal Code
(format X1X 2C2) or date input field MM/DD/YYYY?
I have Acces DB with these specs, but when I used FP2002 Database Interface
Wizard, it ignores these. Also I am unable to "edit" any of the records
utilizing pages generated by this wizard. There is an error that it will not
accept empty fields. I have no problem adding data (even if some fields are
empty) or deleting records.

16 Dec 2005 1:05 AM

Bob Lehmann

> How can I specify formatting restrictions

You will have to do it in your ASP code.

> when I used FP2002 Database Interface Wizard

uh-oh! You are unlikely to get any help with that here. Most of the people
here are of the type-it-yourself programming ilk. Not many of the
auto-amagical, push-button, do-it-for-me types hang out here.

> I have Acces DB with these specs

Why don't you admit that you are seriously in over your head, and either
need to hire someone to do it for you, or get some training from someone who
is qualified to do these things?

I mean, geeze, it has never ocurred to me to attempt an appendectomy. So why
do you want to venture into doing things that you are clearly not qualified
to do?

Oh, I forgot! It's just a web page. It should be easy.

Bob Lehmann

Show quote

"Veronika" <Veron***@discussions.microsoft.com> wrote in message
news:8F16E261-BD09-4903-9B83-BE9A10A3F911@microsoft.com...
> How can I specify formatting restrictions for special fields like Postal
Code
> (format X1X 2C2) or date input field MM/DD/YYYY?
> I have Acces DB with these specs, but when I used FP2002 Database
Interface
> Wizard, it ignores these. Also I am unable to "edit" any of the records
> utilizing pages generated by this wizard. There is an error that it will
not
> accept empty fields. I have no problem adding data (even if some fields
are
> empty) or deleting records.