Passing Multiple Parameters to a DLL function

[wandera]

Hi Guyz,

Im very new to working with DLLs. I want to create DLL which will get values from a third party software and parameters passed to it to perform some process.
Here is the Defination

Public Sub Hello(YourName As String, YourAcc As String, AvailBal As String)
'Area to put code to process

MsgBox "Hello " & YourName & "!", vbInformation
MsgBox "Your Account is " & YourAcc & "!", vbInformation
MsgBox "Available Balance is " & avaibal & "!", vbInformation

End Sub

So i want to pass the three parameters when i call it but it seem not to be working. All the parameters im passing them as variables.

'Here Calling the DLL fuction

Private Sub CmdProc_Click()
Dim Jina As String
Dim AccNo As String
Dim AvaBal As String

AccNo = InputBox("Enter Account No")

FindCrit = "ACCNO='" & AccNo & "'"
DFAccs.Find FindCrit
Jina = DFAccs!ACNAME
AvaBal = DFAccs!AvailBal

Hello(Jina,AccNo,AvaBal) 'This line is not working

End Sub

When i call Hello fuction with the parameters as shown above.. the compiler doesnt accept, the lines are shown in red. So could somebody show me how to call that function and pass the three parameters to it.

[srinivas_s]

what does DFAccs this do ? cant seem to understand its presence in your code

[wandera]

DFaccs is a recordset which is opened at the form load. i.e database connection and opening is done at form load. I want to query in that recordset i.e DFaccs.

[Phil Weber]

Hello(Jina,AccNo,AvaBal) 'This line is not working

Remove the parentheses around the parameters. You may only use parentheses when the function returns a value. In other words, this would be OK:

Result = Hello(Jina, AccNo, AvaBal)

Because your Hello Sub does not return a value, you must call it like this:

Hello Jina, AccNo, AvaBal

[wandera]

Thanks Phil that works preetty good.