Hello,
I want to create a traceable/auditable process on our data entries.
I created a module to do the following -
When using the ModulePrivate Sub SaveSlidebtn_Click()
Globals.Saving "Data Insertion"
End Sub
This turned out to be a problem as it's not updating already existing entries that users are working on, but creating an entire new one (I create the entries that will be analysed, so all of them will be already existing entries!)Public Sub Saving(Activity As String)
CurrentDb.Execute "INSERT INTO Micro_Analysis (UserName, Activity, TimeStamp) Values ('" & TempVars("UserName").Value & "', '" & Activity & "', Now())"
End Sub
The text boxes in the subform's red square are not enabled to prevent edition from users, and I would like the Save button to write the TempVars("UserName") and Now() on the text boxes if the value is Null.
I was wandering if there is any command to write the information in a "me.UserNametxt" and "me.QCDate" sort of way.
TL;DR
How do I write the data inside that text box which is specific to the entry?
Also in all tests that I have now Now() hasn't worked a single time! Any tips on how to write the date properly?
Kind regards