How to convert Sub to a Function? (1 Viewer)

[jai kushwaha]

how I can make a macro to open run an event on a form

 

[jai kushwaha]

Re: Macro to open an existing form

how to convert subroutine to function?' I want to make a button on my form and want to add an event on_click. the event I want to add on click of button I made the event code but I dont know that how to convert it in function so that I can run in the macro and add it to button on_click event. so can anyone please tell me how to convert the sub code in function.????

 

[Uncle Gizmo]

Replace the word Sub with Function throughout the procedure.

 

[Grumm]

Don't forget that a function should return a value.
I don't see why you can't add the sub to the on_click event but you probably have a good reason for that.
Here you can find some explanation about the difference : http://www.baldyweb.com/SubFunction.htm

 

[Uncle Gizmo]

There's something odd about calling functions or subs, sometimes you can't call a sub. (I might have the wrong end of the stick- Need to check when I get home) I'll put a link in when I find it.

 

[Grumm]

I saw he mentioned macro's... I never use macro's behind buttons. I always use "Code Builder" and call my sub or function from there. Never had a problem calling subs that way...

 

[jai kushwaha]

how to make a code behind buttons to do event which is already an event on the form with different procedure.

explanation...
I have a form and on the form I have an event on dblclick. now I want to make a button on the same form to do the same thing on button click. now how I can do it??

 

[Minty]

on your buttons on click event

Call yourButtonsDouble_Click

 

[jai kushwaha]

on your buttons on click event

Call yourButtonsDouble_Click

I didnt understand how I can call an event on the button click

 

[Minty]

if you click the code builder on the on click property in design view on your form.

 

[jai kushwaha]

can anyone tell me what this code mean is??DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70how I can know the number 8 mean in this code??I want full explanation of this code if anyone knows please tell me.thanks in advance....

 

[Uncle Gizmo]

https://msdn.microsoft.com/en-us/library/office/ff822447.aspx

 

[Uncle Gizmo]

Please note the remarks on that page which Direct you to the "RunCommand"

Application.RunCommand Method (Access)

DoMenuItem has been replaced by the run command in MS Access versions 97 and up.

 

[jai kushwaha]

thank you sir for your help can you please tell me how I can add a button on my form which will run an existing event on same form??

 

[Uncle Gizmo]

Which event do you want to run?