validering / kontrol

If Me.kmaften > Me.kmmorgen Then
MsgBox "Noget tekst"
end if

Not as easy as it may seem, it all depend on HOW the data is entered!
If I entered data for 2-1-05 AFTER I entered data for 1-1 then I could check that the previous data was LESS. But if I enter the information in a different order then I cant!

I think your going to need a function which does the following

If you enter "km morgen" then you find the previous "km aften" and make sure that it is <=

If you enter "km aften" check if a record exists newer (higher date) if there is one then you need to make sure that the km you entered is <= "km morgen" for the newer date, OR inform the user that the newer date information is incorrect!

Terry

Hvad så hvis man taster:
1-1-05
3-1-05
2-1-05

er man så nød til at slette 3-1-05 og så taste 2-1-05,2-1-05 ?

Obs
Terry


Hvad så hvis man taster:
1-1-05
3-1-05
2-1-05

er man så nød til at slette 3-1-05 og så taste 2-1-05,3-1-05 ?

Jeg er optaget andet sted, og har ikke lige min koncentration på dette spørgsmål. Men kan man ikke lave en funktion, der finder den post, hvor datoen er:

Me.dato -1

og herfra uddrage de felter der skal beregnes på.

I would make a general function which you call EVERY time you enter/alter a km field.

It has to check information for the same day (is km aften > km morgen ?)

It also needs to check that the information is valid against the highest date previous to the date your are entering.

and it also needs to validate the data which if you have entered against data for records with dates NEWER than the date yuo are entering for.


What you decide to do is really up to you. But you have to inform the user if you find a problem.

I would suggest that you cancel the CURRENT changes and inform the user that they MUST alter other records BEFORE they can continue. Otherwise you can not be sure that they remember to alter other data.

I would suggest that you write down on paper the different possibilities you have for entering the information. Then your function must take these into account.

In my oppinion it should be allowed to enter information in any date order and your program should validate the information against the existing infromation (dates)

status?

takker for svar, som foreslået er jeg gået i tænkebox - tegnebræt. Men som jeg ser det kan jeg bruge begge svar så derfor et split

OK, og tak :o)