Public Function vbLf() As String	:	vbLf = Chr(10)	:	End Function

Public Function vbTab() As String	:	vbTab = Chr(9)	:	End Function

REM -----------------------------------------------------------------------------------------------------------------------
Public Function _CurrentDb(ByVal Optional piDocEntry As Integer, ByVal Optional piDbEntry As Integer) As Variant
REM Without arguments same as CurrentDb() except that it generates an error if database not connected (internal use)
REM With 2 arguments return the corresponding entry in Root

Dim oCurrentDb As Object
	If IsEmpty(_A2B_) Then GoTo Trace_Error
	If IsMissing(piDocEntry)	Then Set oCurrentDb = Application.CurrentDb() _
								Else Set oCurrentDb = _A2B_._CurrentDb(piDocEntry, piDbEntry)
	If IsNull(oCurrentDb) Then Goto Trace_Error Else Set _CurrentDb = oCurrentDb

Exit_Function:
	Exit Function	
Trace_Error:
	TraceError(TRACEABORT, ERRDBNOTCONNECTED, Utils._CalledSub(), 0, 1)
	Goto Exit_Function
End Function		'	_CurrentDb	V1.1.0

REM -----------------------------------------------------------------------------------------------------------------------
Private Function _NewCommandBar(psModule As String _
								, psToolbarName As String _
								, psToolbarFullName As String _
								, piBuiltin As Integer _
							) As Object

Dim oObject As Object
	Set oObject = New CommandBar
	With oObject
		._Type = OBJCOMMANDBAR
		._Name = psToolbarName
		._ResourceURL = psToolbarFullName
		._Module = psModule
		._BarBuiltin = piBuiltin
		Select Case UCase(Split(psToolbarFullName, "/")(1))
			Case "MENUBAR"		:	._BarType = msoBarTypeMenuBar
			Case "STATUSBAR"	:	._BarType = msoBarTypeStatusBar
			Case "TOOLBAR"		:	._BarType = msoBarTypeNormal
			Case "POPUP"		:	._BarType = msoBarTypePopup
			Case "FLOATER"		:	._BarType = msoBarTypeFloater
			Case Else			:	._BarType = -1
		End Select
	End With
	Set _NewCommandBar = oObject
	Exit Function

End Function	'	NewCommandBar	V1.3.0

REM -----------------------------------------------------------------------------------------------------------------------
Public Function AllDialogs(ByVal Optional pvIndex As Variant) As Variant
'	Return either a Collection or a Dialog object
'	The dialogs are selected only if library is loaded

	If _ErrorHandler() Then On Local Error Goto Error_Function
Const cstThisSub = "AllDialogs"
	Utils._SetCalledSub(cstThisSub)

