Access - Macros Issues

[PrettyMess]

Hi All

Would anyone know how to link a stand alone macro to automatically run against a table or query?

I have tried most other methods and none of them really do what I am looking so this is a last ditch effort

Any help would be greatly appreciated.

Thanks Paula

 

[Norie]

Paula

What do you mean by a 'stand alone' macro?

Also, in what way would you want to link the macro to the table/query?

PS Couldn't you refer to the specific table/query in the macro?

 

[PrettyMess]

I am looking for an email with object attached to be sent each time the 'username table' is updated however the only way I can find of doing this is through creating a basic macro I have linked it to the 'username table' in the sense that it will now send an email but I cannot get it to work when the 'username table' is updated.
The only way I could see round this would be to put it into the after insert function on the table itself but I cant seem to find a way to link this.

 

[Norie]

Do you mean you want to run a macro automatically when a table is updated?

 

[PrettyMess]

that's it exactly - however there is a bit of a catch with it as this table automatically updates so I don't want any user interaction in this table so to speak

best way to explain is:

All Information table is linked to a user form - these changes update to all information table - they also replicate into an audit table - and then replicate into my username table.

 

[Norie]

I'm afraid Access doesn't have any triggers/events for tables/queries.

How exactly is the automatic update happening?

Could you perhaps call/run the macro from the userform?

 

[PrettyMess]

Would it work any better if I swapped from a table/query to a report? is there anyway to trigger these?

Currently the automatic updates are taking place through after insert and after update macros.

I cant really push this from the user form as there is no submit button so to speak and a lot more information stored on the form than what I require to go out in the email.

 

[Norie]

Can't you just run the email macro from either the after insert or after update macro?

 

[PrettyMess]

I thought I could with the SendEmail function inside both of these macros but it doesn't seem to work correctly, It doesn't allow you to attach a document to the email.

 

[Norie]

Have you tried using RunMacro to run the 'stand alone' macro from one of the update/insert macros?