Recording User in Audit Trail

[DVoosen]

Hi,

I'm fairly new to all this. I don't know code. I do everything with
the development screens. With that said, I need to record the user
in a multi-user database in the audit trail record, i.e., who made the
change. There will be a sign in form. Do I need to have both the
computer ID and the User ID in memory? How do I create unique holding
variables? I hope you understand what I am asking for.

Thanks for your help!

Darlene

 

[Arvin Meyer [MVP]]

You can build a form that the user logs in to, then use an OK button to hide
the form. The relevant code would be (untested):

Sub cmdOK_OnClick
Me.Visible = False
End Sub

 

[DVoosen]

You can build a form that the user logs in to, then use an OK button to hide
the form. The relevant code would be (untested):

Sub cmdOK_OnClick
    Me.Visible = False
End Sub
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com









- Show quoted text -

Thanks for your help!

Darlene