Writing a Macro

[nmarano]

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

 

[Steve Schapel]

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.