Search results for query: *

Hi, A very strange event, I removed all code and deleted the module. I used Options Explicit, re-created the module added the same code and its worked. Thank you to all of you for your assistance.

Hi, I am using a function only and have called the module AllValue. I did have a recommendation above to call a sub which I tried but I got the same error. Any other ideas and could try ?

Thank you, unfortunately I get the same error The module is called AllValues with the code below only. Function setvalueA(strA As String) strnameA = strA End Function Function SetValueB(strB As String) strnameB = strB End Function Function GetValueA() GetValueA = strnameA End Function...

Many thanks for your response. Unfortunately I still get the error. I think it still needs to be a function, since I call some SQL in access that uses the function GetValueB in the filter criteria of the query, it is a way of passing the value of plant AU10 using SetValueA to the SQL query I...

Hi All, This one has been driving me insane over the past few days. I have searched quite a bit but nothing of concrete leads me to a resolution I get the Compile Error, expecting Sub, Fucntion or Property. I am relatively new to VBA I would very much appreciate any help on this. With...