Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / April 2008

Tip: Looking for answers? Try searching our database.

Event procedure

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
binny - 02 Apr 2008 09:49 GMT
Please tell me if I can use the [event procedure] more than once in a form.
If I change the name.  It doesn't work.  If I don't change the name.  The
[event procedure] just moves to from one combo box to the next.  Is there
some way to save a procedure and rename it.
Signature

binny

Brendan Reynolds - 02 Apr 2008 10:17 GMT
> Please tell me if I can use the [event procedure] more than once in a
> form.
> If I change the name.  It doesn't work.  If I don't change the name.  The
> [event procedure] just moves to from one combo box to the next.  Is there
> some way to save a procedure and rename it.

Maybe you mean something like this ...

Option Compare Database
Option Explicit

Private Sub SomeProcContainingCommonCode()

   MsgBox "Common code goes here"

End Sub

Private Sub Form_Close()

   SomeProcContainingCommonCode

End Sub

Private Sub Form_Open(Cancel As Integer)

   SomeProcContainingCommonCode

End Sub

Signature

Brendan Reynolds

binny - 02 Apr 2008 23:26 GMT
OOOO.KKKKK
So it looks like my next move is back to my online Uni to take a course
on VBA
Thanks anyway
Signature

binny

> > Please tell me if I can use the [event procedure] more than once in a
> > form.
[quoted text clipped - 24 lines]
>
> End Sub
Evi - 07 Apr 2008 12:01 GMT
What are you trying to do with the Event Procedure? Remember that you can
not only have Event Procedures in forms, you can also have them individual
controls in the form.
You can also have Subs and Functions in Modules.
I don't know what you mean 'If I change the name' - remember, none of us can
see what you are doing and I for one, don't have a good enough memory or the
time or inclination to hunt through all your previous posts to see what you
wanted to do there. You say 'is there some way to save a procedure and
rename it'.  Much more clarity is needed.

Evi

> Please tell me if I can use the [event procedure] more than once in a form.
> If I change the name.  It doesn't work.  If I don't change the name.  The
> [event procedure] just moves to from one combo box to the next.  Is there
> some way to save a procedure and rename it.
> --
> binny
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.