error argument not optional

[slimjen]

All, Using 2010 working on a 2003 database. Have code to enable and disable bypass.

Public Function SetProperties(strPropName As String, _
varPropType As Variant, varPropValue As Variant) As Integer
    On Error GoTo Err_SetProperties
    Dim db As DAO.Database, prp As DAO.Property
    Set db = CurrentDb
    db.Properties(strPropName) = varPropValue
    SetProperties = True
    Set db = Nothing
Exit_SetProperties:
    Exit Function
Err_SetProperties:
    If Err = 3270 Then    'Property not found
        Set prp = db.CreateProperty(strPropName, varPropType, varPropValue)
        db.Properties.Append prp
        Resume Next
    Else
        SetProperties = False
        MsgBox "SetProperties", Err.Number, Err.Description
        Resume Exit_SetProperties
    End If
End Function

I was able to debug and compile. But when I call this function; I get a compile error "Arguement not optional."
Why the compile error if I was able to debug and compile and how can I fix this error. I need it before I create the .mde.
Thanks

[June7]

Where are you calling this function? Show that code.

[slimjen]

I was testing it so calling it in the immediate window below the function code.

[slimjen]

Call SetProperties

[June7]

The function has 3 arguments, all are required. So must call it with some values for each argument.

SetProperties(value1, value2, value3)

It compiles because the Call is not anywhere in code or query or textbox. It isn't anywhere until you use it in the Immediate window. The Call errors, not the function.

[slimjen]

I tested this a month ago in another database and it worked with only calling the name of the function. actually; I always call the function with call "whatever". Is it because Im not calling it from somewhere else other than the module? I don't understand. thanks

[June7]

I have never known a function to run without input when argument required. If optional would be different.

[slimjen]

ok. I do remember that I didn't not use option explicit in the module. Do you think this is why I was able to run this a month ago? Im trying to make my code better by using option explicit in all my forms and modules. Especially when I plan to deploy mdes. So; how do I call the function. Thanks.

[orange]

This link points to Acc2000, but the info re Optional Parameters/Arguments is relevant to your post.
http://msdn.microsoft.com/en-us/libr...ice.10%29.aspx

[slimjen]

Got it. Thanks so much

[June7]

Option Explicit has nothing to do with calling function with or without required arguments. It does require that variables be declared before they are used in code.