Link to home
Start Free TrialLog in
Avatar of Bob Collison
Bob CollisonFlag for Canada

asked on

Insert 'Like' Parameter In MS Access VB Variable

I have the following VB Code in an Event.  I need to have the PARM_GRP_MBR_ORG_LEVEL_CD  field to contain either an actual value to select records with a specific value or a value (e.g. a Like phrase) to select all values.

How do I do it?  I can't seem to put the 'Like' Phrase within the Parameter Variable.
The following method doesn't extract any records.
[PARM_GRP_ORG_LEVEL_CD_061] = "Like " & "*"""

The following method extracts records.
[PARM_GRP_ORG_LEVEL_CD_061] = "000"

"SELECT PERIOD_EVENT_GRP_REG_KEY, SYS_MEMBER_LKUP, CORPORATE_NAME, " & _
              "SYS_MEMBER_RECORD_TYPE, PERIOD_EVENT_ORG_LEVEL_KEY, PERIOD_EVENT_STATUS_KEY, " & _
              "HOME_EMAIL_1, HOME_EMAIL_2, WORK_EMAIL_1 " & _
              "FROM 40_EVENT_MEMBER_MSTR " & _
"WHERE PERIOD_EVENT_GRP_REG_KEY = " & Chr$(34) & PARM_GRP_PERIOD_EVENT_GRP_REG_KEY_101 & Chr$(34) & "And " & _
              "PERIOD_EVENT_ORG_LEVEL_KEY = " & Chr$(34) & PARM_GRP_ORG_LEVEL_CD_061& Chr$(34)
 
Thanks.
Bob C.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bob Collison

ASKER

Hi Rey,

I can't believe I was so dumb no to realize that it was the Condition Operator that needed changing.

The following syntax works correctly.
[CMD_40_EVENT_GROUP_MSTR_101] = "SELECT PERIOD_EVENT_KEY, PERIOD_EVENT_GRP_REG_KEY, PERIOD_EVENT_STATUS_KEY, " & _
                                       "PERIOD_EVENT_ORG_LEVEL_KEY, GROUP_LONG_NAME, " & _
                                       "GROUP_EMAIL_1, GROUP_EMAIL_2, GROUP_CONTACT_1_EMAIL_1, GROUP_CONTACT_1_EMAIL_2, GROUP_PRE_REG_CONTACT_EMAIL_1 " & _
                                       "FROM 40_EVENT_GROUP_MSTR " & _
                                       "WHERE PERIOD_EVENT_ORG_LEVEL_KEY Like " & Chr$(34) & PARM_GRP_ORG_LEVEL_CD_061 & Chr$(34) & "And " & _
                                              "PERIOD_EVENT_KEY = " & Chr$(34) & PARM_PERIOD_EVENT_KEY_101 & Chr$(34)

Thanks.
Bob C.