Re: Help with class module
Welcome to the Forum :wave:
IsNUll in SQL expects two arguments. And in this senario I think you should be checking whether the field is Null or Not and IsNull is not the one to use. Your Query should be like this
VB Code:
rsfields.Open "SELECT * FROM " & lvItem _
& " WHERE " & cla1.GetORISFieldsList(lvItem.Text) & " Is Null", _
cnWS, adOpenStatic, adLockReadOnly
Re: Help with class module
Thanks for the tip. However, this query results with a message box saying there is a syntax error (comma) in the query expression.
Re: Help with class module
Put a break point at rsFields.Open statement and before executing print the SQL Query in the immediate window. Then analyze the query and see what is wrong.
What is the present in these two
lvItem
cla1.GetORISFieldsList(lvItem.Text)