Validation Rule

[smitstev]

Hi All,



I am creating a database which is used by multiple people. I want to create a validation rule in the table that will not allow data to be entered if the date of the data is already contained in the data.

The validation rule must find the newest(most current) date in the data and not allow any date of that and older.

Does anyone have a solution for this. I have been searching forever...

Any help would be greatly apprciated! Thanks!

[RuralGuy]

You need to do this in the BeforeUpdate event of a control on a form.

[smitstev]

I need to do it in a form...? I am trying to write the rule for a table.

[RuralGuy]

Your needs exceed the abilities of validation at the table level. Your users should never see the tables directly anyway. All Edit/Add/Delete operations on tables should be through forms.

[smitstev]

The database is only being used by me and one other person... we just want to make sure we do not import the same days data twice.

Could I just use two tables, one as a master table and one as a temp table. Have a query that moves the data into the master table where the date is not equal?


Thanks!

[RuralGuy]

If the dates are unique then you could UPDATE Where Not IN as an append. Remember that Access DateTime fields include the time as well.