I am trying to call some macros in Access 2010 using a loop, but get an error message before I can even step into it.
I could manually run all of the macros, but this seems tedious and I can't figure out why this isn't working!
I have macros names UpdateTableProcess5_ACD, UpdateTableProcess6_ACD, UpdateTableProcess7_ACD etc. up to UpdateTableProcess44_ACD.
I have written the following code, but this generates the following error...
Compile Error: Expected Sub, Function or Property
Dim strMacro As String
Dim i As Integer
For i = 5 To 44
strMacro = "UpdateTblProcess" & i & "_ACD"
Does anyone have any ideas how to work around this?