VBA: Custom function without parameter giving Expected = error

Dev Articles Community Forums Sponsor:

March 21st, 2005, 09:49 AM

helz

Registered User

Join Date: Mar 2005

Posts: 5

Time spent in forums: 1 h 24 m 30 sec
Reputation Power: 0

VBA: Custom function without parameter giving Expected = error

I have two functions, one with a parameter and one without
eg:

Code:

 Public Sub FuncWParam(state as boolean)
    'some code here
 End Sub
 
 Public Sub FuncWOParam()
    'some code here
 End Sub

Now I can call the function with a parameter like this:

Code:

 FuncWParam (1)

but if i try calling the function that does not have a parameter i get an error

Code:

 FuncWOParam()

error is:
Expected: =
so i tried giving the function a return value into a variable but then i get the error
Expected: Function or Variable

any ideas?

PS. Another idea I had was, can i use a variables value in a statement? ie somthing similar to:

Code:

 Public Sub ClearObject(obj as string)
    Me.obj.Value = Null
 End Sub

thanks very much for any replies

March 21st, 2005, 10:58 AM

pmcnamee

Registered User

Join Date: Feb 2005

Posts: 13

Time spent in forums: 1 h 12 m 52 sec
Reputation Power: 0

try calling the sub procedure without the parentheses

Code:

FuncWOParam

you don't use parentheses unless your 'function' returns a value.

You are actually using 'sub procedures', not functions.

March 21st, 2005, 03:00 PM

helz

Registered User

Join Date: Mar 2005

Posts: 5

Time spent in forums: 1 h 24 m 30 sec
Reputation Power: 0

ok will call them that from now on.

any ideas on how i can use a parameter in a sub procedure directly in a command such as

me.parameterhere.value = null
(the sub procedure is one that clears the values of the form fields)

Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > VBA: Custom function without parameter giving Expected = error

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump