xf_InteractInteraction

Interact with database objects, the user, external files or external input or output.

Module Sections:

• Character processing
• Current Access file path
• Debugging
• External database selection and cleanup
• Extract data from a database parameter string
• Get various system settings from the registry
• Global Object Collection
• Manipulate file and folder names
• Open and Save File dialog boxes
• Read from and write to text file
• Read/write BLOB
• 'Safe' Functions
• Search filesystem Files and Folders
• Test for existence of database objects
• User confirmations
• Write to log file
• XF Framework functions

Alphabetical List of Methods:

• AddStringToTextFile(Read from and write to text file)
• CleanCloseForm('Safe' Functions)
• CloseExternalDb(External database selection and cleanup)
• ConfirmDelete(User confirmations)
• ConfirmSimple(User confirmations)
• ConfirmTwoStep(User confirmations)
• ConfirmYes(User confirmations)
• CurrentProjectFileName(Current Access file path)
• CurrentProjectFullFilePath(Current Access file path)
• CurrentProjectPath(Current Access file path)
• DbFormExists(Test for existence of database objects)
• DbMacroExists(Test for existence of database objects)
• DbModuleExists(Test for existence of database objects)
• DbObjectExists(Test for existence of database objects)
• DbObjectIsActive(Test for existence of database objects)
• DbObjectIsLoaded(Test for existence of database objects)
• DbQueryExists(Test for existence of database objects)
• DbReportExists(Test for existence of database objects)
• DbTableColumnExists(Test for existence of database objects)
• DbTableExists(Test for existence of database objects)
• DbTableIndexExists(Test for existence of database objects)
• DecodeSpecialAscii(Debugging)
• EncodeSpecialAscii(Debugging)
• ExtractBLOB(Read/write BLOB)
• ExtractBLOB_ADO(Read/write BLOB)
• ExtractBLOBToHexEncodedString(Read/write BLOB)
• FilenameExtensionGet(Manipulate file and folder names)
• FilenameExtensionSet(Manipulate file and folder names)
• FilenameGet(Manipulate file and folder names)
• FolderEnsureExists(Manipulate file and folder names)
• FolderNameFormat(Manipulate file and folder names)
• FolderNameFromPath(Manipulate file and folder names)
• FrameworkIsVisible(XF Framework functions)
• FrameworkShow(XF Framework functions)
• GetCustomInput(User confirmations)
• GetExtDatabase(External database selection and cleanup)
• GetExtDatabaseWithPrevVals(External database selection and cleanup)
• GetIELocalPath(Get various system settings from the registry)
• GetParamStringItem(Extract data from a database parameter string)
• GetProgramFilesFolder(Get various system settings from the registry)
• GetThisComputerName(Get various system settings from the registry)
• HideNavigationBar('Safe' Functions)
• HTMLEncode(Character processing)
• HTMLEncodeChar(Character processing)
• IsVBA7(Get various system settings from the registry)
• IsWin64(Get various system settings from the registry)
• LogClear(Write to log file)
• LogWrite(Write to log file)
• ObjectCollection(Global Object Collection)
• ObjectCollection_Add(Global Object Collection)
• ObjectCollection_GetUniqueKey(Global Object Collection)
• ObjectCollection_Remove(Global Object Collection)
• OpenFileDialog(Open and Save File dialog boxes)
• OpenFileDialog_All(Open and Save File dialog boxes)
• OpenFileDialog_mdb(Open and Save File dialog boxes)
• PrintArray(Debugging)
• ReadStringFromTextFile(Read from and write to text file)
• RecordConfirmIsOn('Safe' Functions)
• RemoveAccessOleHeader(Read/write BLOB)
• ReplaceSpecialShellChars(Character processing)
• Safe_OpenForm('Safe' Functions)
• Safe_OpenReport('Safe' Functions)
• SafeDir('Safe' Functions)
• SafeKillFile('Safe' Functions)
• SafeShell('Safe' Functions)
• SaveFileDialog(Open and Save File dialog boxes)
• SaveFileDialog_All(Open and Save File dialog boxes)
• SaveFileDialog_mdb(Open and Save File dialog boxes)
• SearchForFile(Search filesystem Files and Folders)
• SearchPaths(Search filesystem Files and Folders)
• ShellWithWait('Safe' Functions)
• StoreBLOB(Read/write BLOB)
• StoreBLOB_ADO(Read/write BLOB)
• StoreBLOBFromHexEncodedString(Read/write BLOB)
• UnitTest(Debugging)
• WriteStringToTextFile(Read from and write to text file)