Validation Rules

[Steve Schapel]

Well, I guess this begs the question - How to validate & accommodate Nulls?
I guess code's needed so I'll put that one an a back burner untill I've got

No, code not required. Put a field-level Validation Rule for each of
the date fields...
Is Not Null

Instead, you could set the Required property of the field to Yes - but
this is not as user-friendly.

the basics (just been trying to get my head round 'junction' tables &
many-to-many's, not that I forsee a need just yet - just trying to learn)

You might like to look at this article ...
http://accesstips.datamanagementsolutions.biz/many.htm

 

[onedaywhen]

Put a field-level Validation Rule for each of
the date fields...
Is Not Null

Instead, you could set the Required property of the field to Yes - but
this is not as user-friendly.

Again, I find myself in disagreement <g> (Nothing personal!)

Making the column NOT NULL (Required = True, whatever) is one of those
things you get 'for free'. I don't know for sure for Jet but I would
imagine the SQL engine optimizes better when it *knows* a column cannot
contain nulls, rather than having to execute/parse a validation rule to
discover the same fact.

Jamie.

--

 

[onedaywhen]

By the way, Jamie, http://www.woug.info

A bit short notice for me, as I am based in the UK <vbg>.

Jamie.

--

 

[Terry Kreft]

In this case I would agree with you <g>.