Missing and/or overlapping Info...

[FishVal]

I added this piece beforeupdate

[Code=vb]
If Me.EndingNum.Ol dValue <> Me.EndingNum.Va lue Or Me.EndingNum.Ol dValue > Me.EndingNum.Va lue Or Me.EndingNum.Ol dValue < Me.EndingNum.Va lue Then
Exit Sub
End If
[/Code]

for example:

userid start end
01 00 11
02 12 18
03 19 34

validation fails when manager goes back and edit the user b/c he/she is out for a while. Am I makins sense now ?

Hi, ozarka.

You still have a presumption that I have to understand how the things are going in life of your db users.

So I'll ask you questions (based on the example you've provided):

• Overlapping intervals break validation. Am I right? Does this input has to be rejected?
• When user 02 EndingNum changes to 17, does this breaks validation? How it supposed to be treated? Input rejected or user 03 StartingNum should be changed to 12?
• When user 02 StartingNum changes to 14, does this breaks validation? How it supposed to be treated? Input rejected or user 01 EndingNum should be changed to 13?

P.S. code you've provided doesn't make any sense.

[ozarka]

http://www.e-topco.com/test/db2.zip

I got this one from my co-worker. But I really dont like it.

[ozarka]

Fish,

Have you looked at the sample db yet? Can I streamline the code?

Thanks

[FishVal]

Fish,

Have you looked at the sample db yet? Can I streamline the code?

Thanks

Ozarka,

I don't know your validation rules, you've not answered my questions in post#16.
So I have no idea whether that code fits your needs.

[ozarka]

Hi Fish,

sorry about not answering # 16,

cancel for all of your questions. we dont let it continue and keep the original values.