Alpha Video Training
Results 1 to 7 of 7

Thread: Allow exceptions to maximum value.

  1. #1
    Annita Merriweather
    Guest

    Default Allow exceptions to maximum value.

    How do I allow the user to override a maximum value field rule? Thank you Annita

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default RE: Allow exceptions to maximum value.

    Annita, I don't think you can. Isn't the purpose of the Maximum Value field rule to set an outside limit or boundary beyond which users aren't allowed to go?

    Why do you want to specify a Maximum Value, and then sometimes let them go beyond it?

    -- tom

  3. #3
    Annita Merriweather
    Guest

    Default RE: Allow exceptions to maximum value.

    Tom, there are always exceptions and occassionally the exception amount needs to be enter.
    the other possibility is some type of warning system, that the amount is over the expected limit. With some sort of warning system, the amount can be reviewed and a decision made at that time. Thank you Annita

  4. #4
    Member
    Real Name
    RT
    Join Date
    Apr 2000
    Posts
    726

    Default RE: Allow exceptions to maximum value.

    Anita:

    Tom gave you some good advice. If you set a maximum value for a field via the table's field rules, that means you cannot enter any amount that exceeds the max. value. Anita, that's how the field rule is designed to work.

    However, there's almost always another way to do what you want. If you want to warn a user, advising them they exceeded a specified limit, that is very easy to accomplish.

    You can change the color of the font if and when the value exceeds a certain number. For example, let's assume you are entering an order amount and let's arbitrarily state the maximum quantity for each customer order is 25.

    You can create a font equation that changes the color of the font from black to RED if the order quantity exceeds 25. Now the user can enter a number greater than 25 for that customer, but the color of the font will change.

    Remember, this is a font equation set on the form, it is not a field rule that one sets up in the table. If you create a field rule with a maximum value of 25 for the order quantity, the user cannot enter any value that exceeds 25.

    Hope this helps,
    Robert T.




  5. #5
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default RE: Allow exceptions to maximum value.

    Annita,

    If the 'maximum' amount you specify in the field rule isn't really a maximum in all cases you should look for a different solution. The field rule won't permit exceptions. Maximum is maximum I suppose.

    I think the field rule is intended to catch data entry errors that are outside the range of 'legal' entries according to the business rules of your application. In an invoicing application you wouldn't normally want the invoice date to be later than 01/01/2100 or earlier than 01/01/1950 would you? If exceptions were permitted the user could enter an invoice date of 01/01/0001. See what I mean?

    Robert's advice is good. Look for another way to check the entered value and do your own custom validation or warning for the user.

    -- tom

  6. #6
    Annita Merriweather
    Guest

    Default RE: Allow exceptions to maximum value.

    Thank you. Annita

  7. #7
    VAR davej's Avatar
    Real Name
    Dave Jampole
    Join Date
    Apr 2000
    Location
    Haughton, LA ( just east of Shreveport, Louisiana)
    Posts
    2,524

    Default RE: Allow exceptions to maximum value.

    Annita,

    I'll add another option, if I may.

    Place an RTF object on the form, in close proximity to the field into which the value is entered. Set the visibility property of this object to hide and, using Robert's thought, change the field to show based on whatever value you wish. Obviously, you can include whatever text you want in the RTF field.

    This won't preclude someone entering a value greated than your maximum value, but it will warn them that they are exceeding the desired max.

    Dave

Similar Threads

  1. Lookup validation to allow exceptions
    By Marilyn Wallace in forum Alpha Five Version 6
    Replies: 4
    Last Post: 10-14-2005, 01:22 AM
  2. Edit Exceptions
    By Duane Pederson in forum Alpha Five Version 5
    Replies: 0
    Last Post: 03-09-2004, 01:48 PM
  3. Unhadled Exceptions in Lookup - Possible Fix
    By Selwyn Rabins in forum Alpha Five Version 5
    Replies: 6
    Last Post: 01-03-2003, 10:47 AM
  4. Unhandled Exceptions
    By RupertP in forum Alpha Five Version 5
    Replies: 2
    Last Post: 12-01-2002, 06:16 PM
  5. Exceptions to multiple expressions
    By helen forge in forum Alpha Five Version 4
    Replies: 4
    Last Post: 01-04-2002, 09:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •