ExpandCollapse

Guest

That was very helpful. Thank You.

But is there any way to do it, using the validation entry in the tables?

If not, thank you anyway!

"Ofer Cohen" wrote:
> If you are talking about a form, a validation before the data is inserted to
> the table, then on the before update event of the form you can run the code
>
> If (Nz(Me.OAP,0) + Nz(Me.Child ,0) + Nz(Me.Adult,0)) > 4 Then
> MsgBox "All fields can't be greater then 4"
> Cancel = True ' Wont let the user save the record
> End if
>
>
> --
> Good Luck
> BS"D
>
>
> "Damo447" wrote:
>
> > I have created a ticket system.
> >
> > In one table I have the fields OAP, Child and Adult.
> >
> > No field is allowed to have a greater value (but can be equal) than 4 and
> > collectivly they must be equal or less than four.
> >
> > Do you know a validation method which would agree with these requirements?
> >
> > Please help!

ExpandCollapse

Guest

Yes you can do iy through the table.
1. open the table in design view
2. Open the table properties - From the ToolBar select View > Properties
3. In the ValidationRule property write
([OAP]+[Child] +[Adult] ) < 5

4. In the Validation text property write a ,eaningful message incase the
value will be grater then 4

5. GoodLuck

BS"D

"Damo447" wrote:
> That was very helpful. Thank You.
>
> But is there any way to do it, using the validation entry in the tables?
>
> If not, thank you anyway!
>
> "Ofer Cohen" wrote:
>
> > If you are talking about a form, a validation before the data is inserted to
> > the table, then on the before update event of the form you can run the code
> >
> > If (Nz(Me.OAP,0) + Nz(Me.Child ,0) + Nz(Me.Adult,0)) > 4 Then
> > MsgBox "All fields can't be greater then 4"
> > Cancel = True ' Wont let the user save the record
> > End if
> >
> >
> > --
> > Good Luck
> > BS"D
> >
> >
> > "Damo447" wrote:
> >
> > > I have created a ticket system.
> > >
> > > In one table I have the fields OAP, Child and Adult.
> > >
> > > No field is allowed to have a greater value (but can be equal) than 4 and
> > > collectivly they must be equal or less than four.
> > >
> > > Do you know a validation method which would agree with these requirements?
> > >
> > > Please help!

About Us

Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Like us on Facebook

Support SPN

The management works very hard to make sure the community is running the best software, best designs, and all the other bells and whistles. We'd really appreciate your support!