locked
Code for calling the actual Column history RRS feed

  • Question

  • Hello,

    is there a code to imitate the right click show column history of the actual record - i know the following script:

    S
    ub colhist()
        Dim sHistory As String
        
        sHistory = Application.ColumnHistory("Employees", "Salary", "ID=147")
        Debug.Print sHistory
    End Sub

    But i need the actual record and no debug print but the messagebox that is used by the system.

    Thank you very much and sorry for my english

    Martin

    Sunday, April 1, 2018 9:15 AM

Answers

  • If you want to display the column history dialog, you can set focus to the field you want to inspect, and use

    RunCommand acCmdShowColumnHistory


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Sunday, April 1, 2018 10:20 AM