Validating dates in access
Allowing invalid data to be entered into the database ensures that the database and the data available will become less valuable and harder for the user to use.Note: Excel has several built-in data validation rules for dates.Value)) Then Msg Box "Order Complete Dt cannot be null, Please enter date" Ord_Comp_Dt.Set Focus is Valid = False End If If (Ord_Rcvd_Dt Ord_Comp_Dt.
One more thing I found that when I try to save it gives me following message "The Do Menu Item action was cancelled" and it undo everything, I made in existing record, how I can trap this message and user can save existing record.
Why is it not enough for you to check the fields before saving the record?
You keep insisting on field level checking, but that is not always easy... Hi H, Thanks for ur reply, I got it what u r saying, if Before update works at form level then it wouldn't be problem, user says we want that after entering the wrong value it should fire the trigger so I am trying to meet their requirement, can you tell me how I should convince user saying that this will work only at form level,while saving your record.
If only a short range of dates is valid, such as yesterday, today and tomorrow, you can create a drop down list of those dates.
By using formulas, the drop down list will be dynamic, and will show the correct dates whenever the workbook is opened.
By using data validation, you can limit the entries for one or more cells in an Excel worksheet.