My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 "Not Like" operator in VBA
|
|
 Sep 20 2007, 07:32 PM
Post
#1
|
|
|
UtterAccess Ruler Posts: 1,509 From: Redondo Beach, CA  |
I'm taking my first stab in creating a complex function.
In this part of the code, I have: If Mid(Mod1, 1, 1) Like "[A-Z]" Then.... But if I want this to change to the exclusion, I get an error message: If Mid(Mod1, 1, 1) Not Like "[A-Z]" Then... Does the word "Not" not work when creating a vba function? |
 |
 
|
|
Sep 20 2007, 08:21 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 1,536 From: Lansing, MI |
You have to do it a bit differently in VBA than in SQL. VBA recognizes Like as an operator but you have to negate the whole expression rather than the operator.
For example, change this: If Mid(Mod1, 1, 1) Not Like "[A-Z]" Then... To this: If Not (Mid(Mod1, 1, 1) Like "[A-Z]") Then... Note the placement of the Not operator before the entire Like comparison. HTH Jeff |
|
|
|
|
Sep 20 2007, 08:30 PM
Post
#3
|
|
|
UtterAccess Ruler Posts: 1,509 From: Redondo Beach, CA |
Thanks Jeff!
As my short-term memory begins to fade in my adult life, I find it more difficult to remember the specific nuances betwen SQL and VBA... Thanks again, Rich |
|
|
|
|
Sep 20 2007, 08:43 PM
Post
#4
|
|
|
UtterAccess VIP Posts: 1,536 From: Lansing, MI |
Happy to help. Good luck with the rest of your "first stab"! (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)
|
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 19th June 2013 - 08:06 PM |
Tag cloud:
not like operator in excel macro, access vba not like operator, access not like operator, not like in vba access, dlike in vba access, access not like function, not like expression with ms access, like condition vba access database, not like in access vba, vba sql not like, vba not like operator, not like in access, access 2007 not like operator, vbscript sql like syntax, vba not like (*[a-z])