CODEWITHSUNDEEP
ms-accessvba
user2885425
user2885425

Reputation: 9

Make Table ms access VBA

I am unable to create a table from the below query i get an type mismatch Error, the value is Text , the column is also text.

please find the below query:

DB.Execute " SELECT * INTO RESULTS FROM CCPA WHERE EMA_ADR LIKE & " * " & 
ME.SEARCHEMA.VALUE & " * ""

Upvotes: 1

Views: 49

Answers (1)

Santosh
Santosh

Reputation: 12353

Try this

db.Execute "SELECT * INTO RESULTS FROM CCPA WHERE EMA_ADR LIKE '*" & Me.SEARCHEMA.Value & "*'"

Upvotes: 2

Related Questions