Automatic time/dates and locking of table/forms on completion?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple table and form to record projects where I manually input the
time and date, followed by a title of the project and then a remark/comment.
I use the table/form within a larger work recording system.

I would like to be able to have the time and date inserted automatically
from the PC clock and the table/form locked from further amendment on
completion. Basically a simple time/date stamp with comments.

Tom
 
You can use the Now() function in the default value of the date/time field.
I am not sure what you mean by locking the form. I will assume that you wan
to lock that record after all of the fields are filled in. I am not aware of
any way of doing this, but you can set the forms dataentry property to true.
This will only allow the record currently being worked to show on the form.

HTH

Cyberwolf
 
Thanx, just retried the Now() function and it worked fine, somehow when i
tried it before I wasn't having any success.

By locking the form, I want to have the data in the table secure and only
able to amend it if I go back into that record with a password or a
prompt/alert that the record is about to changed.

Tom
 
I have found thyat sometimes I have to save and close a form and reopen it
before some of my coding works. Never have figured out what causes it.

As for your locking, the only thing I could suggest is to repost the part of
your question and see if someone else can help.

Sorry
 
Back
Top