File System Object Lessons 6-7, Not In List

Welcome

This class will finish up our study of the File System Object (for now). We will also learn how to use the Not In List event. What happens when someone wants to add a value to a combo box or list box? We'll see how to tackle that in this class.

Resources

• Full Course Lessons Page
• Course Topic Outline

Topics Covered

In Lesson 1, we will continue our work with the File System Object. We will learn how to get a list of available drives on the system and their properties (total space, space available, volume name, file system type, etc.) We will see how to read the drive's unique serial number which can be useful for anti-piracy measures. We'll learn to check if a drive exists, which is handy for making sure your users are connected to the database network server drive. We will learn about the GetDrive and GetDriveName functions and how they're different. We'll learn to check the available file space on the drive the database is located on, which can be useful in making sure you have enough storage space for your database.

In Lesson 2, we will learn how to get the parent folder of a specific file or folder. We'll make a button to go up to the parent path (all the way to the root folder). We'll see how to determine the current folder for read/write operations. We'll see the different between GetFile and GetFileName. We'll learn how to quickly generate temporary filenames. And, we'll see how to get the "special" folders (Windows, System, Temp).

In Lesson 3, we will learn how to use the Not In List event. What happens when someone wants to add a value to a combo box or list box? You have to close the form you're on. Go to that table. Add the value. Go back to the form. Select the item. It's a pain. In this lesson I'll show you two different ways to handle this. You can use a List Items Edit Form or you can handle it with a little VBA code and the On Not In List event with a touch of SQL. 

Enroll Today

Enroll now so that you can watch these lessons, learn with us, post questions, and more.

Questions?

Please feel free to post your questions or comments below. If you are not sure as to whether or not this product will meet your needs, I'd rather help you before you buy it. Remember, all sales are final. Thank you.