Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Changing Field Value when saving
0 views
Skip to first unread message
Rob Sorfleet
Aug 22, 2003, 10:18:01 AM8/22/03
to
I have just started using access for creating screens to
use with databases. I have a field that holds a date value
which I would like to update with present day's date. The
field isn't part of the form, but I would like it to be
automaticaly updated when the save button is clicked on
the form. I have searched through the help file but to no
avail. Any help would be of great value to me.
use with databases. I have a field that holds a date value
which I would like to update with present day's date. The
field isn't part of the form, but I would like it to be
automaticaly updated when the save button is clicked on
the form. I have searched through the help file but to no
avail. Any help would be of great value to me.
Ketaki
Aug 22, 2003, 11:03:09 AM8/22/03
to
use the now() function for present date.
>.
>
Hugh O'Neill
Aug 22, 2003, 2:46:14 PM8/22/03
to
Rob Sorfleet wrote:
In the Default Value property of the Field in the Table design, put:
=Now()
This will put the current date/time into that Field whenever you create
a new record in that Table.
hth
Hugh
Van T. Dinh
Aug 23, 2003, 1:30:47 AM8/23/03
to
If you use the Field like "UpdatedDateTime" Field, you don't need a Control
on the Form that is bound to the Field. However, you do need the Field to
be included in the RecordSource of the Form.
on the Form that is bound to the Field. However, you do need the Field to
be included in the RecordSource of the Form.
If it is in the RecordSource, use the following:
Me.UpdatedDateTime = Date()
(or Now() if you want to have the time component) just before your save
statement.
HTH
Van T. Dinh
MVP (Access)
"Rob Sorfleet" <r...@cambertown.com> wrote in message
news:0c7301c368b8$31a872a0$a401...@phx.gbl...
0 new messages