Member Avatar for LeNenne

Hi How to kill a file in this format

kill App.Path & "\backup\backup\PhoneTel.mdb" & Format(Now, "yymmdd_hhnn") & ".mdb"

Lenny

  • 3 Contributors
  • 3 Replies
  • 149 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by LeNenne
Member Avatar for demon916

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 because: formatting
Member Avatar for Jx_Man

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.

Member Avatar for LeNenne

Okej Thanks I will try it

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.