1. File System Object, Part 3 (32:50)
CopyFolder, MoveFolder
DeleteFolder does NOT send to Recycle Bin
Deletes ALL Files and Subfolders
Again, check FolderExists or Error Handling
Force for Read Only Files/Folders
List all Files in Folder
FileExists, CopyFile, DeleteFile, MoveFile
CopyFile with Wildcards
CopyFile with Files Collection Loop
Copy based on Size, Date, etc.
GetExtensionName
2. File System Object, Part 4 (29:59)
TextStream Objects for Text Only (not binary)
OpenTextFile, CreateTextFile
ASCII vs. Unicode Text
WriteLine write a whole line of text with a CR/LF
Write writes the text without a CR/LF
Write out Customer Data File
Loop through controls on form
For Each C in Me.Controls
Tag property, Control Name, Value
Send Email with Outlook
DoCmd.SendObject acSendNoObject
Outlook.Application, MailItem
Converting Outlook code from Early to Late binding
3. File System Object, Part 5 (36:02)
OpenTextFile
ForReading (1) DEFAULT
ForWriting (2)
ForAppending (8)
Create if file doesn't already exist
TristateFalse (0) = Open as ASCII file DEFAULT
TristateMixed (-2) = Open either ASCII or Unicode
TristateTrue (-1) = Open as Unicode file
ReadLine, ReadAll, Read(X)
Read char by char method
AtEndOfLine, Column, Skip, SkipLine
Read back in Customer file changes