Set time limit For a record?

[DirtDawg]

Hello all,

I woudl like to be able to set a time limit for a record to be accessed. After the timie limit has been reached the record is deleted. Anyone have ideas?

Thanks in advance

 

[KenReay]

Hi

In your table definition declare a column of type date/time, (datCreated), with a default value of Date() Or Now(), use Date() if you just want to delete based on days old, if yo want to go down to hours or minutes use Now()

As part of your start up of your database run a query to delete all records older thatn specified time eg

DELETE * FROM MyTable WHERE datCreated <= DateAdd(&quot;d&quot;,-1,Date())

to delete all records 1 day old or older

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[amcodah]

This should help.


Sub Form_Load()
Me.TimerInterval = 1000 '1sec
End Sub

Sub Form_Timer()
DoCmd.RunSQL &quot;DELETE FROM table_name WHERE column_name = some_value;&quot;
End Sub


~amcodah()