Thank you for the reply...as far as the delete query, just to make sure I am
doing this right, how am I to run a delete query? I thought I was pretty good
with access but I am not sure how to do that.....
"Nikos Yannacopoulos" wrote:
To begin with, the correct (general) answer is the one Lynn gave: don't
delete.
Of course, this being a general answer, there might be exceptions.
In that case: no code required! Just a simple delete query, with a
criterion like Date() - 30 on the date field, and an autoexec macro to
run it, will do the job just fine.
HTH,
Nikos
NetworkTrade wrote:
mmmmm - well I will be interested to see what code others will share on this.
In general there has to be a "run" to create some sort of action as
otherwise the db is just sitting there i.e. it does do anything on its own
per se.
With a query based on the table then it would be easy to have the criteria
as defined by date and then upon open of the db/query it would always recalc
each time and then the data would be manipulated away in terms of the query
result (on which a form or report would be based) but the data would still be
in the table.
but there are alot of smarter folk out there than I so......
|