Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old December 15th, 2005, 06:35 PM
Veronika
Guest
 
Posts: n/a
Default Database fields in a input form

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.
  #2  
Old December 16th, 2005, 01:26 AM
Bob Lehmann
Guest
 
Posts: n/a
Default Re: Database fields in a input form

> How can I specify formatting restrictions
You will have to do it in your ASP code.
[color=blue]
> when I used FP2002 Database Interface Wizard[/color]
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.
[color=blue]
> I have Acces DB with these specs[/color]
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


"Veronika" <Veronika@discussions.microsoft.com> wrote in message
news:8F16E261-BD09-4903-9B83-BE9A10A3F911@microsoft.com...[color=blue]
> How can I specify formatting restrictions for special fields like Postal[/color]
Code[color=blue]
> (format X1X 2C2) or date input field MM/DD/YYYY?
> I have Acces DB with these specs, but when I used FP2002 Database[/color]
Interface[color=blue]
> 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[/color]
not[color=blue]
> accept empty fields. I have no problem adding data (even if some fields[/color]
are[color=blue]
> empty) or deleting records.[/color]


 

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles