Next Function not available

[kameta]

In this extract from my projects ARGS is a variable with value = "19,36"


Dim ProjID As String, ActID As String
Dim i As Integer
' Parse ProjID
i = InStr(1, args, ",&quot
If args <> &quot;&quot; Then
ProjID = Left(args, i - 1)
End If


When I get to the line left(args, i-1), it gives an error message that it can't find project or library. i have a feeling the inbult function left() is missing since even when I type 'left( ' it does not bring the asssistant to the parameters of left. Is there a way the function could be missing?

 

[Steve101]

Check out the following link. It may help:

http://www.experts-exchange.com/Databases/MS_Access/Q_20148064.html

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[Francescina]

You should check your references, maybe there is one missing.
BTW, you should also observe the naming conventions for your vars, this will make your programming work a lot easier, especially debugging.

Are you certain that &quot;args&quot; is a string?

 

[kameta]

Steve, you are the greatest, I used the VBA.Left thing and it worked. Thanks, I owe you one.

 

[Steve101]

Happy to help, or point you in the right direction. However, note that their is still something wrong with your installation. You should'nt need to use the VBA.Left prefix. Suggest you compare your references with those on a computer where you dont need the prefix. this might help.
Good luck,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)