MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
I need to add a field to enter a date. This date should stay constant after
entered.
Click to expand...

Ok, add a field. Specify that it is of Date/Time datatype.

Don't edit it after you enter it.

It seems I'm missing something in the question...

John W. Vinson[MVP]
 
what if they accidentally enter the wrong date? they will never be able to
correct it.

-Dorian
 
I think he is assuming that if you enter "a date", the date will keep
changing, automagically, as time passes! (like the date on the
calendar item in the windows taskbar)

Cheers,
TC (MVP Access)
http://tc2.atspace.com
 
John Vinson said:
Ok, add a field. Specify that it is of Date/Time datatype.

Don't edit it after you enter it.

It seems I'm missing something in the question...

John W. Vinson[MVP]
Click to expand...
I have a database that has two lists. One is a pending list and one is an
approved list. When a vendor is approved it can move to the approved list. I
need to add a field to enter the date the vendor was approved.
 
I have a database that has two lists. One is a pending list and one is an
approved list. When a vendor is approved it can move to the approved list. I
need to add a field to enter the date the vendor was approved.
Click to expand...

Ok, just add a Date/Time field to the Approved list. Name it
DateApproved say. Set its Default Value property to

=Date()

On all the Forms which display this information, use a textbox with
its Locked property set to True, so the user cannot edit it.

John W. Vinson[MVP]
 
Back
Top