← Back to context

Comment by blargthorwars

2 months ago

Friendly reminder for MS Access fiends:

It's ok to store code in tables and then pass it to VBA for evaluation via Eval, or to ASF via the engine.Compile

6 comments

blargthorwars

Reply
cyanydeez  2 months ago

But what if i want to debug my code?

  • blargthorwars  2 months ago

    Great question! Programmatically copy your snippet to a module, then call it:

    Public Sub AppendCode() Dim cm As Object Set cm = Application.VBE.VBProjects(1).VBComponents("GeneratedLogic").CodeModule

        cm.InsertLines cm.CountOfLines + 1, _
        "Public Sub NewProc()" & vbCrLf & _
        "    MsgBox ""Dynamically added""" & vbCrLf & _
        "End Sub"

    End Sub

  • n013  2 months ago

    You can inspect the AST in order to debug your code. For syntax highlighting, use tools like Notepad++ (ASF shares most of the syntax with Javascript). Each piece of code is commented, no obscure machine code.