Dim iMode As Integer, vDialogs() As Variant, i As Integer, j As Integer, iCount As Integer
Dim oMacLibraries As Object, vAllDialogs As Variant, oLibrary As Object, vNames() As Variant, bFound As Boolean
Dim oLibDialog As Object, sLibrary As String, oDocLibraries As Object, bLocalStorage As Boolean
Dim vLibraries() As Variant, vMacLibraries() As Variant, vDocLibraries() As Variant, oDocMacLib As Object
Dim vCurrentDocument As Variant
Const cstCount = 0
Const cstByIndex = 1
Const cstByName = 2
Const cstSepar = "!"

	If IsMissing(pvIndex) Then
		iMode = cstCount
	Else
		If Not Utils._CheckArgument(pvIndex, 1, Utils._AddNumeric(vbString)) Then Goto Exit_Function
		If VarType(pvIndex) = vbString Then iMode = cstByName Else iMode = cstByIndex
	End If

	Set vAllDialogs = Nothing

	Set vCurrentDocument = _A2B_.CurrentDocument
	If IsNull(vCurrentDocument) Then
		Set oDocLibraries = Nothing
		vDocLibraries = Array()
	Else
		Set oDocLibraries = _A2B_.CurrentDocument.Document.DialogLibraries	'	ThisComponent.DialogLibraries
		vDocLibraries = oDocLibraries.getElementNames()
	End If
	Set oMacLibraries = DialogLibraries
	vMacLibraries = oMacLibraries.getElementNames()
	'Remove Access2Base from the list
	If _A2B_.ExcludeA2B Then
		For i = 0 To UBound(vMacLibraries)
			If Left(vMacLibraries(i), 11) = "Access2Base" Then vMacLibraries(i) = ""
		Next i
	End If
	vMacLibraries = Utils._TrimArray(vMacLibraries)

	If UBound(vDocLibraries) + UBound(vMacLibraries) < 0 Then				'	No library
		Set vAllDialogs = New Collect
		vAllDialogs._CollType = COLLALLDIALOGS
		vAllDialogs._ParentType = OBJAPPLICATION
		vAllDialogs._ParentName = ""
		vAllDialogs._Count = 0
		Goto Exit_Function
	End If
	
	vNames = Array()
	iCount = 0
	For i = 0 To UBound(vDocLibraries) + UBound(vMacLibraries) + 1
		bFound = False
		If i <= UBound(vDocLibraries) Then
			sLibrary = vDocLibraries(i)
			bLocalStorage = True
			Set oDocMacLib = oDocLibraries
			'	Sometimes library not loaded as should ??
			If Not oDocMacLib.IsLibraryLoaded(sLibrary) Then oDocMacLib.loadLibrary(sLibrary)
		Else
			sLibrary = vMacLibraries(i - UBound(vDocLibraries) - 1)
			bLocalStorage = False
			Set oDocMacLib = oMacLibraries
		End If
		If oDocMacLib.IsLibraryLoaded(sLibrary) Then
			Set oLibrary = oDocMacLib.getByName(sLibrary)
			If oLibrary.hasElements() Then
				vDialogs = oLibrary.getElementNames()
				Select Case iMode
					Case cstCount
						iCount = iCount + UBound(vDialogs) + 1
					Case cstByIndex, cstByName
						For j = 0 To UBound(vDialogs)
							If iMode = cstByIndex Then
								If pvIndex = iCount Then bFound = True
								iCount = iCount + 1
							Else
								If UCase(pvIndex) = UCase(vDialogs(j)) Then bFound = True
							End If
							If bFound Then
								Set oLibDialog = oLibrary.getByName(vDialogs(j))	'	Create Dialog object
								Exit For
							End If
						Next j
				End Select						
			End If
		End If
		If bFound Then Exit For
	Next i
	
	If iMode = cstCount Then
		Set vAllDialogs = New Collect
		vAllDialogs._CollType = COLLALLDIALOGS
		vAllDialogs._ParentType = OBJAPPLICATION
		vAllDialogs._ParentName = ""
		vAllDialogs._Count = iCount
	Else
		If Not bFound Then
			If iMode = cstByIndex Then Goto Trace_Error_Index Else Goto Trace_Not_Found
		End If
		Set vAllDialogs = New Dialog
		With vAllDialogs
			._Name = vDialogs(j)
			._Shortcut = "Dialogs!" & vDialogs(j)
			Set ._Dialog = oLibDialog
			._Library = sLibrary
			._Storage = Iif(bLocalStorage, "DOCUMENT", "GLOBAL")
		End With
	End If

Exit_Function:
	Set AllDialogs = vAllDialogs
	Utils._ResetCalledSub(cstThisSub)
	Exit Function
Trace_Not_Found:
	TraceError(TRACEFATAL, ERRDIALOGNOTFOUND, Utils._CalledSub(), 0, , pvIndex)
	Goto Exit_Function
Trace_Error_Index:
	TraceError(TRACEFATAL, ERRCOLLECTION, Utils._CalledSub(), 0, 1)
	Set vDialogs = Nothing
	Goto Exit_Function
Error_Function:
	TraceError(TRACEABORT, Err, cstThisSub, Erl)
	Set vDialogs = Nothing
	GoTo Exit_Function
End Function		'	AllDialogs	V0.9.5

REM -----------------------------------------------------------------------------------------------------------------------
Public Function AllModules(ByVal Optional pvIndex As Variant, ByVal Optional pbAllModules As Boolean) As Variant
'	Return either a Collection or a Module object
'	The modules are selected only if library is loaded
'	(UNPUBLISHED) pbAllModules = False collects only the modules located in the currently open document

	If _ErrorHandler() Then On Local Error Goto Error_Function
Const cstThisSub = "AllModules"
	Utils._SetCalledSub(cstThisSub)

Dim iMode As Integer, vModules() As Variant, i As Integer, j As Integer, iCount As Integer
Dim oMacLibraries As Object, vAllModules As Variant, oLibrary As Object, vNames() As Variant, bFound As Boolean
Dim sScript As String, sLibrary As String, oDocLibraries As Object, sStorage As String
Dim vLibraries() As Variant, vMacLibraries() As Variant, vDocLibraries() As Variant, oDocMacLib As Object
Const cstCount = 0, cstByIndex = 1, cstByName = 2
Const cstDot = "."

	If IsMissing(pvIndex) Then
		iMode = cstCount
	Else
		If Not Utils._CheckArgument(pvIndex, 1, Utils._AddNumeric(vbString)) Then Goto Exit_Function
		If VarType(pvIndex) = vbString Then
			iMode = cstByName
			'	Determine full name STORAGE.LIBRARY.MODULE
			vNames = Split(pvIndex, cstDot)
			If UBound(vNames) = 2 Then
			ElseIf UBound(vNames) = 1 Then
				pvIndex = MODDOCUMENT & cstDot & pvIndex
			ElseIf UBound(vNames) = 0 Then
				pvIndex = MODDOCUMENT & cstDot & "STANDARD" & cstDot & pvIndex
			Else
				GoTo Trace_Not_Found
			End If
		Else
			iMode = cstByIndex
		End If
	End If

	If IsMissing(pbAllModules) Then pbAllModules = True
	If Not Utils._CheckArgument(pbAllModules, 2, vbBoolean) Then Goto Exit_Function

	Set vAllModules = Nothing

	Set oDocLibraries = _A2B_.CurrentDocument.Document.BasicLibraries	'	ThisComponent.BasicLibraries
	vDocLibraries = oDocLibraries.getElementNames()
	If pbAllModules Then
		Set oMacLibraries = GlobalScope.BasicLibraries
		vMacLibraries = oMacLibraries.getElementNames()
		'Remove Access2Base from the list
		If _A2B_.ExcludeA2B Then
			For i = 0 To UBound(vMacLibraries)
