Automatically Running a Macro when new record added.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have asked many Access experts and so far no one can think of a solution
other than to write this in VB...so here goes...

What I am trying to do is, when a new record 'arrives' into the database I
want to automatically run a macro. The macro just displays a message on the
screen.

Background: WE have developed our own internal helpdesk system. When users
submit requests to IT from a form on their desktops. We want to keep
monitoring the database records and when a new record has entered the system,
we need to inform IT about the new request.
 
Craig said:
Hello,

I have asked many Access experts and so far no one can think of a solution
other than to write this in VB...so here goes...

What I am trying to do is, when a new record 'arrives' into the database I
want to automatically run a macro. The macro just displays a message on the
screen.

Background: WE have developed our own internal helpdesk system. When users
submit requests to IT from a form on their desktops. We want to keep
monitoring the database records and when a new record has entered the system,
we need to inform IT about the new request.
Click to expand...

Can't be done, whether you use macros or VB. The nearest you can get is to
use a form with it's Timer event set to fire at an acceptable interval. The
Timer event would need to be programmed to check whether any new records
have arrived since it last fired. If so, it displays the message box.

I've no idea whether that can be done by running a macro when the Timer
event fires (I've never written an Access macro, and I never intend to), but
it wouldn't be terribly difficult with VBA.
 
Craig

"monitoring the database records" can't be done directly, as there is no
"event" associated with a new record lobbing into a table. Is there any
reason why the notification to the IT can't be triggered from the user's
desktop application at the same time that they lodge their request?
 
Back
Top