Using VBA with Access 2010, I have a sub:
Public Sub setInterest(account As String, dmonth As Integer)     ...somecode... End Sub   And I am calling it with
setInterest("myAccount",3)   And I get syntax errors.
 Modifying the sub to only take one argument and leaving out the 3 gives no errors, the problem is only when I have 2 arguments.
When using multiple arguments, you can either write:
 setInterest "myAccount", 3   Or
 Call setInterest("myAccount", 3)   In both examples you can name the arguments:
setInterest account:="myAccount", dmonth:= 3 
                        If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With