'				If Left(vMacLibraries(i), 11) = "Access2Base" Then vMacLibraries(i) = ""
			Next i
		End If
		vMacLibraries = Utils._TrimArray(vMacLibraries)
	End If

	If UBound(vDocLibraries) + UBound(vMacLibraries) < 0 Then				'	No library
		Set vAllModules = New Collect
		vAllModules._CollType = COLLALLMODULES
		vAllModules._ParentType = OBJAPPLICATION
		vAllModules._ParentName = ""
		vAllModules._Count = 0
		Goto Exit_Function
	End If
	
	iCount = 0
	For i = 0 To UBound(vDocLibraries) + UBound(vMacLibraries) + 1
		bFound = False
		If i <= UBound(vDocLibraries) Then
			sLibrary = vDocLibraries(i)
			sStorage = MODDOCUMENT
			Set oDocMacLib = oDocLibraries
			'	Sometimes library not loaded as should ??
			If Not oDocMacLib.IsLibraryLoaded(sLibrary) Then oDocMacLib.loadLibrary(sLibrary)
		Else
			sLibrary = vMacLibraries(i - UBound(vDocLibraries) - 1)
			sStorage = MODGLOBAL
			Set oDocMacLib = oMacLibraries
		End If
		If oDocMacLib.IsLibraryLoaded(sLibrary) Then
			Set oLibrary = oDocMacLib.getByName(sLibrary)
			If oLibrary.hasElements() Then
				vModules = oLibrary.getElementNames()
				Select Case iMode
					Case cstCount
						iCount = iCount + UBound(vModules) + 1
					Case cstByIndex, cstByName
						For j = 0 To UBound(vModules)
							If iMode = cstByIndex Then
								If pvIndex = iCount Then bFound = True
								iCount = iCount + 1
							Else
								If UCase(pvIndex) = UCase(sStorage & cstDot & sLibrary & cstDot & vModules(j)) Then bFound = True
							End If
							If bFound Then
								sScript = oLibrary.getByName(vModules(j))	'	Initiate Module object
								iCount = i
								Exit For
							End If
						Next j
				End Select						
			End If
		End If
		If bFound Then Exit For
	Next i
	
	If iMode = cstCount Then
		Set vAllModules = New Collect
		vAllModules._CollType = COLLALLMODULES
		vAllModules._ParentType = OBJAPPLICATION
		vAllModules._ParentName = ""
		vAllModules._Count = iCount
	Else
		If Not bFound Then
			If iMode = cstByIndex Then Goto Trace_Error_Index Else Goto Trace_Not_Found
		End If
		Set vAllModules = New Module
		vAllModules._Name = vModules(j)
		vAllModules._LibraryName = sLibrary
		Set vAllModules._Library = oLibrary
		vAllModules._Storage = sStorage
		vAllModules._Script = sScript
		vAllModules._Initialize()
	End If

Exit_Function:
	Set AllModules = vAllModules
	Utils._ResetCalledSub(cstThisSub)
	Exit Function
Trace_Not_Found:
	TraceError(TRACEFATAL, ERRMODULENOTFOUND, Utils._CalledSub(), 0, , pvIndex)
	Goto Exit_Function
Trace_Error_Index:
	TraceError(TRACEFATAL, ERRCOLLECTION, Utils._CalledSub(), 0, 1)
	Set vModules = Nothing
	Goto Exit_Function
Error_Function:
	TraceError(TRACEABORT, Err, cstThisSub, Erl)
	Set vModules = Nothing
	GoTo Exit_Function
End Function		'	AllModules	V1.7.0

REM -----------------------------------------------------------------------------------------------------------------------
Public Function CommandBars(Optional ByVal pvIndex As Variant, Optional ByRef poWindow As Object) As Variant
'	Return an object of type CommandBar indicated by its index or its name (CASE-INSENSITIVE string)
'	If no pvIndex argument, return a Collection type
'	(Unpublished) With poWindow, force the frame in which toolbars are detected

	If _ErrorHandler() Then On Local Error Goto Error_Function
Const cstThisSub = "CommandBars"
	Utils._SetCalledSub(cstThisSub)

