Fancy A Challenge!

Create a Perl Program to acquire Customer information for an optician's
practice.

When the program is run, the user should be prompted to enter a four
digit customer reference number.

The user should then be prompted to enter new customer details.

These prompts should then be given in the following sequence:

Title
Surname
Forename
Sex
Date of birth
Vision measurement

All inputs should be verified. any input which fails the verification
shhould result in a suitable error message being displayed, along with
another prompt for the same item entered again. the verification should
be as follows:

Customer Reference _ 4 digits only

Title - between 1 and 4 alphabetic chracters. The allowable list of
titles is Dr, Lady, Lord, Miss, Mr, Mrs, Ms, Sir.
Surname - between 1 and 20 alphabetic charaters
Forename - between 1 and 20 alphabetic charaters
Sex - 1 character, either M or F (uppper or lower case acceptable)
Date of birth - in the format DD/MM/YYYY
Vision measurement - 1 or 2 digits (i.e between 1 and 99)

te date of birth does not have need to be shecked for validity, e.g.
99/99/999 should be accepted.
However, you should check that the digits and forward slash chracters
are in the DD/MM/YYYY form, e.g. 3/10/2004 should be regeted where as
03/10/2004.

if you can complete this task send your written program to
Webbouy@xxxxxxxxxxx i would Appreciate knowing to do this my self thank
you!

.

Relevant Pages

  • RE: If statement with Dlookup, plus open form
    ... I didn't have the correct number of digits in my btn field, ... But, if the phone number is included in the master table, It still prompts, ... "Do you want to add a new customer." ...
    (microsoft.public.access.forms)
  • RE: Auto Generate Numbers
    ... don't specify the number of digits and format it accordingly. ... Dim strRADate As String ... Dim strRANumber As String ... > I am creating a d/b that will manage my authorizations for customer returns. ...
    (microsoft.public.access.forms)
  • Re: access database design. HEEEELP MEEEEE!!
    ... • Customer number (6 digits) ... Number of standard price seats ... them to represent the bookings made by the customer where tblbookings (2nd ... Create a query, called qryTotalSeats, which will select the customer ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Setting a critera
    ... prompts as the Record Source of a subreport. ... Consider abandoning all parameter prompts in favor of values from controls ... > If I set the criteria in a query and would like to ... > I tried it with a [enter customer ID] criteria and it's the same. ...
    (microsoft.public.access.reports)
  • Re: access database design. HEEEELP MEEEEE!!
    ... Suppose I, the Customer, purchase Season ... Customer number (6 digits) ... Number of standard price seats ... Create a query, called qryTotalSeats, which will select the customer ...
    (microsoft.public.access.tablesdbdesign)