Delete Temporary Files Automatically with VBA Kill

In this Microsoft Access tutorial, I'm going to teach you how to delete files using the VBA Kill command. Then I'll show you how to automatically delete temporary files when you close your database.

Adrian from Berwyn, Illinois (a Platinum Member) asks: I'm using the code that you showed in your "Export Report to PDF" video, and it works great, thank you! I'm able to send these PDFs in emails, but, after doing a bunch of them, I've got all these PDF files sitting around in my database folder. Is there a quick and easy way to delete them all from my database?

Members

Members will learn how to use a PowerShell script to delete files and send them to the recycle bin, which the normal Kill command does not do.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Export Reports to PDF
• Intro to VBA

Recommended Courses

• Access Developer Courses
• Access Developer 30
• Access Developer 31

Code Vault Link

• Delete To Recycle Bin

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, VBA Kill command, delete temporary files, automatic file deletion, VBA file handling, on close event, delete PDF files, automate cleanup, Export Report to PDF, manage database folder, file deletion in Access, Access database cleanup, temp file cleanup, Order Invoice report, CurrentProject.Path, wildcard deletion, recycle bin