Welcome

Access Developer 53: Recycle, Docs, Import, MakeDir

S M L XL FS | Slo Reg Fast 2x | Bookmark

In this class, lessons include sending files to the Windows Recycle bin with PowerShell, creating a one-click feature to generate and save Word documents directly from Access, building a recursive function for folder creation, and developing an import folder system to batch import files. This course continues from Developer 51 and 52.

Navigation

Prev: D53
Next: Lesson 1

Next Up

Access Developer 53

Keywords

Access Developer, file drop, error handling, recycle bin system, PowerShell move to Recycle bin, VBA kill command alternative, verify files before deletion, Recycle table, create Word document button, unique Word file names, recursive make-dir function, b

Subscribe to Welcome
Get notifications when this page is updated

Intro

Transcript

Welcome to Microsoft Access Developer Level 53, brought to you by AccessLearningZone.com. I am your instructor, Richard Rost.

In Developer 53, we focus on improving our file drop database by making it safer, cleaner, and more efficient.

We start by tightening up error handling and adding a proper recycle bin system so deleted records and files are handled in a controlled way.

We will then add a one-click feature to create and store a brand new blank Word document directly from Access.

Along the way, we are going to build a reusable, make-dir recursive function to ensure folder paths exist before we use them.

Finally, we will add an import folder system so you can batch import files from a folder - the whole folder - into your database with minimal effort.

By the end, you will have a smoother file workflow and a handful of practical VBA techniques you can apply to your own projects.

This course continues our file drop system that we started in Developer 51 and continued in Developer 52, so definitely watch those two classes first.

Of course, I recommend all of my beginner, expert, advanced, and developer level courses before you take this one. They are designed to be followed in order, so I recommend you do not skip levels.

Currently, it is 2026, I am using Access 365, but you should have no problems with any version going back to 2007 or so.

If you have questions, post them down below, or you can post them in the Access forum. If they are about today's class, post them down below in the questions section, and if it is a general Access question, post it in the forums.

Let's see what is covered in today's lessons.

In lesson one, we are going to send deleted files to the Windows Recycle bin. We are going to use PowerShell to move records and the physical files to the Recycle bin instead of permanently deleting them, which is what happens if you use the VBA kill command. We will walk through all the error handling involved, verifying records and files before deletion, creating a Recycle table to store the deleted records, and then integrating a PowerShell script to send the deleted files to the Windows Recycle bin. This one saves me a lot.

In lesson two, we are going to create a Word document with one click. I am going to show you how to create a button that generates a blank new Word document, automatically names it with a unique file name, saves it to the appropriate customer folder, registers it in your system, and opens it for editing - all with a single click.

I use this a lot because I love to take notes and I love to drop those notes in my task database, which is where I use this file drop stuff. Word documents are great because you can not only have text, but you can put screenshots and other objects right in the Word document, and then it saves it right inside your file drop system. I use it all the time.

Lesson three, we are going to build a recursive make-dir function. This is great if you have a long directory tree that you want to create - for example, Personal, Desktop, Documents, Richard, whatever. You want to make sure that entire nested folder hierarchy is created with one command. That is what we are doing here. We are going to see how to do it recursively.

Then, in lesson four, we are going to build an import folder. Yes, we can drag and drop multiple files directly on our file drop form. But a lot of times when I am working on my machine or even on other systems, I have a shared network folder that I can just drop files to. Then I can go to my database, open up that folder, and just import everything that is in that one folder right into my database. I am going to show you how to do that in this lesson.

Sit back, relax, and get ready for lesson one.

Here we go. Grab your coffee. Oh, and remember, watch the video once all the way through. Then play it a second time and follow along with your database.

Quiz

Q1. What is the primary goal of Developer Level 53 in the Microsoft Access course?
A. Building a new form interface for Access
B. Improving the file drop database to be safer, cleaner, and more efficient
C. Learning SQL basics in Access
D. Creating advanced reports in Access

Q2. What system is introduced in this lesson to handle deleted records and files?
A. A restriction system
B. An auto-backup system
C. A recycle bin system
D. An audit tracking system

Q3. How does the course suggest sending deleted files to the Windows Recycle bin?
A. By using the VBA kill command
B. By writing files to a backup folder
C. By integrating a PowerShell script
D. By moving files to an Archive folder

Q4. What happens when you use the VBA kill command to delete files?
A. Files are archived for later retrieval
B. Files are moved to a backup folder
C. Files are permanently deleted
D. Files are encrypted

Q5. What is the benefit of creating a one-click Word document feature in Access as shown in the course?
A. It creates email draft templates directly in Access
B. It generates a new Word document, saves it, registers it, and opens it for editing with one click
C. It deletes unused documents from the database
D. It sends a Word document via email automatically

