How Can I Use rgxValidate

diannosd

Registered User.
Local time
Today, 17:04
Joined
Feb 14, 2008
Messages
11
Good morning,

I have posted a few questions and as yet have not had answers but hopefully this time I might have some success. lol I saw some code posted on the Vba section of this site for validatingpostcodes called regex validation
where the function is called Function rgxValidate. Could some one be kind enough to show me how I can implement this. I copied all of the code in to a new module and then using a form I have, added

Code:
If Not rgxValidate(Me.Postcode, "rgxZIP_UK")Then
    MsgBox "I don't like " & Me.ActiveControl.Text & "."
    Cancel = True
End If
End Sub

but when I run / debug it tells me It is a ambiguous name already being used. PLease help....
 
This means that you have the rgxValidate function created in more than one code module in your database. Do a search on your entire database project for the phrase Function rgxValidate to find all instances where the function has been created in your database.
 

Users who are viewing this thread

Back
Top Bottom