Friday, January 06, 2017

Found Objects...

When walking 'out there', nothing is quite as heart breaking as finding cute kid's toys that have been lost / abandoned. This happened to us the other day and inspired the poster below. If said toy is not retrieved from it's spot by tomorrow, the poster might appear in the real world. Maybe.

Today's Gratitude Item: Finally figuring out how to make access give custom error messages on forms where fields are required. This time around googling was spectacularly unhelpful as most of the advice said to use VBA but failed to point out that if you have more than one required field, VBA won't actually do what you need. In the end using validation rules turned out to be the answer. All that was needed was a 'not null' statement with a suitable error message underneath. So simple!

No comments: