Recent content by CriticalSock

Ok, I've got past my spelling mistakes and have replaced Instr with Like but I think that Like is not pattern matching the characters. For example, the first clause: If Me.Postal_Code Like "[A-Z][0-9][0-9][A-Z][A-Z]" Then CHECK_Code = 0 Should return zero if the first character of...

Thanks for the replies, I'm getting my data from ukpostcodes dot org I intend on getting helpdesk to update the postcode data from here once a month or so. The inputted data isn't saved until the whole form is entered so it doesn't matter if the check is done before or after update? Like...

Hi, I've tried to steal an SQL Postcode validator (This is for UK postcodes) and add it to an AfterUpdate event on a field in MS Access. It doesn't work, obviously, but can you help me with where I've gone wrong? The VBA code is: Private Sub Postal_Code_AfterUpdate() Dim CHECK_Code...

Hello all, I'm a SQL developer who has just moved into a new job which involves a SQL database with an Access front end... and I don't know much about Access! Hoping I can find some help here and maybe provide some help myself!