MS Access

[Guest]

I need to add a field to enter a date. This date should stay constant after
entered.

 

[John Vinson]

I need to add a field to enter a date. This date should stay constant after
entered.

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]

 

[Guest]

what if they accidentally enter the wrong date? they will never be able to
correct it.

-Dorian

 

[TC]

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

 

[Guest]

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]

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.

 

[John Vinson]

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.

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]