Determining When Table last had data entered

#1 (**permalink**) 28-Jul-2006, 08:01 AM

Is there a property of the table or a way to determine when data was last
entered into a table?

Thanks
Gary Townsend
Spatial Mapping Ltd.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9361-determining-when-table-last-had-data.html

*

#2 (**permalink**) 28-Jul-2006, 08:01 AM

Well i think i found my answer i just had to change my search parameters. I
guess teh short answer is not unless i put in a field equivalent to a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361
timestamp.

Gary Townsend
Spatial Mapping Ltd.
"Gary Townsend (Spatial Mapping Ltd.)"
wrote in message news:c7t8g.5730$zn1.2829@clgrps13...
> Is there a property of the table or a way to determine when data was last
> entered into a table?
>
> Thanks
> Gary Townsend
> Spatial Mapping Ltd.
>
>

#3 (**permalink**) 28-Jul-2006, 08:01 AM

Hi Gary,

Add these 2 fields to all your tables (I make them the last
2 fields.

DateCreated, date, DefaultValue = Now()
DateModified, date -- update on the form BeforeUpdate event

the best way to use the DateCreated field is to set a
default value of
=Now()
in the table design.

For Date Modified, make sure it is on your form (I put it in
the form footer and LOCK it). Then, use the Form
BeforeUpdate event to set the value

me.DateModified = now()

This will record when records were created and modified --
then you can write a program to search these fields of your
tables and return the tablename whose record was last changed.

Warm Regards,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day

Gary Townsend (Spatial Mapping Ltd.) wrote:
> Is there a property of the table or a way to determine when data was last
> entered into a table?
>
> Thanks
> Gary Townsend
> Spatial Mapping Ltd.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361
>
>

#4 (**permalink**) 28-Jul-2006, 08:01 AM

Thanks never thought of using the default value that way.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361

Gary Townsend

"strive4peace" wrote in message
news:uryL2xHdGHA.3352@TK2MSFTNGP03.phx.gbl...
> Hi Gary,
>
> Add these 2 fields to all your tables (I make them the last
> 2 fields.
>
> DateCreated, date, DefaultValue = Now()
> DateModified, date -- update on the form BeforeUpdate event
>
> the best way to use the DateCreated field is to set a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361
> default value of
> =Now()
> in the table design.
>
> For Date Modified, make sure it is on your form (I put it in
> the form footer and LOCK it). Then, use the Form
> BeforeUpdate event to set the value
>
> me.DateModified = now()
>
> This will record when records were created and modified --
> then you can write a program to search these fields of your
> tables and return the tablename whose record was last changed.
>
> Warm Regards,
> Crystal
> MVP Microsoft Access
>
> remote programming and training
> strive4peace2006 at yahoo.com
> *
> Have an awesome day

>
>
> Gary Townsend (Spatial Mapping Ltd.) wrote:
> > Is there a property of the table or a way to determine when data was
last
> > entered into a table?
> >
> > Thanks
> > Gary Townsend
> > Spatial Mapping Ltd.
> >
> >

#5 (**permalink**) 28-Jul-2006, 08:02 AM

Per Gary Townsend (Spatial Mapping Ltd.):
>Is there a property of the table or a way to determine when data was last
>entered into a table?

I think you came up with it already.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361

I almost always have four fields at the bottom each tables field list:

CreatedAt [TimeStamp ]
CreatedBy [LAN UserID]
UpdatedAt
UpdatedBy
--
PeteCresswell

#6 (**permalink**) 28-Jul-2006, 08:02 AM

On Wed, 10 May 2006 21:42:32 GMT, "Gary Townsend $Spatial Mapping
Ltd.$" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361

>Is there a property of the table or a way to determine when data was last
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361
>entered into a table?

Not unless you put it there. Access does not record that information.

John W. Vinson[MVP]

#7 (**permalink**) 28-Jul-2006, 08:02 AM

you're welcome, Gary

happy to help
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day

Gary Townsend (Spatial Mapping Ltd.) wrote:
> Thanks never thought of using the default value that way.
>
> Gary Townsend
>
> "strive4peace" wrote in message
> news:uryL2xHdGHA.3352@TK2MSFTNGP03.phx.gbl...
>
>>Hi Gary,
>>
>>Add these 2 fields to all your tables (I make them the last
>>2 fields.
>>
>>DateCreated, date, DefaultValue = Now()
>>DateModified, date -- update on the form BeforeUpdate event
>>
>>the best way to use the DateCreated field is to set a
>>default value of
>>=Now()
>>in the table design.
>>
>>For Date Modified, make sure it is on your form (I put it in
>>the form footer and LOCK it). Then, use the Form
>>BeforeUpdate event to set the value
>>
>>me.DateModified = now()
>>
>>This will record when records were created and modified --
>>then you can write a program to search these fields of your
>>tables and return the tablename whose record was last changed.
>>
>>Warm Regards,
>>Crystal
>>MVP Microsoft Access
>>
>> remote programming and training
>> strive4peace2006 at yahoo.com
>> *
>> Have an awesome day

>>
>>
>>Gary Townsend (Spatial Mapping Ltd.) wrote:
>>
>>>Is there a property of the table or a way to determine when data was
>
> last
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361
>
>>>entered into a table?
>>>
>>>Thanks
>>>Gary Townsend
>>>Spatial Mapping Ltd.
>>>
>>>
>
>
>

#8 (**permalink**) 28-Jul-2006, 08:02 AM

Thanks, Pete

sometimes I add CreatedBy and ModifiedBy ... I like your
shorter names

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361

(PeteCresswell) wrote:
> Per Gary Townsend (Spatial Mapping Ltd.):
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361
>
>>Is there a property of the table or a way to determine when data was last
>>entered into a table?
>
>
> I think you came up with it already.
>
> I almost always have four fields at the bottom each tables field list:
>
> CreatedAt [TimeStamp ]
> CreatedBy [LAN UserID]
> UpdatedAt
> UpdatedBy

#9 (**permalink**) 28-Jul-2006, 08:02 AM

Hi John,

nice, concise answer

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361
strive4peace2006 at yahoo.com
*
Have an awesome day

John Vinson wrote:
> On Wed, 10 May 2006 21:42:32 GMT, "Gary Townsend $Spatial Mapping
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9361
> Ltd.$" wrote:
>
>
>>Is there a property of the table or a way to determine when data was last
>>entered into a table?
>
>
> Not unless you put it there. Access does not record that information.
>
> John W. Vinson[MVP]