I'm stuck on this one and google isn't helping.
Trying to validate data entry using a query in access but running through ADO. It all runs fine until it tries to validate an id number like this:
VAL_member_id: IIf([member_id]<>"" And ([member_id] Like "____-_____" Or [member_id] Like "#-#" Or [member_id] Like "#-##" Or [member_id] Like "#-###" Or [member_id] Like "#-####" Or [member_id] Like "#-#####" Or [member_id] Like "#-######" Or [member_id] Like "#-#######"),True,False)
When it runs in Access it comes up True but when it's run through the ADO/ODBC driver it comes up False. I can't see a problem with it though.
It's probably gonna be something simple. xD
2006-08-17
06:00:14
·
3 answers
·
asked by
Anonymous