Search results

techid is all lowercase. It's a short text data type. Display Control is Text Box. It appears on the form as a blank text box when not in design mode.

Am I supposed to be entering this in the field's expression builder? It gives me three choices. Expression, code, and macro.

Okay. I am using Access 2016 if that makes any difference. I've split the DB as well. Entering Private Sub Form_BeforeUpdate(Cancel As Integer) Me![techid] = Environ("UserName") End Sub into before update gives me an invalid syntax error.

Putting that as a default value in the table's field's Default Value parameter returns an error message. "Unknown function 'Environ' in validation expression or default value on (field name)"

Hello. I have created a database for a minimum of ten users to log into simultaneously and add records via a form. All of the records need to have the respective usernames appended to the records to show they were the ones entering the data. How do I get access to do this? Do I really need to...