1. File System Object, Part 6 (24:05)
Get List of Drives (Local and Network)
DriveLetter, AvailableSpace, FileSystem
FreeSpace, RootFolder, Path
TotalSize, VolumeName
DriveType (0=Unknown, 1=Removable, 2=Fixed
3=Network, 4=CDROM, 5=RAM Disk)
SerialNumber - Unique to Each Drive.
DriveExists
GetDrive vs. GetDriveName
Get Free Space on Database Drive
2. File System Object, Part 7 (26:30)
GetParentFolderName
Make Go Up One Folder Button
Stop At Root Folder
GetAbsolutePathName
Determine Current Folder "."
GetBaseName
GetFile vs. GetFileName
Error Handling File Not Found
GetTempName
GetSpecialFolder (0=WindowsFolder, 1=SystemFolder
2=TemporaryFolder)
3. Not In List Event (23:40)
State Table Simple Text
State Table with ID, Name
On Not In List Event
NewData, Response
acDataErrDisplay
acDataErrContinue
acDataErrAdded
SQL to Add Value to Table
Gathering Additional Info
Allow Value List Edits
List Items Edit Form
Data Entry Add Customer Form
After Insert Event
Set Customer on Order Form