Automatically populated Modified by table column - Access 2013 (1 Viewer)

L

lwill

New member

Local time

Tomorrow, 04:14

Joined

Dec 17, 2015

Messages

8

• Dec 17, 2015

• #1

Hi all,

I am creating an Access DB, but I would like it to include a modified by column in the table data. Is there a way to have this automatically populated on modification? Thanks Luke

I've put a hidden field in a form for this, and tried the following macro applied to the form:

Code:Copy to clipboard

Private Sub 
Form_BeforeInsert(Cancel As Integer) 
Me.ModifiedBy = Environ("username") ' this is the NT loginID 
End Sub

But it didn't work. I just get a #Name? in the ModifiedBy field.
Does anyone have any ideas.

Thank you

Luke

 

Ranman256

Well-known member

Local time

Today, 14:14

Joined

Apr 9, 2015

Messages

4,339

• Dec 18, 2015

• #2

No, you must run an update query.

 

L

lwill

New member

Local time

Tomorrow, 04:14

Joined

Dec 17, 2015

Messages

8

• Dec 18, 2015

• #3

Hi Ranman,
Can you point me in the right location for this? I'm not sure what kind of update query I need to run.

Thanks
Luke

 

L

lwill

New member

Local time

Tomorrow, 04:14

Joined

Dec 17, 2015

Messages

8

• Dec 18, 2015

• #4

I was playing with some scripts from another question and this one started working now. See "Split form not showing bottom pane when form is in data entry mode" in the forum
Thanks for your help