| Class: Images |
| How to Read: Property/Method(Parameter As Type, ...) As ReturnValue |
| General Properties |
| ErrorMsg() As String Purpose: Return Error Message if a method failed or no records were found |
| ErrorMsg(ErrorMessage As String) Purpose: Set Error Message for display |
| SQLString() As String Purpose: Return SQL String used for database query |
| ImagePath() As String Purpose: Return Image Path after calling CreateImagePath() |
| File Handling Properties and Methods |
| Image Handling Properties and Methods |
| General Methods |
| CreateImagePath(PictureFilePath As String, FilenameOrContactID As String) As String Purpose: Create Image Path w/ correct Folder Number extracted from Filename or Contact ID Requires: Complete Filename (i.e, 980001A.jpg) w/wo letter designator or Contact ID Returns: Complete Path w/ Folder Number |
| ExtractFileName(PictureFilePath As String) As String Purpose: Extract Filename from complete path - ExtractFileName(""E:\mls_voyager_pictures\980001A.jpg"") returns '980001A.jpg' Requires: Complete Path\Filename Returns: Filename - successful; False - error |
| ExtractLetter(Filename As String) As String Purpose: Extract the Letter Designator from a filename ExtractLetter(""980001A.jpg"") returns 'A' Requires: Complete Filename (i.e, 980001A.jpg) w/ letter designator Returns: Letter - successful; * - no letter found; False - error |
| ExtractFolderNo(FilenameOrContactID As String) As Integer Purpose: Extract the Folder Number (right-most number) from a filename or valid Contact ID ExtractLetter(""980001A.jpg"") returns '1' ExtractLetter(""980001"") returns '1' Requires: Complete Filename (i.e, 980001A.jpg) w/wo letter designator or Contact ID Returns: Number - successful; (-1) - error or no number found |
| ExtractContactID(Filename As String) As Long Purpose: Extract the Contact ID from a filename ExtractLetter(""980001A.jpg"") returns '980001' Requires: Complete Filename (i.e, 980001A.jpg) w/wo letter designator Returns: Contact ID - successful; (-1) - error or no number found |
| ConvertLetterToValue(Letter As String) As Long Purpose: Convert Letter Designator to a number value (up to AYZ or 1352) Requires: Letter (up to AYZ) Returns: Number - successful; 0 - error |
| ConvertValueToLetter(Number As Long) As String Purpose: Convert number value to a Letter Designator (1 to 1352 or A to AYZ) Requires: Whole Number (1 to 1352) Returns: Letter - successful; Empty String - error |
| GetNextLetter(PictureFilePath As String, ContactID As String) As String Purpose: Searches file system for files with Contact ID in filename, then finds highest letter designator and returns the lext letter (up to AYZ) Requires: Complete Path; Contact ID Returns: Letter - successful; Empty String - no files found; False - error |