Dim iObjectsCount As Integer, sObjectName As String, oObject As Object
Dim oWindow As Object, iWindowType As Integer
Dim i As Integer, j As Integer, k As Integer, bFound As Boolean
Dim sSupportedModules() As Variant, vModules() As Variant, oModuleUI As Object
Dim oToolbar As Object, sToolbarName As String, vUIElements() As Variant, sToolbarFullName As String, iBuiltin As Integer

Const cstCustom = "CUSTOM"

	Set oObject = Nothing
	If Not IsMissing(pvIndex) Then
		If Not Utils._CheckArgument(pvIndex, 1, Utils._AddNumeric(vbString)) Then Goto Exit_Function
	End If
			
	iObjectsCount = 0
	bFound = False

	If IsMissing(poWindow) Then Set oWindow = _SelectWindow() Else Set oWindow = poWindow
	If IsNull(oWindow.Frame) Then Goto Trace_WindowError

	'	List of 21 modules
	vModules = CreateUnoService("com.sun.star.frame.ModuleManager").getElementNames()
	
	iWindowType = oWindow.WindowType
	Select Case iWindowType			'	Supported window types only
		Case acForm
			sSupportedModules = Array(	"com.sun.star.sdb.FormDesign"	)
		Case acBasicIDE
			sSupportedModules = Array(	"com.sun.star.script.BasicIDE"	)
		Case acDatabaseWindow
			sSupportedModules = Array(	"com.sun.star.sdb.OfficeDatabaseDocument"	)
		Case acReport
			sSupportedModules = Array(	"com.sun.star.sdb.TextReportDesign"	)
		Case acDocument
			Select Case oWindow.DocumentType
				Case docCalc			:	sSupportedModules = Array(	"com.sun.star.sheet.SpreadsheetDocument"	)
				Case docWriter			:	sSupportedModules = Array(	"com.sun.star.text.TextDocument"	)
				Case docImpress			:	sSupportedModules = Array(	"com.sun.star.presentation.PresentationDocument"	)
				Case docDraw			:	sSupportedModules = Array(	"com.sun.star.drawing.DrawingDocument"	)
				Case docMath			:	sSupportedModules = Array(	"com.sun.star.formula.FormulaProperties"	)
				Case Else				:	sSupportedModules = Array()
			End Select
		Case acTable, acQuery
			sSupportedModules = Array(	"com.sun.star.sdb.DataSourceBrowser" _
										, "com.sun.star.sdb.TableDataView" _
										)
		Case acDiagram
			sSupportedModules = Array(	"com.sun.star.sdb.RelationDesign"	)
		Case acWelcome
			sSupportedModules = Array(	"com.sun.star.frame.StartModule"	)
		Case Else
			sSupportedModules = Array()
	End Select

	'	Find all standard and custom toolbars stored in LibO/AOO Base
	Set oModuleUI = CreateUnoService("com.sun.star.ui.ModuleUIConfigurationManagerSupplier")
	For k = 0 To UBound(vModules)
		For j = 0 To UBound(sSupportedModules)
			iBuiltin = 1		'	Default = builtin
			If vModules(k) = sSupportedModules(j) Then	'	Supported modules only
				Set oToolbar = oModuleUI.getUIConfigurationManager(vModules(k))
				vUIElements() = oToolbar.getUIElementsInfo(0)
				For i = 0 To UBound(vUIElements)
					sToolbarFullName = _GetPropertyValue(vUIElements(i), "ResourceURL")
					sToolbarName = Split(sToolbarFullName, "/")(2)
					If _IsLeft(UCase(sToolbarName), UCase(cstCustom)) Then
						sToolbarName = _GetPropertyValue(vUIElements(i), "UIName")
						iBuiltin = 2
					End If

					iObjectsCount = iObjectsCount + 1
					Select Case True
						Case IsMissing(pvIndex)
						Case VarType(pvIndex) = vbString
							If UCase(pvIndex) = UCase(sToolbarName) Then bFound = True
						Case Else
							If pvIndex < 0 Then Goto Trace_IndexError
							If pvIndex = iObjectsCount - 1 Then bFound = True
					End Select

					If bFound Then
						Set oObject = _NewCommandBar(vModules(k), sToolbarName, sToolbarFullName, iBuiltin)
						Set oObject._Window = oWindow.Frame
						Set oObject._Toolbar = oToolbar
						Goto Exit_Function
					End If
				Next i
			End If
		Next j
	Next k

	'	Find all (not builtin) toolbars stored in current document (typically forms)
	iBuiltin = 3		'	Stored in form itself
	Set oToolbar = oWindow.Frame.Controller.Model.getUIConfigurationManager
	vUIElements() = oToolbar.getUIElementsInfo(0)
	For i = 0 To UBound(vUIElements)
		sToolbarFullName = _GetPropertyValue(vUIElements(i), "ResourceURL")
		sToolbarName = _GetPropertyValue(vUIElements(i), "UIName")
		iObjectsCount = iObjectsCount + 1
		Select Case True
			Case IsMissing(pvIndex)
			Case VarType(pvIndex) = vbString
				If UCase(pvIndex) = UCase(sToolbarName) Then bFound = True
			Case Else
				If pvIndex = iObjectsCount - 1 Then bFound = True
		End Select
		If bFound Then
			Set oObject = _NewCommandBar("", sToolbarName, sToolbarFullName, iBuiltin)
			Set oObject._Window = oWindow.Frame
			Set oObject._Toolbar = oToolbar
			Goto Exit_Function
		End If
	Next i

	'	MISSING : CUSTOM POPUPS <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

	Select Case True
		Case IsMissing(pvIndex)
			Set oObject = New Collect
			oObject._CollType = COLLCOMMANDBARS
			oObject._ParentType = OBJAPPLICATION
			oObject._Count = iObjectsCount
		Case VarType(pvIndex) = vbString
			Goto Trace_NotFound
		Case Else		'	pvIndex is numeric
			Goto Trace_IndexError
	End Select

