Call a procedure from field value

[alcifer_c]

Hello,

I have created a table that has a list of routines that need to be run on daily/weekly etc basis.

main fields are: routine_description, last_run, repetition

Last run is the date that routine was performed and repetition is how many days before it has to run again. When the routine is run, the last update changes to today's date.

I would like to use the value routine_description as the name of a procedure within the form's module but this is presenting some problems since it doesn't look like the routine_description value will be accepted as a procedure...

Here's some abreviated code:

'No problem getting the recordset

With rstim
    .Open strsqlim, cnxnim
    If .BOF = False Then
        Do While Not .EOF
        If !fld_last_run + !fld_repetition <= date Then
        strroutine = !fld_routine_desc
        GoTo strroutine
        .MoveNext
        End If
        Loop
        
    End If
    rstim.Close
End With

dailytracking:

One of the routines is called dailytracking.

Can this even be done? Maybe the strroutine shouldn't be a string but something else?

Much appreciated... Al

 

[richary]

I have to do a similar thing in the near future. I'm going to use "Application.Run"