In Access 2000, is there a way to record the time in a table when the form is
opened?

Thanks

If you can ensure all data entries / edits are done through the Form and not
DatasheetView of the Table / Query, you can use the Form_BeforeUpdate to
record the "DateTimeUpdated" in conj. with the edit.

HTH
Van T. Dinh
MVP (Access)



"Donna" <(E-Mail Removed)> wrote in message
news:62A99F87-6458-4661-9BE0-(E-Mail Removed)...
> In Access 2000, is there a way to record the time in a table when the form
is
> opened?
>
> Thanks

Not to sound stupid, but no date appears. Am I missing something? I'm using
Access 2000

Thanks,
Donna

"Van T. Dinh" wrote:

> If you can ensure all data entries / edits are done through the Form and not
> DatasheetView of the Table / Query, you can use the Form_BeforeUpdate to
> record the "DateTimeUpdated" in conj. with the edit.
>
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Donna" <(E-Mail Removed)> wrote in message
> news:62A99F87-6458-4661-9BE0-(E-Mail Removed)...
> > In Access 2000, is there a way to record the time in a table when the form
> is
> > opened?
> >
> > Thanks
>
>
>

You have to create a datetime Field "DateUpdated" (or whatever name you want
to use for the Field). In the BeforeUpdate Event of the Form, use:

Me.DateUpdated = Now()

--
HTH
Van T. Dinh
MVP (Access)



"Donna" <(E-Mail Removed)> wrote in message
news:6FE4B59D-84D8-4EB2-9E81-(E-Mail Removed)...
> Not to sound stupid, but no date appears. Am I missing something? I'm
using
> Access 2000
>
> Thanks,
> Donna
>

ok....so assume I'm a moron...

I created a table field entryin my main table: "DateUpdated"

I right clicked the main form properties button (my main form has many
subforms), I typed in me.dateupdated = Now() in the MAIN form beforeupdate
property.

I still cannot see/record the update date in my table...what little step am
I missing?

Thank you so much...
Donna

"Van T. Dinh" wrote:

> You have to create a datetime Field "DateUpdated" (or whatever name you want
> to use for the Field). In the BeforeUpdate Event of the Form, use:
>
> Me.DateUpdated = Now()
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Donna" <(E-Mail Removed)> wrote in message
> news:6FE4B59D-84D8-4EB2-9E81-(E-Mail Removed)...
> > Not to sound stupid, but no date appears. Am I missing something? I'm
> using
> > Access 2000
> >
> > Thanks,
> > Donna
> >
>
>
>

On Wed, 18 May 2005 19:01:02 -0700, "Donna"
<(E-Mail Removed)> wrote:

>ok....so assume I'm a moron...
>
>I created a table field entryin my main table: "DateUpdated"
>
>I right clicked the main form properties button (my main form has many
>subforms), I typed in me.dateupdated = Now() in the MAIN form beforeupdate
>property.
>
>I still cannot see/record the update date in my table...what little step am
>I missing?

What you need to do is click the ... icon by the BeforeUpdate
property; invoke the Code Builder; and insert this line between the
Sub and End Sub lines which Access will provide.

*NOT* obvious until the third or fourth time you need to do it!

John W. Vinson[MVP]

Donna <(E-Mail Removed)> wrote in message
news:6FE4B59D-84D8-4EB2-9E81-(E-Mail Removed)...
> Not to sound stupid, but no date appears. Am I missing something? I'm
using
> Access 2000
>
> Thanks,
> Donna
>
> "Van T. Dinh" wrote:
>
> > If you can ensure all data entries / edits are done through the Form and
not
> > DatasheetView of the Table / Query, you can use the Form_BeforeUpdate to
> > record the "DateTimeUpdated" in conj. with the edit.
> >
> > HTH
> > Van T. Dinh
> > MVP (Access)
> >
> >
> >
> > "Donna" <(E-Mail Removed)> wrote in message
> > news:62A99F87-6458-4661-9BE0-(E-Mail Removed)...
> > > In Access 2000, is there a way to record the time in a table when the
form
> > is
> > > opened?
> > >
> > > Thanks
> >
> >
> >