Exit_Function:
	Set CommandBars = oObject
	Set oObject = Nothing
	Utils._ResetCalledSub(cstThisSub)
	Exit Function
Error_Function:
	TraceError(TRACEABORT, Err, cstThisSub, Erl)
	GoTo Exit_Function
Trace_NotFound:
	TraceError(TRACEFATAL, ERROBJECTNOTFOUND, Utils._CalledSub(), 0, , Array(_GetLabel("COMMANDBAR"), pvIndex))
	Goto Exit_Function
Trace_IndexError:
	TraceError(TRACEFATAL, ERRCOLLECTION, Utils._CalledSub(), 0)
	Goto Exit_Function
Trace_WindowError:
	TraceError(TRACEFATAL, ERRWINDOW, Utils._CalledSub(), 0)
	Goto Exit_Function
End Function	'	CommandBars		V1,3,0

REM -----------------------------------------------------------------------------------------------------------------------
Public Function CurrentDb() As Object
'	Returns _A2B_.CurrentDocument().Database as an object to allow access to its properties

Const cstThisSub = "CurrentDb"
	Utils._SetCalledSub(cstThisSub)

	Set CurrentDb = Nothing
	If IsEmpty(_A2B_) Then GoTo Exit_Function
	Set CurrentDb = _A2B_.CurrentDb()

Exit_Function:
	Utils._ResetCalledSub(cstThisSub)
	Exit Function
End Function	'	CurrentDb		V1.1.0

REM -----------------------------------------------------------------------------------------------------------------------
Public Function DAvg( _
					ByVal Optional psExpr As String _
					, ByVal Optional psDomain As String _
					, ByVal Optional pvCriteria As Variant _
					) As Variant
'	Return average of scope
Const cstThisSub = "DAvg"
	Utils._SetCalledSub(cstThisSub)
	If IsMissing(psExpr) Or IsMissing(psDomain) Then Call _TraceArguments()
	DAvg = Application._CurrentDb()._DFunction("AVG", psExpr, psDomain, Iif(IsMissing(pvCriteria), "", pvCriteria), "")
	Utils._ResetCalledSub(cstThisSub)
End Function	'	DAvg

REM -----------------------------------------------------------------------------------------------------------------------
Public Function DLookup( _
					ByVal Optional psExpr As String _
					, ByVal Optional psDomain As String _
					, ByVal Optional pvCriteria As Variant _
					, ByVal Optional pvOrderClause As Variant _
					) As Variant

'	Return a value within a table
    'Arguments: psExpr:			an SQL expression
    '			psDomain:		a table- or queryname
    '			pvCriteria:		an optional WHERE clause
    '			pcOrderClause:	an optional order clause incl. "DESC" if relevant
    'Return:    Value of the psExpr if found, else Null.
    'Author:    inspired from Allen Browne. http://allenbrowne.com/ser-42.html
    'Examples:
    '           1. To find the last value, include DESC in the OrderClause, e.g.:
    '               DLookup("[Surname] & [FirstName]", "tblClient", , "ClientID DESC")
    '           2. To find the lowest non-null value of a field, use the Criteria, e.g.:
    '               DLookup("ClientID", "tblClient", "Surname Is Not Null" , "Surname")

Const cstThisSub = "DLookup"
	Utils._SetCalledSub(cstThisSub)
	If IsMissing(psExpr) Or IsMissing(psDomain) Then Call _TraceArguments()
	DLookup = Application._CurrentDb()._DFunction("", psExpr, psDomain _
					, Iif(IsMissing(pvCriteria), "", pvCriteria) _
					, Iif(IsMissing(pvOrderClause), "", pvOrderClause) _
					)
	Utils._ResetCalledSub(cstThisSub)
End Function	'	DLookup

REM -----------------------------------------------------------------------------------------------------------------------
Public Function DMin( _
					ByVal Optional psExpr As String _
					, ByVal Optional psDomain As String _
					, ByVal Optional pvCriteria As Variant _
					) As Variant