Q6. Which VBA technique is taught for ensuring that a nested folder path exists before use?
A. A folder existence check function
B. A recursive make-dir function
C. An error log system
D. A folder renaming script

Q7. Why is a recursive make-dir function useful?
A. It backs up files in subfolders automatically
B. It ensures that entire nested folder structures are created with a single command
C. It summarizes data in reports
D. It encrypts all folders and files

Q8. What is the advantage of the import folder system added in this course?
A. It allows batch importing of files from a folder into the database with minimal effort
B. It exports tables to external folders
C. It locks a folder after importing files
D. It only supports importing CSV files

Q9. What prerequisite courses does Richard Rost recommend before taking Developer 53?
A. None, start directly with Developer 53
B. Only Developer 51 and 52
C. All beginner, expert, advanced, and developer level courses
D. Only the Access 365 course

Q10. What does the instructor suggest about software version compatibility?
A. Only Access 365 is supported
B. The code should work on any version from Access 2007 or newer
C. It only works with Access 2010
D. It requires the Microsoft Access web app

Answers: 1-B; 2-C; 3-C; 4-C; 5-B; 6-B; 7-B; 8-A; 9-C; 10-B

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Access Learning Zone focuses on Microsoft Access Developer Level 53. In this class, I guide you through several improvements to our file drop database, making it more robust, streamlined, and safer to use.

We begin by enhancing our error handling and introducing a true recycle bin system. This solution ensures that when records and associated files are deleted, they are not permanently removed but are instead transferred to a controlled place for potential recovery.

Next, I demonstrate how to add a convenient feature that lets you create and store a new blank Word document straight from Access with just one click. This includes automatically generating a unique file name, saving the document to the correct customer folder, registering the file in your database, and opening it for immediate editing.

During the process, we develop a reusable recursive function to guarantee that any necessary folder structure exists before we attempt to use it. This function checks and builds out the required directory tree, no matter how many nested folders are needed.

Afterward, we set up an import folder feature. This addition allows you to quickly import every file from a selected folder into your Access database in batches, saving substantial time compared to importing files one by one.

By the end of this class, you will have a much more efficient file management workflow within Access, along with practical new techniques in VBA that you can leverage in your own database solutions.

This course builds on the file drop system introduced in Developer 51 and expanded in Developer 52, so I recommend taking those classes first. In fact, I suggest completing all of my beginner, expert, advanced, and developer courses sequentially to get the most out of your learning experience.

I am currently using Access 365 in 2026, though everything covered should work in versions of Access going back to around 2007.

If you have questions specifically about this lesson, please leave them in the questions section below. For more general Access questions, use the Access forum.

Here is an outline of what you will learn in today's lessons:

Lesson one covers sending deleted files to the Windows Recycle bin. Using PowerShell, you will learn to move both records and their associated files to the Recycle bin rather than deleting them outright. We will address comprehensive error handling, double-checking both records and files before deletion, creating a Recycle table to store deleted records, and finally using PowerShell scripts to physically send those files to the Windows Recycle bin. This feature has saved me many headaches in my own work.

In lesson two, you will learn how to create a button in Access that allows the generation of a new Word document with a single click. The system will handle naming the file uniquely, storing it in the appropriate folder, registering the document in your database, and opening it for easy editing. I personally use this feature frequently because it makes it easy to incorporate notes, screenshots, and other objects directly into the Word documents I associate with tasks in my system.

Lesson three is focused on building a recursive make-dir function, which comes in handy when you need to create complex nested folders. With this function, you can ensure that any folder structure your project needs is built out automatically, no matter how deep the hierarchy.

In lesson four, I walk you through setting up an import folder process. While you may already be dragging and dropping multiple files into your database, there are situations - especially with shared network folders - where you would rather import every file from a specific folder at once. I will show you how to bring all the files from a chosen folder simultaneously into your database.

As always, I recommend you sit back for the first viewing of the course to understand the material, and then watch it a second time with your database open so you can follow along step by step.

You can find the complete video tutorial, including detailed, step-by-step instructions for everything I have discussed here, on my website at the link below. Live long and prosper, my friends.

Topic List

Error handling improvements for file deletions
Implementing a recycle bin system in Access
Moving deleted files to Windows Recycle Bin using PowerShell
Creating and using a Recycle table for deleted records
Verifying records and files before deletion
One-click creation of blank Word documents from Access
Generating unique file names for Word documents
Saving Word documents to specific customer folders
Registering new files in the database system
Automating opening of new Word documents for editing
Building a recursive MakeDir VBA function
Creating nested folder hierarchies programmatically
Batch importing all files from a selected folder
Integrating an import folder system into Access