Recent content by bethless

Is there a way to list the actions in a macro? I found a way to output the query sql commands using the db.querydefs(i).sql, but I haven't found a way to output what the steps in a macro are. When I convert the macros to visual basic it knows what the steps are so there has to be a way to...

Thanks for the reply. I am using VBA. Here are the sub's that I have for the fields/buttons. Private Sub Close_Click() Dim answer If DataChanged Then answer = MsgBox("Data changed, save data before closing?", 4, "Verify Close Traffic Action") Else answer =...

Does anyone know of a way to check to see if a close button I included in my form is clicked. I have a lostfocus sub that checks data and I don't want it to execute the lostfocus sub if the user clicked the close button (docmd.close). I tried to use getfocus, but the lostfocus happens first...