Date In - Date Up ???

[caljohn527]

Datein – Dateup
Hi, all

I have a table with 2 fields
One is call datein ( This is a date field and will never change )( LOCK )
One is call dateup ( This is a date field and will change when every someone opens
( go's to update this file .)

And that is my question how do I Lock One, and let the other one change.

Thank You For all The Help ......

Access 2002 and SQL 2003 Server.

Johnny C

 

[SQL_Hell]

You have a table with 2 fields (datein,dateup), is there any primary key on this table?

If you want the Datein field to not be updated, then don't display it on your form or query, or if you need to display it set the property of the text box to 'locked = Yes'

 

[caljohn527]

Hi SQL Hell

I have a table with 15 fields two are (datein,dateup), none of the dates are a primary key on this table.

I do need to display both (dates ) in my form

datein / right click / properties / locked = yes ( This Works )
Tables datein / default Value = (getdate() / Formula Blank / Format = longdate /

dateup / right click / properties / locked = No ( not updating to new )
Tables dateup / default Value = (getdate() / Formula Blank / Format = longdate

What do you think about this .

Johnny C.

 

[SQL_Hell]

Yep that looks ok, then maybe do an after_update event on the from to set the text box for dateup to now()