IN Function for Access VBA

sql ms-access vba ms-access-2003
Michael T picture Michael T · Jun 9, 2013 · Viewed 9.1k times · Source

Is there a function in Access VBA that works like the IN function in SQL?
I'm looking for something like:

if StringValue IN(strA, strB, strC) Then

Answer

Tom Collins picture Tom Collins · Jun 9, 2013

While sgedded's answer is correct, here's another way that I think is a little cleaner code.

Select Case stringValue 
    Case strA, strB, strC
        'is true statements
End Select

http://msdn.microsoft.com/en-us/library/gg278665(v=office.14).aspx

Related questions

How to insert values into the database table using VBA in MS access

I've started to use access recently. I am trying to insert a few rows into the database; however, I am stuck as it is throwing an error: Too few parameters. I have a table test with only one column in …

Read More
MS Access - execute a saved query by name in VBA

How do I execute a saved query in MS Access 2007 in VBA? I do not want to copy and paste the SQL into VBA. I rather just execute the name of the query. This doesn't work ... VBA can't find the …

Read More
Using Excel VBA to export data to MS Access table

I am currently using following code to export data from worksheet to MS Access database, the code is looping through each row and insert data to MS Access Table. Public Sub TransData() Application.ScreenUpdating = False Application.EnableAnimations = False Application.EnableEvents = …

Read More