auto update

[Guest]

does any one know how i can make it so that when a number (15) is inserted into a field in column A, the corresponding field in
column B always enters the date that the certain # was entered into column A.
or a good tutorial will help
im using access 2000 and the generel date/time format
thanks

[Larry Linson]

Re: auto update

I understand you to be asking how this can be made to happen, in Access,
when the datasheet view of a Table is being manually updated. If that is the
situation, I am sorry to have to repeat: you cannot accomplish what you
want.

I thought I had made that clear in my response to your original question.

Something similar to what you want can be done with some server databases,
but the Jet database engine that is Access' default does not support the
"trigger" functionality that would be used. And, your Database
Administrator, in most installations, would not allow an end user direct
access to tables, anyway.

To accomplish this in Access, as I said, you'd have to limit the user to
updating with a Form and use the AfterUpdate event of the numeric column to
execute code that would set the date column.

Larry Linson
Microsoft Access MVP




<jjrmy1@earthli nk.net> wrote in message
news:RTyyc.1096 2$uX2.216@newsr ead2.news.pas.e arthlink.net...[color=blue]
> does any one know how i can make it so that when a number (15) is inserted[/color]
into a field in column A, the corresponding field in[color=blue]
> column B always enters the date that the certain # was entered into[/color]
column A.[color=blue]
> or a good tutorial will help
> im using access 2000 and the generel date/time format
> thanks
>
>
>[/color]

[Larry Daugherty]

Re: auto update

Answered same post in another newsgroup. Please crosspost, by putting list
of newsgroups in one message, rather than multiposting, addressing the same
post individually to more than one newsgroup.

Crossposting means that a response in one newsgroup will propagate to all of
them whereas the multipost route leads to the current situation.

--
-Larry-
--

"Larry Linson" <bouncer@localh ost.not> wrote in message
news:5RMyc.1503 6$tA6.11303@nwr ddc03.gnilink.n et...[color=blue]
> I understand you to be asking how this can be made to happen, in Access,
> when the datasheet view of a Table is being manually updated. If that is[/color]
the[color=blue]
> situation, I am sorry to have to repeat: you cannot accomplish what you
> want.
>
> I thought I had made that clear in my response to your original question.
>
> Something similar to what you want can be done with some server databases,
> but the Jet database engine that is Access' default does not support the
> "trigger" functionality that would be used. And, your Database
> Administrator, in most installations, would not allow an end user direct
> access to tables, anyway.
>
> To accomplish this in Access, as I said, you'd have to limit the user to
> updating with a Form and use the AfterUpdate event of the numeric column[/color]
to[color=blue]
> execute code that would set the date column.
>
> Larry Linson
> Microsoft Access MVP
>
>
>
>
> <jjrmy1@earthli nk.net> wrote in message
> news:RTyyc.1096 2$uX2.216@newsr ead2.news.pas.e arthlink.net...[color=green]
> > does any one know how i can make it so that when a number (15) is[/color][/color]
inserted[color=blue]
> into a field in column A, the corresponding field in[color=green]
> > column B always enters the date that the certain # was entered into[/color]
> column A.[color=green]
> > or a good tutorial will help
> > im using access 2000 and the generel date/time format
> > thanks
> >
> >
> >[/color]
>
>[/color]