Re: Getting Date Only

Sorry, you said after update for the FIELD, not the FORM.



--
Rick B



"Rick B" <Anonymous> wrote in message
news:%23VaM9hpSFHA.1160@xxxxxxxxxxxxxxxxxxxxxxx
> AFTER update fires AFTER you have updated (saved) the record.
>
> Do it in the BEFORE update evnet, and it should be,,,
>
> dteDatedClosed = Date()
>
>
>
>
> --
> Rick B
>
>
>
> "CyndyG" <CyndyG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:111DD283-05BF-44A5-9562-0C7DC01766CB@xxxxxxxxxxxxxxxx
> > I can not get the date to appear in a field automatically after a
certain
> > event occurs. Here is the code:
> >
> > AfterUpdate for strRequestStatus Field
> > If Me.strRequestStatus = "Closed" Then
> > dteDatedClosed = Date
> > End If
> >
> > I have tried on lost focus,
> > I have tried using Date(), have tried setiing the date to short date,or
> > formatting to mm/dd/yyyy.
> > At one point I clicked in the field the date showed up,but went away
when
> I
> > saved the form.
> >
> > This is the same code I used in another database using Now() instead
with
> no
> > problem.
> >
> >
> >
> >
> >
>
>


.

Relevant Pages

  • Re: Form Timer
    ... AFTER UPDATE fires after the record ... You would need code in your BEWFORE UPDATE event that will put the current ... Rick B ... > TRIED ON EXIT AND AFTER UPDATE but they don't seem to ...
    (microsoft.public.access.forms)
  • Re: Getting Date Only
    ... AFTER update fires AFTER you have updated the record. ... Do it in the BEFORE update evnet, and it should be,,, ... Rick B ... > formatting to mm/dd/yyyy. ...
    (microsoft.public.access.formscoding)
  • Re: Remove Password
    ... "Rick B" wrote: ... This assumes that he created a new workgroup before playing around ... so secure no one could get in!! ... Adding userid's and passwords to a workgroup does not secure a database ...
    (microsoft.public.access.security)
  • Re: As a generale rule - Query or VBA?
    ... I agree with you Rick, I was recently working on a database that had ... the query is saved, then JET will save the fastest execution path. ...
    (comp.databases.ms-access)
  • Re: only display certain query results
    ... That is how you'd do it in a spreadsheet, not a database. ... Rick B ... >>> a specific course for all employees, ...
    (microsoft.public.access.reports)