how to run 3 different procedures with one dblcklick? (vba-form)

[brigitteAT]

I have already installed 3 buttons which run three different private functions successfully, if I dblclick them one by one (thus I guess I don't hand over arguments form one to another..)



1) Private Sub WEGSUinFlundZILIeintragen_DblClick(Cancel As Integer)
2) Private Sub WEGZuordnen_DblClick(Cancel As Integer)
3) Private Sub WEGinFJeintragen_DblClick(Cancel As Integer)

but now - as they seem to work ok - I would like to run these three procedures with just one dblclick

so I installed butto nr. 4 and tried to find the right syntax to tell access what I want to be done, one after the other....

4) Private Sub WEGkomplett_DblClick()
WEGSUinFlundZILIeintragen
WEGZuordnen
WEGinFJeintragen
End Sub

but it doesn't work that way... and I haven't found any other syntax to do it .. ?!?!?!?!

[Micron]

a) you don't need to double click a button. Single is fine.
b) change the word private to public and see if that works for you. I have only done this a couple of times, so can't recall if you can call as you are doing or if you actually need
Call WEGSUinFlundZILIeintragen or Call (WEGSUinFlundZILIeintragen)

[davegri]

You have to submit the whole names of the procedures:

Private Sub WEGkomplett_DblClick()
    Call WEGSUinFlundZILIeintragen_DblClick
    Call WEGZuordnen_DblClick
    Call WEGinFJeintragen_DblClick
End Sub

[apr pillai]

Call WEGSUinFlundZILIeintragen_DblClick()
Call WEGZuordnen_DblClick()
Call WEGinFJeintragen_DblClick()

[Micron]

Whoops. Forgot that. I was trying to cover the possibility that the call was coming from another form.

[brigitteAT]

You have to submit the whole names of the procedures:

Private Sub WEGkomplett_DblClick()
    Call WEGSUinFlundZILIeintragen_DblClick
    Call WEGZuordnen_DblClick
    Call WEGinFJeintragen_DblClick
End Sub

Private Sub WEGkomplett_DblClick(Cancel As Integer)
Call WEGSUinFlundZILI_Click
Call WEGZuordnen_Click
Call WEGinFJeintragen_Click
End Sub

thank you so much, it now works !!!! - told me error before, for some "dblclick"-reason, but I'm not sure if this was really the reason, because I found out that it also makes "errors" to simply change the name of the procedure in the VBA-Code ... it only works with letting the system name the function and then copy the code inside....

[brigitteAT]

Private Sub WEGkomplett_DblClick(Cancel As Integer)
Call WEGSUinFlundZILI_Click
Call WEGZuordnen_Click
Call WEGinFJeintragen_Click
End Sub

thank you so much, it now works !!!! - told me error before, for some "dblclick"-reason, but I'm not sure if this was really the reason, because I found out that it also makes "errors" to simply change the name of the procedure in the VBA-Code ... it only works with letting the system name the function and then copy the code inside....

[isladogs]

BTW, using Call is OPTIONAL. This will also work:

Private Sub WEGkomplett_DblClick(Cancel As Integer)
   WEGSUinFlundZILI_Click
   WEGZuordnen_Click
   WEGinFJeintragen_Click
End Sub