Is there anything like an actionlis

[Biomechanoids]

Is there anything like an actionlistener or oncommand in VBA? My Problem is: every time a new datasheet in Access is created I want a subprocedure to run.

So from the principle the thing would work like this:


If (methodidontknow) Then GoTo Sub easyloop

Sub easyloop ()
MsgBox "New datasheet was created"


In Java there is the ActionListener method that would perform something like this.

Greetings

Thomas

 

[Junior1544]

I think what you are looking for is a trigger... and there are no triggers in access...

Not that I know of any way...

One way to do this would be to on the load of the database, open a form that is hidden...

and in the on timer event (say every 5 seconds) count the number of object type you are looking for, and if the number changes, then display the message box...

Just an idea... I don't know code to count objects, but I think if you can get that down you will be set...

Just my two cents...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[cmmrfrds]

You could check into the WithEvents keyword. You would need to use Class Modules to make use of it. Also, you would probably need to create the data sheets from within the class module so that you control when the data sheets open.

Link.

http://www.vb2themax.com/NLItem.asp?PageID=NewsletterBank&ID=460