Difference between revisions of "Microsoft Access modSetting"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
+ | [[Category:Microsoft Access]] | ||
+ | [[Category:VBA]] | ||
=== debugPrintUserRunTimeSettings === | === debugPrintUserRunTimeSettings === | ||
<syntaxhighlight lang="vb"> | <syntaxhighlight lang="vb"> |
Latest revision as of 15:46, 15 July 2010
debugPrintUserRunTimeSettings
Public Sub debugPrintUserRunTimeSettings()
Dim arrSetting() As String
Dim intIndex As Integer
Debug.Print
Debug.Print "User RunTime Settings"
Debug.Print "---------------------"
On Error GoTo handleGetAllSettingsError
arrSetting = GetAllSettings(getProjectName, "RunTime")
On Error GoTo 0
For intIndex = LBound(arrSetting) To UBound(arrSetting)
Debug.Print arrSetting(intIndex, 0) & " : " & arrSetting(intIndex, 1)
Next
Exit Sub
handleGetAllSettingsError:
Debug.Print "No user settings available."
End Sub
deleteUserSettings
Public Sub deleteUserSettings()
Debug.Print
Debug.Print "User Settings"
Debug.Print "-------------"
On Error Resume Next
DeleteSetting getProjectName
Debug.Print "All user settings deleted."
End Sub