Re: Access Date/Time

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Joe Sutphin (joesu_at_belvac.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 13:19:24 -0500

That's a good tip, but what about records that already exist? I need to know
when they were added.

Joe 

--
"Jeff Boyce" <JeffBoyce_IF@msn.com-DISCARD_HYPHEN_TO_END> wrote in message
news:%23BqwOsPDEHA.240@tk2msftngp13.phx.gbl...
> Joe
>
> Open the table in design mode.  Add a DateCreated (date/time) field.  Set
> the Default property of that new field to:
>
>     =Now()
>
> Everytime a new row is added, the DateCreated will be populated.
>
> -- 
> Good luck
>
> Jeff Boyce
> <Access MVP>
>

Relevant Pages

  • Re: My First Attempt at a Rampage Fails
    ... On Feb 7 2006 7:06 PM, Joe Long wrote: ... for a game that's supposed to reduce the luck factor in gambling, ...
    (rec.gambling.poker)
  • Re: O.T Message from The Queen
    ... "Joe" wrote in message ... Fine, given what IM has done to spelling, good luck with this. ... What about Costner's 50 seconds worth of an English accent in Robin Hood? ...
    (rec.woodworking)
  • Re: LSASS.EXE error - server shuts down once a week
    ... I've had good luck on the site ... Joe wrote: ... Ran sasser cleaning tools - found nothing Patched system. ... It will suck if I have to give it a reformat, due to the fact that this server is across the country. ...
    (microsoft.public.windows.server.networking)
  • Re: For Madge
    ... Christmas songs you wanted. ... No luck I am afraid, ... I did reply to Joe earlier........ ...
    (uk.people.silversurfers)
  • Re: cannot log on from welcome screen
    ... Best of Luck, ... Windows help - www.rickrogers.org ... "Joe T" wrote in message ... Also tried to startup with last known ...
    (microsoft.public.windowsxp.help_and_support)