'	Return minimum of scope
Const cstThisSub = "DMin"
	Utils._SetCalledSub(cstThisSub)
	If IsMissing(psExpr) Or IsMissing(psDomain) Then Call _TraceArguments()
	DMin = Application._CurrentDb()._DFunction("MIN", psExpr, psDomain, Iif(IsMissing(pvCriteria), "", pvCriteria), "")
	Utils._ResetCalledSub(cstThisSub)
End Function	'	DMin

REM -----------------------------------------------------------------------------------------------------------------------
Public Function DStDevP( _
					ByVal Optional psExpr As String _
					, ByVal Optional psDomain As String _
					, ByVal Optional pvCriteria As Variant _
					) As Variant
'	Return standard deviation of scope
Const cstThisSub = "DStDevP"
	Utils._SetCalledSub(cstThisSub)
	If IsMissing(psExpr) Or IsMissing(psDomain) Then Call _TraceArguments()
	DStDevP = Application._CurrentDb()._DFunction("STDDEV_POP", psExpr, psDomain, Iif(IsMissing(pvCriteria), "", pvCriteria), "")	'	STDDEV not STDEV !
	Utils._ResetCalledSub(cstThisSub)
End Function	'	DStDevP

REM -----------------------------------------------------------------------------------------------------------------------
Public Function DVar( _
					ByVal Optional psExpr As String _
					, ByVal Optional psDomain As String _
					, ByVal Optional pvCriteria As Variant _
					) As Variant
'	Return variance of scope
Const cstThisSub = "DVar"
	Utils._SetCalledSub(cstThisSub)
	If IsMissing(psExpr) Or IsMissing(psDomain) Then Call _TraceArguments()
	DVar = Application._CurrentDb()._DFunction("VAR_SAMP", psExpr, psDomain, Iif(IsMissing(pvCriteria), "", pvCriteria), "")
	Utils._ResetCalledSub(cstThisSub)
End Function	'	DVar

REM -----------------------------------------------------------------------------------------------------------------------
Public Function Events(Optional poEvent As Variant) As Variant
'	Return an event object corresponding with actual event

Dim vEvent As Variant
	If _ErrorHandler() Then On Local Error Goto Error_Function
Const cstThisSub = "Events"
	Utils._SetCalledSub(cstThisSub)
	
	Set vEvent = Nothing
	If IsMissing(poEvent) Then Goto Exit_Function
	If IsNull(poEvent) Then Goto Exit_Function

	If Not Utils._CheckArgument(poEvent, 1, vbObject, , False) Then Goto Exit_Function	'	No error handling in CheckArgument
	If Not Utils._hasUNOProperty(poEvent, "Source") Then Goto Trace_Error
	Set vEvent = New Event
	vEvent._Initialize(poEvent)

Exit_Function:
	Set Events = vEvent
	Utils._ResetCalledSub(cstThisSub)
	Exit Function			
Error_Function:
	TraceError(TRACEWARNING, Err, cstThisSub, Erl)
	GoTo Exit_Function
Trace_Error:
	'	Errors are not displayed to avoid display infinite cycling
	TraceError(TRACEFATAL, ERRWRONGARGUMENT, Utils._CalledSub(), 0, False, Array(1, Utils._CStr(poEvent)))
	Set vEvent = Nothing
	Goto Exit_Function
End Function		'	Events	V0.9.1

REM -----------------------------------------------------------------------------------------------------------------------
Function HtmlEncode(ByVal pvString As Variant, ByVal Optional pvLength As Variant) As String
'	Converts a string to an HTML-encoded string.

	If _ErrorHandler() Then On Local Error Goto Error_Function
Const cstThisSub = "HtmlEncode"
	Utils._SetCalledSub(cstThisSub)

	HtmlEncode = ""

Dim sOutput As String, l As Long, lLength As Long
	If IsMissing(pvLength) Then pvLength = 0
	If Not Utils._CheckArgument(pvString, 1, vbString) Then Goto Exit_Function
	If Not Utils._CheckArgument(pvLength, 1, _AddNumeric()) Then Goto Exit_Function

	sOutput = ""
	lLength = CLng(pvLength)
	If Len(pvString) > 0 Then
		For l = 1 To Len(pvString)
			If lLength > 0 And Len(sOutput) > lLength Then Exit For
			sOutput = sOutput & Utils._UTF8Encode(Mid(pvString, l, 1))
		Next l
	End If

	HtmlEncode = sOutput

Exit_Function:
	Utils._ResetCalledSub(cstThisSub)
	Exit Function			
Error_Function:
	TraceError(TRACEABORT, Err, cstThisSub, Erl)
	GoTo Exit_Function
End Function		'	HtmlEncode	V1.4.0

REM -----------------------------------------------------------------------------------------------------------------------
Public Function OpenDatabase ( _
				ByVal Optional pvDatabaseURL As Variant _
				, ByVal Optional pvUser As Variant _
				, ByVal Optional pvPassword As Variant _
				, ByVal Optional pvReadOnly As Variant _
				) As Object
				
