Can I run an Access macro on submission of an Infopath form?

D

Dan Allason

Hi there,

I would liketo be able to run an Access macro that emails a report to me
when the number of submissions from an Infopath form to the database reaches
a certain number. As far as I can see, the only way to get Access to run a
Macro is if you open the database and click on it. The best way would be for
the macro to be run everytime a new submission is made and for there to be a
condition on the SendObject action so that it is only carried out if the
number of records is greater than say 10. Does anyone have any ideas about
this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

InfoPath 2013 crashes when trying to connect to Access 2016 DB 0
Submitting Form Data to Access Database 1
Access 2007 Macro Conditions 1
AUTOEXEX Macro - Check OS or Access Version BEFORE Enable MACRO Security 0
Report base on a query from a form? 8
Access 2007 - Overflow + error 2950 when running a macro 10
Calling Access 'form' from other applications 0
Access 2007 Macros - SendObject action, Message Text action argume 7

Top