3
Contributors
3
Replies
20
Views
4 Years
Discussion Span
Last Post by LeNenne
0

That should work for you...? Although how would you catch the exact minute of the file name.

Format(Now,"yymmdd_hhnn")

This would give you the minute of it's execution...

If you used;

"PhoneTel.mdb" & Format(Now, "yymmdd_hhnn") & ".mdb"

somewhere else in your code to create this file, you should be saving it at that time to a variable then "Killing" the file via that variable string value.
Let me know if I am making any sense or perhaps I just don't understand your codes circumstances...?

Edited by demon916: formatting

0

It's hard to do it if you don't know the exact time when the file is saved.
About this case, i think better to have form to manage backup files, so you can choose any backup files to be deleted.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.