'	Return a database object based on input arguments:
'	Call template:
'		Call OpenDatabase("... databaseURL ..."[, "", "", True/False])
'	pvDatabaseURL maby be the name of a registered database or the URL of the targeted .odb file
'	Might be called from any AOO/LibO application, independently from OpenConnection

Dim odbDatabase As Variant, oBaseContext As Object, sDbNames() As String, oBaseSource As Object
Dim i As Integer, bFound As Boolean
Dim sDatabaseURL As String

	If IsEmpty(_A2B_) Then					'	First use of Access2Base in current AOO/LibO session
		Call Application._RootInit()
		TraceLog(TRACEANY, Utils._GetProductName() & " - " & Application.ProductCode(), False)
	End If
	Set OpenDatabase = Nothing
	
	If _ErrorHandler() Then On Local Error Goto Error_Function
Const cstThisSub = "OpenDatabase"
	Utils._SetCalledSub(cstThisSub)
	If pvDatabaseURL = "" Then Call _TraceArguments()
	If Not Utils._CheckArgument(pvDatabaseURL, 1, vbString) Then Goto Exit_Function
	If IsMissing(pvUser) Then pvUser = ""
	If IsMissing(pvPassword) Then pvPassword = ""
	If Not Utils._CheckArgument(pvUser, 2, vbString) Then Goto Exit_Function
	If Not Utils._CheckArgument(pvPassword, 3, vbString) Then Goto Exit_Function
	If IsMissing(pvReadOnly) Then pvReadOnly = False
	If Not Utils._CheckArgument(pvReadOnly, 3, vbBoolean) Then Goto Exit_Function
	
	Set odbDatabase = New Database
	Set odbDatabase._This = odbDatabase
	odbDatabase._DbConnect = DBCONNECTANY

	Set oBaseContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
	sDbNames() = oBaseContext.getElementNames()
	bFound = False
	For i = 0 To UBound(sDbNames())		'	Enumerate registered databases and check non case-sensitive equality
		If UCase(sDbNames(i)) = UCase(pvDatabaseURL) Then
			sDatabaseURL = sDbNames(i)
			Set oBaseSource = oBaseContext.getByName(sDatabaseURL)
			bFound = True
			Exit For
		End If
	Next i
	If Not bFound Then
		sDatabaseURL = ConvertToURL(pvDatabaseURL)
		If UCase(Right(sDatabaseURL, 4)) <> ".ODB" Then Goto Trace_Error
		If Not FileExists(sDatabaseURL) Then Goto Trace_Error
		Set oBaseSource = oBaseContext.getByName(sDatabaseURL)
	End If

	Set odbDatabase.Connection = oBaseSource.getConnection(pvUser, pvPassword)
	If Not IsNull(odbDatabase.Connection) Then				'	Null when standalone and target db does not exist
		Set odbDatabase.MetaData = odbDatabase.Connection.MetaData
		odbDatabase._LoadMetadata()
	Else
		Goto Trace_Error
	End If

	odbDatabase.URL = sDatabaseURL
	
	If pvReadOnly Then
		odbDatabase.Connection.isReadOnly = True
		odbDatabase._ReadOnly = True
	End If

	Set OpenDatabase = odbDatabase
	
	TraceLog(TRACEANY, odbDatabase.MetaData.getDatabaseProductName() & " " & odbDatabase.MetaData.getDatabaseProductVersion, False)
	TraceLog(TRACEANY, UCase(cstThisSub) & " " & odbDatabase.URL, False)
	
	
Exit_Function:
	Utils._ResetCalledSub(cstThisSub)
	Exit Function
Error_Function:
	TraceError(TRACEABORT, Err, cstThisSub, Erl)
	GoTo Exit_Function
Trace_Error:
	TraceError(TRACEABORT, ERRDBNOTCONNECTED, Utils._CalledSub(), 0,1)
	Goto Exit_Function
End Function			'	OpenDatabase		V1.1.0

REM -----------------------------------------------------------------------------------------------------------------------
Public Function SysCmd(Optional pvAction As Variant _
						, Optional pvText As Variant _
						, Optional pvValue As Variant _
						) As Variant
'	Manage progress meter in the status bar
'	Other values supported by MSAccess are ignored	

	If _ErrorHandler() Then On Local Error Goto Error_Function
Const cstThisSub = "SysCmd"
	Utils._SetCalledSub(cstThisSub)
	SysCmd = False

