Re: Validation rule between 2 fields

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

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 04:00:51 -0800

The unstated assumption in Kevin's reply is that you are working in a form.
Tables store data, forms display it for add/edit. Access/JET tables have no
"triggers" (where SQL-Server tables do), but Access forms have "events".
Kevin mentioned using the BeforeUpdate event (of your form displaying this
data) to add validation code. 

-- 
Good luck
Jeff Boyce
<Access MVP>
"Amir" <ami77a@hotmail.com> wrote in message
news:%23zrdipn8EHA.3840@tk2msftngp13.phx.gbl...
> Hi,
>
> In a certain table I have "Start time" & "End time" fields.
>
> How can I create validation rule, to check that "End time" is always later
> than "start time"?
>
> Thanks,
> Amir.
>
>

Relevant Pages

  • Re: converting look-up fields
    ... The tables in a database are to store data and to maintain the data's ... They do not exist to display or directly enter data directly. ... have to check each place the name occurred and fix it. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Capitalise first letter
    ... store data, Access forms display (and allow data entry). ... Jeff Boyce ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Count and display entries
    ... I know you do not store data in forms, and I know forms are used to display ... have the number of entries displayed on the form. ... individual entry, and display the number in the "Number of Entries" field. ...
    (microsoft.public.access.formscoding)
  • Re: calculating dates in records
    ... using an unbound control with the record source as a calculation. ... > yea i am using a form to display how many days are left until the next ... I'm imagining a query against the most recent row (requires ... Access tables store data, ...
    (microsoft.public.access.formscoding)