insert user and date into table

  • Thread starter Thread starter j_70
  • Start date Start date
J

j_70

I have a text field that is the combination of user and
date/time. So for the control source I have CurrentUser()
& Now(). How do I assign this to a column in my table. TIA
 
Thanks for the help. The problem is that concetenated to
these values, I have two values that come from two list
boxes (state,month) so the full string is =[StateName]
& '.' & [ReportMonth] & '.' & Now() & CurrentUser(). This
does not work with setting time and user as default.
 
Table Field values must be atomic, i.e. the Field value stores only a single
item of data, NOT 2 or more items as per the First Normal Form.

Use 2 Fields in your destination Table!

--
HTH
Van T. Dinh
MVP (Access)



j_70 said:
Thanks for the help. The problem is that concetenated to
these values, I have two values that come from two list
boxes (state,month) so the full string is =[StateName]
& '.' & [ReportMonth] & '.' & Now() & CurrentUser(). This
does not work with setting time and user as default.
-----Original Message-----
Put CurrentUser() & Now() in the default value property and change the
control source to a field in the table.

HTH,
Josh
Click to expand...
Click to expand...
 
Back
Top