Trapping an Error for a required field?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • ApexData@gmail.com
    #1

    Trapping an Error for a required field?

    Using a continuous form I would like to require 1-field in each record
    to have data before the record is saved. In the table I set a single
    date field as required = yes, and this works for me.

    How do I display a custom message that makes sense, other than the one
    I am assuming is coming from jet (DAO). I tried to trap the message
    in the forms OnError but the error of failing to enter data in the
    required field seems to be 0, I don't think this is correct.

    How can I display a message requiring the single fields data through
    trapping ?
    Tags: None
    • Lars Brownie
      #2
      Re: Trapping an Error for a required field?

      See http://www.databasedev.co.uk/custom-error-message.html

      Lars

      <ApexData@gmail .comschreef in bericht
      news:67b13bc5-2c3b-4c9a-82da-58435a229d1b@l4 2g2000hsc.googl egroups.com...
      Using a continuous form I would like to require 1-field in each record
      to have data before the record is saved. In the table I set a single
      date field as required = yes, and this works for me.
      >
      How do I display a custom message that makes sense, other than the one
      I am assuming is coming from jet (DAO). I tried to trap the message
      in the forms OnError but the error of failing to enter data in the
      required field seems to be 0, I don't think this is correct.
      >
      How can I display a message requiring the single fields data through
      trapping ?

        Comment

        • ApexData@gmail.com
          #3
          Re: Trapping an Error for a required field?

          Thanks Lars

          I'll try it out!


          On Jul 7, 12:32 am, "Lars Brownie" <l...@brownie.c omwrote:
          Seehttp://www.databasedev .co.uk/custom-error-message.html
          >
          Lars
          >
          <ApexD...@gmail .comschreef in berichtnews:67b 13bc5-2c3b-4c9a-82da-58435a229d1b@l4 2g2000hsc.googl egroups.com...
          >
          >
          >
          Using a continuous form I would like to require 1-field in each record
          to have data before the record is saved. In the table I set a single
          date field as required = yes, and this works for me.
          >
          How do I display a custom message that makes sense, other than the one
          I am assuming is coming from jet (DAO).  I tried to trap the message
          in the forms OnError but the error of failing to enter data in the
          required field seems to be 0, I don't think this is correct.
          >
          How can I display a message requiring the single fields data through
          trapping ?- Hide quoted text -
          >
          - Show quoted text -

            Comment

            Previous template Next
            Working...