I want to run a macro after a record is added to a table. I was
looking on the property sheet but I don't see that option. Is there
any way to do this? Thanks in advance.

Joe Smith wrote:
Only by using a form. There are no triggers in Jet.
--
HTH,
Bob Barrows

On Nov 22, 10:06*am, "Bob Barrows" <reb01... (AT) NOyahoo (DOT) SPAMcom> wrote:
How can I do it using a form?

On Nov 22, 10:06*am, "Bob Barrows" <reb01... (AT) NOyahoo (DOT) SPAMcom> wrote:
How can I do it by using forms?

Joe Smith wrote:

If you have the property sheet open for the form, not a control, select
Events tab. Then find AfterUpdate. Then enter your macro name.

If you wanted to, you could do something like
Dim blnNewRec as Boolean
at the top of the the form's code module in the declarations section.

In the BeforeUpdate of the event you could enter
blnNewRec = Me.NewRec

Then in the AfterUpdate event
If blnNewRec then Docmd.RunMacro "YourMacroName"

On Mon, 22 Nov 2010 10:06:14 -0500, "Bob Barrows"
<reb01501 (AT) NOyahoo (DOT) SPAMcom> wrote:

There are in ACE and Access 2010.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

Tony Toews wrote:
Next time I'll ask for the OP's version.

--
HTH,
Bob Barrows

"Bob Barrows" <reb01501 (AT) NOyahoo (DOT) SPAMcom> wrote in
news:icere7$pqa$1 (AT) news (DOT) eternal-september.org:

How did you miss the introduction of one of the most important new
features in Jet/ACE in over 10 years? Perhaps you ignored everything
about A2010's introduction?

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

David-W-Fenton wrote:
That's pretty close to the truth, actually. I've been mostly out of Access
development for quite a while. In addition, Office 2010 is nowhere close to
being rolled out in my company - most of us are still happily using 2003,
although there are still pockets of users still working with 2000. So the
only Access development I do these days is with an A2000 application - and
that's mostly maintenance until we roll out a new ASP.Net application with
SQL Server backend.. Keeping current with SQL Server and ASP.Net is
time-consuming enough without also trying to keep current with software I am
likely to never use. :-)

So, that means continuing to be careful to only answer non-A2010-specific
questions in these lists. You'll notice I rarely answer a form- or
report-related queston. I've been having a read through the new database
engine enhancements in 2010 the past couple days so as to avoid this type of
gaffe in the future, but I am under no illusion that it will not happen
again.

On 24/11/2010 13:49:26, "Bob Barrows" wrote:
Couldn't see the point of table macros until I looked at
http://www.youtube.com/watch?v=J3G0ivjpy9k Still not happy about the OP using
table to enter data rather than forms. I always think that tables should
never be accessible to the user as (certainly before Access 2010) the
validation that could be done is pretty limited. Not so sure now

Phil