you could just set it up so that the form does normal insert, but whenever it posts it also checks for any records from more than, say, three days ago.
like so:
sql = "INSERT ......"
adoCon.Execute sql
vDate = DateAdd(d,-3,Now)
sql = "DELETE FROM theTable WHERE theDate <='" & vDate & "'"
adoCon.Execute sql
so every time something is posted, any records from 3 or may days ago are deleted.
just set up your table so that it has a date/time field with a default value of Now(), so it's just a timestamp. If you only want to keep stuff for 24 hours then do:
vDate = DateAdd(h,-24,Now)
sql = "DELETE FROM theTable WHERE theDate < '" & vDate & "'"
adoCon.Execute sql
Edited by ub3rl337ch3ch - 10 May 2005 at 7:25pm
Topic Options
Post Options
Thanks(0)
