Access 2000 - Current Date

  • Thread starter Thread starter t
  • Start date Start date
T

t

I have this excel spreadsheet that contains field columns identical to an
Access database table. Simply to allow the copy (excel data) and paste (in
access table) function.
The only difference is that there is no Date Received column in excel but is
present in the Access table. This is intentional for certain reasons.
I want to be able to paste the data in the table and THEN add the current
date against the records in the access table.
Problem: I don't want to simply type the current date for every record in
the access table. Is there an automated way in which the current date can be
entered against the records pasted in access table ?
thanks.
 
Well, you can make the current date the default value by adding Date() in
the Default property of the field. Then each new record will have the
current date entered automatically. Of course this will happen ANY time a
new record is created, but it can be changed after the fact.
 
Back
Top