Run Coomand as a macro

[aftershokk]

I have a button that will run command5 when cliked.
How do I create a macro for this.
I cannot seem to get it to work?
thanks,.

 

[IMO]

Need a little more info than that. What does the command do? What's the code behind the command? Why would you want to change code to a macro?

IMO

 

[aftershokk]

reply

I am using a Db developed by someone else. When the command button is clicked a file is exported and I want an auto e-mail to notify someone of the export. I thought a macro would work?
thanks,

 

[IMO]

Look up SendObject in Access help. You can add to the code behind the button. Also search for "email" here, there are some good examples around. If you need more help, send a stripped down version of your db and I'll look for you.

IMO

 

[aftershokk]

thanks

I guess I am not explaining this correctly. I will try to figure it out.