Const cstMissing = -1
Const cstBarLength = 350
	If IsMissing(pvAction) Then Call _TraceArguments()
	If Not Utils._CheckArgument(pvAction, 1, Utils._AddNumeric(), Array( _
				acSysCmdAccessDir _
				, acSysCmdAccessVer _
				, acSysCmdClearHelpTopic _
				, acSysCmdClearStatus _
				, acSysCmdGetObjectState _
				, acSysCmdGetWorkgroupFile _
				, acSysCmdIniFile _
				, acSysCmdInitMeter _
				, acSysCmdProfile _
				, acSysCmdRemoveMeter _
				, acSysCmdRuntime _
				, acSysCmdSetStatus _
				, acSysCmdUpdateMeter _
				)) Then Goto Exit_Function
	If IsMissing(pvValue) Then pvValue = cstMissing
	If Not Utils._CheckArgument(pvAction, 1, Utils._AddNumeric()) Then Goto Exit_Function
	Select Case pvAction
		Case acSysCmdInitMeter, acSysCmdUpdateMeter, acSysCmdSetStatus
			If IsMissing(pvText) Then Call _TraceArguments()
			If Not Utils._CheckArgument(pvText, 2, vbString) Then Goto Exit_Function
		Case Else
	End Select
	If Not Utils._CheckArgument(pvValue, 3, Utils._AddNumeric()) Then Goto Exit_Function
	
Dim vBar As Variant, iLen As Integer
	Set vBar = _A2B_.StatusBar
	Select Case pvAction
		Case acSysCmdAccessVer
			SysCmd = Application.Version()
			Goto Exit_Function
		Case acSysCmdSetStatus
			If pvValue <> cstMissing Then Goto Error_Arg
			iLen = Len(pvText)
			vBar = _NewBar()
			If Not IsNull(vBar) Then vBar.start(Iif(iLen >= cstBarLength, pvText, pvText & Space(cstBarLength - iLen)), 0)
		Case acSysCmdClearStatus
			If pvValue <> cstMissing Then Goto Error_Arg
			If Not IsNull(vBar) Then
				vBar.end()
				Set _A2B_.StatusBar = Nothing
			End If
		Case acSysCmdInitMeter
			If pvValue = cstMissing Then Call _TraceArguments()
			vBar = _NewBar()
			If Not IsNull(vBar) Then vBar.start(pvText, pvValue)
		Case acSysCmdUpdateMeter
			If pvValue = cstMissing Then Call _TraceArguments()
			If Not IsNull(vBar) Then			'	Otherwise ignore !
				vBar.setValue(pvValue)
				If Len(pvText) > 0 Then vBar.setText(pvText)
			End If
		Case acSysCmdRemoveMeter
			If Not IsNull(vBar) Then
				vBar.end()
				Set _A2B_.StatusBar = Nothing
			End If
		Case acSysCmdRuntime
			SysCmd = False
			Goto Exit_Function
		Case Else
	End Select
	
	SysCmd = True

Exit_Function:
	Utils._ResetCalledSub(cstThisSub)
	Exit Function
Error_Function:
	TraceError(TRACEABORT, Err, cstThisSub, Erl)
	GoTo Exit_Function
Error_Arg:
	TraceError(TRACEFATAL, ERRWRONGARGUMENT, Utils._CalledSub(), 0, 1, Array(3, pvValue))
	Goto Exit_Function
End Function	'	SysCmd				V0.9.1

REM -----------------------------------------------------------------------------------------------------------------------
Public Function Version() As String
	Version = Utils._GetProductName()
End Function	'	Version	V0.9.1

REM -----------------------------------------------------------------------------------------------------------------------
Private Function _PropertyGet(ByVal psProperty As String) As Variant
'	Return property value of the psProperty property name

	If _ErrorHandler() Then On Local Error Goto Error_Function
	Utils._SetCalledSub("Collection.get" & psProperty)
	_PropertyGet = Nothing
	
	Select Case UCase(psProperty)
		Case UCase("Count")
			_PropertyGet = _Count
		Case UCase("Item")
		Case UCase("ObjectType")
			_PropertyGet = _Type
		Case Else
			Goto Trace_Error
	End Select
	
Exit_Function:
	Utils._ResetCalledSub("Collection.get" & psProperty)
	Exit Function
Trace_Error:
	TraceError(TRACEWARNING, ERRPROPERTY, Utils._CalledSub(), 0, , psProperty)
	_PropertyGet = Nothing
	Goto Exit_Function
Error_Function:
	TraceError(TRACEABORT, Err, "Collection._PropertyGet", Erl)
	_PropertyGet = Nothing
	GoTo Exit_Function
End Function		'	_PropertyGet

REM -----------------------------------------------------------------------------------------------------------------------
REM --- CONSTRUCTORS / DESTRUCTORS						        														---
REM -----------------------------------------------------------------------------------------------------------------------
Private Sub Class_Initialize()
	_Type = OBJCOLLECTION
	_CollType = ""
	_ParentType = ""
	_ParentName = ""
	Set _ParentDatabase = Nothing
	_Count = 0
End Sub		'	Constructor

Property Get Count() As Long
	Count = _PropertyGet("Count")
End Property		'	Count (get)

REM -----------------------------------------------------------------------------------------------------------------------
Public Sub Dispose()
	Call Class_Terminate()
End Sub		'	Explicit destructor