Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   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

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

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.

 

Comments for Access Developer 35
 
Age Subject From
2 monthsFile pickerAbraham Breuer

 

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

8/17/2022Append Mistake #2
8/15/2022Append Mistake #1
8/12/2022Transpose Data
8/11/2022Crosstab
8/9/2022Append Query
8/8/2022Indexing
8/5/2022No Data
8/4/2022Secondary Emails
8/1/2022Limit Long Text
7/29/2022Validation Rules
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access developer 35  Page Tag: whatsnew  PermaLink  Microsoft Access Developer 35