Writing a Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nmarano - 25 Feb 2005 13:23 GMT

I have an app that needs to be archived pretty often. We are currently have
to go in, open the form, and click on the button which calls a module, that
runs the function slf_monthend(). Can someone tell me if I can simply set up
a macro which opens the module, and runs the code of the slf_monthend()
function? Any help would be appreciated
Thanks

Reply to this Message

Steve Schapel - 25 Feb 2005 18:10 GMT

Nmarano

Yes, this is certainly possible. I guess the applicable macro action
would be RunCode. You could have a simple one-field one-record table
where you store the date if the last time it was run, and then, at a
suitable time (for example every time the database is opened) have your
macro check the date in this table to determine whether it was due for
the function to be run again. But anyway, I would need more specific
detail before I could be difinitive.

Signature

Steve Schapel, Microsoft Access MVP

> I have an app that needs to be archived pretty often. We are currently have
> to go in, open the form, and click on the button which calls a module, that
> runs the function slf_monthend(). Can someone tell me if I can simply set up
> a macro which opens the module, and runs the code of the slf_monthend()
> function? Any help would be appreciated
> Thanks

Reply to this Message