Bob Collison
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_10 1 & Chr$(34) & "And " & _
"PERIOD_EVENT_ORG_LEVEL_KE Y = " & Chr$(34) & PARM_GRP_ORG_LEVEL_CD_061& Chr$(34)
Thanks.
Bob C.
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
The following method extracts records.
[PARM_GRP_ORG_LEVEL_CD_061
"SELECT PERIOD_EVENT_GRP_REG_KEY, SYS_MEMBER_LKUP, CORPORATE_NAME, " & _
"SYS_MEMBER_RECORD_TYPE, PERIOD_EVENT_ORG_LEVEL_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_
"PERIOD_EVENT_ORG_LEVEL_KE
Thanks.
Bob C.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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_1
"PERIOD_EVENT_ORG_LEVEL_KE
"GROUP_EMAIL_1, GROUP_EMAIL_2, GROUP_CONTACT_1_EMAIL_1, GROUP_CONTACT_1_EMAIL_2, GROUP_PRE_REG_CONTACT_EMAI
"FROM 40_EVENT_GROUP_MSTR " & _
"WHERE PERIOD_EVENT_ORG_LEVEL_KEY
"PERIOD_EVENT_KEY = " & Chr$(34) & PARM_PERIOD_EVENT_KEY_101 & Chr$(34)
Thanks.
Bob C.