RE: dependent form fields, etc.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jim Buyens (news_at_interlacken.com)
Date: 03/03/05 

Date: Thu, 3 Mar 2005 15:05:03 -0800

Responses interspersed...

"Chris" wrote:

> HI...I'm using FP2003. I have three issues I wish to
> resolve and cannot find out how. I am not a professional
> at this, so be kind. Also I have some experience in
> Access db and VBA coding there.
>
> I am able to create a form and get input,etc. to work
> properly.
>
> My learing/doing issues are:
>
> 1. How do I create a form field input template for phone
> numbers?

Use three text boxes.

> 2. How do I require an entry in field 2 if field 1 is
> selected, but not if field 1 is not selected?

You would have to write your own JavaScript code or, better yet, your own
ASP.NET or ASP code.
 
> 3. How do I validate the user's email addy (comparing two
> separate form fields entered separately but in adjacent
> form fields)?

You would have to write your own JavaScript code or, better yet, your own
ASP.NET or ASP code.

> Can these be done in FP?
>
> Thanks for helping,
> Chris

Only by switching to Code view and typing in the code.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

Relevant Pages

  • Re: Cannot edit or delete records using DBIW generated pages
    ... Source: Microsoft JET Database Engine ... One or more form fields were empty. ... >>> Microsoft Office FrontPage 2003 ...
    (microsoft.public.frontpage.addins)
  • RE: No Records
    ... database region. ... That page would have the same form fields with the same form field names, ... Microsoft MVP ...
    (microsoft.public.frontpage.programming)
  • Re: RAID 5
    ... Also thanks for Chris' kind inputs, ... please help me to capture a screen shot of the ... Open Paint or Microsoft Word or WordPad. ... >> This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.general)
  • Re: License Transfer
    ... And when I am the manufacturer? ... "Chris H." ... > not Microsoft setting things tied to their BIOS within that system. ... >>> upgrade just the CPU is it the same machine? ...
    (microsoft.public.windows.mediacenter)
  • Re: Database Wizard P*****G me off
    ... Microsoft Office FrontPage ... > In the SQL language, which the DRW uses to perform database operations, as ... Syntax error in UPDATE statement. ... >> One or more form fields were empty. ...
    (microsoft.public.frontpage.programming)