Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Developer > D35 > < D34 | D36 >
Access Developer 35

File System Object Lessons 6-7, Not In List

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


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.


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.


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.


Comments for Access Developer 35
Age Subject From
37 daysTemplate MentionedSandra Truax
2 yearsFile pickerAbraham Breuer


Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to Access Developer 35
Get notifications when this page is updated

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/23/2024 10:51:18 PM. PLT: 1s
Keywords: access developer 35 Get List of Drives DriveLetter AvailableSpace FreeSpace TotalSize VolumeName DriveType SerialNumber DriveExists GetDrive GetDriveName Get Free Space on Database Drive GetParentFolderName Go Up One Folder Stop At Root Folder GetAbsolute  Page Tag: whatsnew  PermaLink  Microsoft Access Developer 35