I'm using Access 2000. I am making a copy of a table before making modifications to it with;
dim varDate as Date
varDate = Now()
docmd.copyobject "", "table" & varDate, acTable, "table"
What I would like to do is have a second part of code that will look at the varDate part of the table name and delete the object if it is 3 months old. Can this be done?
Thanks,
Moxy
dim varDate as Date
varDate = Now()
docmd.copyobject "", "table" & varDate, acTable, "table"
What I would like to do is have a second part of code that will look at the varDate part of the table name and delete the object if it is 3 months old. Can this be done?
Thanks,
Moxy