Locking the Time & Date fields in a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 27 Oct 2003 13:57 GMT

Similar to Jerry's question....

I am trying to create an automatic numbering system for
Work Orders. I am using a combination of date and time to
create a unique number. I want to automatically insert it
in form. I want it in the locked portion of the form, so
I only need to tab through the name and address fields.
It works fine the first time, but each time I open the
work order, it automatically updates the time and date and
changes my unique number. How do I keep this field from
being updated and still keep it a form?

Reply to this Message

Charles Kenyon - 28 Oct 2003 02:01 GMT

Unlock your form, click on the date field that is a part of your number.
Press Alt-F9 to view field codes and change the TIME or DATE field to a
CREATEDATE field. Press F9 to update the field and then Alt-F9 to get rid of
the field code view. Lock your form again. The only way that field should
change is if you use SaveAs to save to save your document.

Signature

Charles Kenyon

Word New User FAQ & Web Directory:
<URL: http://addbalance.com/word/index.htm>

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://addbalance.com/usersguide/index.htm>

See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> Similar to Jerry's question....
>
[quoted text clipped - 7 lines]
> changes my unique number. How do I keep this field from
> being updated and still keep it a form?

Reply to this Message