|
 |
access_asp thread: Automatic Deletion of Expired Records
Message #1 by "Matthew Wiens" <design@e...> on Tue, 21 Aug 2001 15:35:54
|
|
I need my Access database to be able to delete records when the date in my
ExpiryDate field comes up. Could someone please help me with this, it is
quite urgent, any help would be greatly appreciated.
Thank you.
Message #2 by Roger Balliger <Roger@i...> on Tue, 21 Aug 2001 09:57:30 -0700
|
|
After your recordset is created, use the .Find method for your recordset to
match the record in the dbase with your ExpiryDate. Then use the .Delete
method to delete the record. DO you want to delete all records matching the
ExpiryDate? IF so, the procedure will have to be looped to step through
each record or filtered to only look at the matching records.
ROger
-----Original Message-----
From: Matthew Wiens [mailto:design@e...]
Sent: Tuesday, August 21, 2001 8:36 AM
To: Access ASP
Subject: [access_asp] Automatic Deletion of Expired Records
I need my Access database to be able to delete records when the date in my
ExpiryDate field comes up. Could someone please help me with this, it is
quite urgent, any help would be greatly appreciated.
Thank you.
Message #3 by "Spencer Saunders" <ssaunders@i...> on Tue, 21 Aug 2001 13:57:45 -0400
|
|
this might help
http://www.programmersresource.com/tips/tip093.asp
spence
----- Original Message -----
From: Matthew Wiens <design@e...>
To: Access ASP <access_asp@p...>
Sent: August 21, 2001 3:35 PM
Subject: [access_asp] Automatic Deletion of Expired Records
> I need my Access database to be able to delete records when the date in my
> ExpiryDate field comes up. Could someone please help me with this, it is
> quite urgent, any help would be greatly appreciated.
>
> Thank you.
>
|
|
|
View Cart
