Auto date for revised records
From: Marguerita (anonymous_at_discussions.microsoft.com)
Date: 07/22/04
- Next message: Shiji: "Press Return in ComboBox Messed up Subform Record"
- Previous message: Reggie: "Re: Corrupt form...or so it seems"
- In reply to: Bob: "Auto date for revised records"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 22 Jul 2004 13:21:35 -0700
Thank you. I found my error. I put coding in the event
of the field not the form. I have been at this too long
today. Thanks again for you time.
>-----Original Message-----
>I don't see why that wouldn't work. The code seems to
work
>alright in my document control database.
>
>Private Sub Form_BeforeUpdate(Cancel As Integer)
> Me.[ReviseDate] = Now()
>End Sub
>
>I would suggest to have the field locked.
>
>>-----Original Message-----
>>Hello all,
>>
>>I have a database which I use for document tracking. It
>>is now recommended for use by all. I have two date
>fields
>>in the form. 1) When the document was received, this
they
>>can input themselves. 2)An update date, when additional
>>information is supplied at a later time. I manually
enter
>>this. Now that it will be accessed by many, to maintain
>>consistancy in the process, I would like to have this
>done
>>automatically. I have tried setting the form's
>>BeforeUpdate event to Now...with no luck. Could some one
>>assist me as to where or what I am doing wrong?
>>
>>Thanks
>>
>>M~
>>.
>>
>.
>
- Next message: Shiji: "Press Return in ComboBox Messed up Subform Record"
- Previous message: Reggie: "Re: Corrupt form...or so it seems"
- In reply to: Bob: "Auto date for revised records"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
