wizards/source/access2base/acConstants.xba

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
   3 <script:module xmlns:script="http://openoffice.org/2000/script" script:name="acConstants" script:language="StarBasic">
   4 REM =======================================================================================================================
   5 REM ===                                 The Access2Base library is a part of the LibreOffice project.                                                                   ===
   6 REM ===                                 Full documentation is available on http://www.access2base.com                                                                   ===
   7 REM =======================================================================================================================
   8
   9 Option Explicit
  10
  11 REM Access2Base -----------------------------------------------------
  12 Global Const Access2Base_Version = &quot;6.4.0&quot;            &apos;  Alignment on LibreOffice versions
  13
  14 REM AcCloseSave
  15 REM -----------------------------------------------------------------
  16 Global Const acSaveNo = 2
  17 Global Const acSavePrompt = 0
  18 Global Const acSaveYes = 1
  19
  20 REM AcFormView
  21 REM -----------------------------------------------------------------
  22 Global Const acDesign = 1
  23 Global Const acNormal = 0
  24 Global Const acPreview = 2
  25
  26 REM AcFormOpenDataMode
  27 REM -----------------------------------------------------------------
  28 Global Const acFormAdd = 0
  29 Global Const acFormEdit = 1
  30 Global Const acFormPropertySettings = -1
  31 Global Const acFormReadOnly = 2
  32
  33 REM acView
  34 REM -----------------------------------------------------------------
  35 Global Const acViewDesign = 1
  36 Global Const acViewNormal = 0
  37 Global Const acViewPreview = 2
  38
  39 REM acOpenDataMode
  40 REM -----------------------------------------------------------------
  41 Global Const acAdd = 0
  42 Global Const acEdit = 1
  43 Global Const acReadOnly = 2
  44
  45 REM AcObjectType
  46 REM -----------------------------------------------------------------
  47 Global Const acDefault = -1
  48 Global Const acDiagram = 8
  49 Global Const acForm = 2
  50 Global Const acQuery = 1
  51 Global Const acReport = 3
  52 Global Const acTable = 0
  53 &apos;                  Unexisting in MS/Access
  54 Global Const acBasicIDE = 101
  55 Global Const acDatabaseWindow = 102
  56 Global Const acDocument = 111
  57 Global Const acWelcome = 112
  58 &apos;                  Subtype if acDocument
  59 Global Const docWriter = &quot;Writer&quot;
  60 Global Const docCalc = &quot;Calc&quot;
  61 Global Const docImpress = &quot;Impress&quot;
  62 Global Const docDraw = &quot;Draw&quot;
  63 Global Const docMath = &quot;Math&quot;
  64
  65 REM AcWindowMode
  66 REM -----------------------------------------------------------------
  67 Global Const acDialog = 3
  68 Global Const acHidden = 1
  69 Global Const acIcon = 2
  70 Global Const acWindowNormal = 0
  71
  72 REM VarType constants
  73 REM -----------------------------------------------------------------
  74 Global Const vbEmpty = 0
  75 Global Const vbNull = 1
  76 Global Const vbInteger = 2
  77 Global Const vbLong = 3
  78 Global Const vbSingle = 4
  79 Global Const vbDouble = 5
  80 Global Const vbCurrency = 6
  81 Global Const vbDate = 7
  82 Global Const vbString = 8
  83 Global Const vbObject = 9
  84 Global Const vbBoolean = 11
  85 Global Const vbVariant = 12
  86 Global Const vbByte = 17
  87 Global Const vbUShort = 18
  88 Global Const vbULong = 19
  89 Global Const vbBigint = 35
  90 Global Const vbDecimal = 37
  91 Global Const vbArray = 8192
  92
  93 REM MsgBox constants
  94 REM -----------------------------------------------------------------
  95 Global Const vbOKOnly = 0                       &apos;  OK button only (default)
  96 Global Const vbOKCancel = 1             &apos;  OK and Cancel buttons
  97 Global Const vbAbortRetryIgnore = 2 &apos;      Abort, Retry, and Ignore buttons
  98 Global Const vbYesNoCancel = 3          &apos;  Yes, No, and Cancel buttons
  99 Global Const vbYesNo = 4                        &apos;  Yes and No buttons
 100 Global Const vbRetryCancel = 5          &apos;  Retry and Cancel buttons
 101 Global Const vbCritical = 16            &apos;  Critical message
 102 Global Const vbQuestion = 32            &apos;  Warning query
 103 Global Const vbExclamation = 48         &apos;  Warning message
 104 Global Const vbInformation = 64         &apos;  Information message
 105 Global Const vbDefaultButton1 = 128     &apos;  First button is default (default) (VBA: 0)
 106 Global Const vbDefaultButton2 = 256 &apos;      Second button is default
 107 Global Const vbDefaultButton3 = 512 &apos;      Third button is default
 108 Global Const vbApplicationModal = 0 &apos;      Application modal message box (default)
 109 REM MsgBox Return Values
 110 REM -----------------------------------------------------------------
 111 Global Const vbOK = 1                           &apos;  OK button pressed
 112 Global Const vbCancel = 2                       &apos;  Cancel button pressed
 113 Global Const vbAbort = 3                        &apos;  Abort button pressed
 114 Global Const vbRetry = 4                        &apos;  Retry button pressed
 115 Global Const vbIgnore = 5                       &apos;  Ignore button pressed
 116 Global Const vbYes = 6                          &apos;  Yes button pressed
 117 Global Const vbNo = 7                           &apos;  No button pressed
 118
 119 REM Dialogs Return Values
 120 REM ------------------------------------------------------------------
 121 Global Const dlgOK = 1                          &apos;  OK button pressed
 122 Global Const dlgCancel = 0                      &apos;  Cancel button pressed
 123
 124 REM Control Types
 125 REM -----------------------------------------------------------------
 126 Global Const acCheckBox = 5
 127 Global Const acComboBox = 7
 128 Global Const acCommandButton = 2        :       Global Const acToggleButton = 122
 129 Global Const acCurrencyField = 18
 130 Global Const acDateField = 15
 131 Global Const acFileControl = 12
 132 Global Const acFixedLine = 24                   &apos;  FREE ENTRY (USEFUL IN DIALOGS)
 133 Global Const acFixedText = 10           :       Global Const acLabel = 10
 134 Global Const acFormattedField = 1               &apos;  FREE ENTRY TAKEN TO NOT CONFUSE WITH acTextField
 135 Global Const acGridControl = 11
 136 Global Const acGroupBox = 8                     :       Global Const acOptionGroup = 8
 137 Global Const acHiddenControl = 13
 138 Global Const acImageButton = 4
 139 Global Const acImageControl = 14        :       Global Const acImage = 14
 140 Global Const acListBox = 6
 141 Global Const acNavigationBar = 22
 142 Global Const acNumericField = 17
 143 Global Const acPatternField = 19
 144 Global Const acProgressBar = 23                 &apos;  FREE ENTRY (USEFUL IN DIALOGS)
 145 Global Const acRadioButton = 3          :       Global Const acOptionButton = 3
 146 Global Const acScrollBar = 20
 147 Global Const acSpinButton = 21
 148 Global Const acSubform = 112
 149 Global Const acTextField = 9            :       Global Const acTextBox = 9
 150 Global Const acTimeField = 16
 151
 152 REM AcRecord
 153 REM -----------------------------------------------------------------
 154 Global Const acFirst = 2
 155 Global Const acGoTo = 4
 156 Global Const acLast = 3
 157 Global Const acNewRec = 5
 158 Global Const acNext = 1
 159 Global Const acPrevious = 0
 160
 161 REM FindRecord
 162 REM -----------------------------------------------------------------
 163 Global Const acAnywhere = 0
 164 Global Const acEntire = 1
 165 Global Const acStart = 2
 166 Global Const acDown = 1
 167 Global Const acSearchAll = 2
 168 Global Const acUp = 0
 169 Global Const acAll = 0
 170 Global Const acCurrent = -1
 171
 172 REM AcDataObjectType
 173 REM -----------------------------------------------------------------
 174 Global Const acActiveDataObject = -1
 175 Global Const acDataForm = 2
 176 Global Const acDataQuery = 1
 177 Global Const acDataServerView = 7
 178 Global Const acDataStoredProcedure = 9
 179 Global Const acDataTable = 0
 180
 181 REM AcQuitOption
 182 REM -----------------------------------------------------------------
 183 Global Const acQuitPrompt = 0
 184 Global Const acQuitSaveAll = 1
 185 Global Const acQuitSaveNone = 2
 186
 187 REM AcCommand
 188 REM -----------------------------------------------------------------
 189 Global Const acCmdAboutMicrosoftAccess = 35
 190 Global Const acCmdAboutOpenOffice = 35
 191 Global Const acCmdAboutLibreOffice = 35
 192 Global Const acCmdVisualBasicEditor = 525
 193 Global Const acCmdBringToFront = 52
 194 Global Const acCmdClose = 58
 195 Global Const acCmdToolbarsCustomize = 165
 196 Global Const acCmdChangeToCommandButton = 501
 197 Global Const acCmdChangeToCheckBox = 231
 198 Global Const acCmdChangeToComboBox = 230
 199 Global Const acCmdChangeToTextBox = 227
 200 Global Const acCmdChangeToLabel = 228
 201 Global Const acCmdChangeToImage = 234
 202 Global Const acCmdChangeToListBox = 229
 203 Global Const acCmdChangeToOptionButton = 233
 204 Global Const acCmdCopy = 190
 205 Global Const acCmdCut = 189
 206 Global Const acCmdCreateRelationship = 150
 207 Global Const acCmdDelete = 337
 208 Global Const acCmdDatabaseProperties = 256
 209 Global Const acCmdSQLView = 184
 210 Global Const acCmdRemove = 366
 211 Global Const acCmdDesignView = 183
 212 Global Const acCmdFormView = 281
 213 Global Const acCmdNewObjectForm = 136
 214 Global Const acCmdNewObjectTable = 134
 215 Global Const acCmdNewObjectView = 350
 216 Global Const acCmdOpenDatabase = 25
 217 Global Const acCmdNewObjectQuery = 135
 218 Global Const acCmdShowAllRelationships = 149
 219 Global Const acCmdNewObjectReport = 137
 220 Global Const acCmdSelectAll = 333
 221 Global Const acCmdRemoveTable = 84
 222 Global Const acCmdOpenTable = 221
 223 Global Const acCmdRename = 143
 224 Global Const acCmdDeleteRecord = 223
 225 Global Const acCmdApplyFilterSort = 93
 226 Global Const acCmdSnapToGrid = 62
 227 Global Const acCmdViewGrid = 63
 228 Global Const acCmdInsertHyperlink = 259
 229 Global Const acCmdMaximumRecords = 508
 230 Global Const acCmdObjectBrowser = 200
 231 Global Const acCmdPaste = 191
 232 Global Const acCmdPasteSpecial = 64
 233 Global Const acCmdPrint = 340
 234 Global Const acCmdPrintPreview = 54
 235 Global Const acCmdSaveRecord = 97
 236 Global Const acCmdFind = 30
 237 Global Const acCmdUndo = 292
 238 Global Const acCmdRefresh = 18
 239 Global Const acCmdRemoveFilterSort = 144
 240 Global Const acCmdRunMacro = 31
 241 Global Const acCmdSave = 20
 242 Global Const acCmdSaveAs = 21
 243 Global Const acCmdSelectAllRecords = 109
 244 Global Const acCmdSendToBack = 53
 245 Global Const acCmdSortDescending = 164
 246 Global Const acCmdSortAscending = 163
 247 Global Const acCmdTabOrder = 41
 248 Global Const acCmdDatasheetView = 282
 249 Global Const acCmdZoomSelection = 371
 250
 251 REM AcSendObjectType
 252 REM -----------------------------------------------------------------
 253 Global Const acSendForm = 2
 254 Global Const acSendNoObject = -1
 255 Global Const acSendQuery = 1
 256 Global Const acSendReport = 3
 257 Global Const acSendTable = 0
 258
 259 REM AcOutputObjectType
 260 REM -----------------------------------------------------------------
 261 Global Const acOutputTable = 0
 262 Global Const acOutputQuery = 1
 263 Global Const acOutputForm = 2
 264 Global Const acOutputArray = -1
 265
 266 REM AcEncoding
 267 REM -----------------------------------------------------------------
 268 Global Const acUTF8Encoding = 76
 269
 270 REM AcFormat
 271 REM -----------------------------------------------------------------
 272 Global Const acFormatPDF = &quot;writer_pdf_Export&quot;
 273 Global Const acFormatODT = &quot;writer8&quot;
 274 Global Const acFormatDOC = &quot;MS Word 97&quot;
 275 Global Const acFormatHTML = &quot;HTML&quot;
 276 Global Const acFormatODS = &quot;calc8&quot;
 277 Global Const acFormatXLS = &quot;MS Excel 97&quot;
 278 Global Const acFormatXLSX = &quot;Calc MS Excel 2007 XML&quot;
 279 Global Const acFormatTXT = &quot;Text - txt - csv (StarCalc)&quot;
 280
 281 REM AcExportQuality
 282 REM -----------------------------------------------------------------
 283 Global Const acExportQualityPrint = 0
 284 Global Const acExportQualityScreen = 1
 285
 286 REM AcSysCmdAction
 287 REM -----------------------------------------------------------------
 288 Global Const acSysCmdAccessDir = 9
 289 Global Const acSysCmdAccessVer = 7
 290 Global Const acSysCmdClearHelpTopic = 11
 291 Global Const acSysCmdClearStatus = 5
 292 Global Const acSysCmdGetObjectState = 10
 293 Global Const acSysCmdGetWorkgroupFile = 13
 294 Global Const acSysCmdIniFile = 8
 295 Global Const acSysCmdInitMeter = 1
 296 Global Const acSysCmdProfile = 12
 297 Global Const acSysCmdRemoveMeter = 3
 298 Global Const acSysCmdRuntime = 6
 299 Global Const acSysCmdSetStatus = 4
 300 Global Const acSysCmdUpdateMeter = 2
 301
 302 REM Type property
 303 REM -----------------------------------------------------------------
 304 Global Const dbBigInt = 16
 305 Global Const dbBinary = 9
 306 Global Const dbBoolean = 1
 307 Global Const dbByte = 2
 308 Global Const dbChar = 18
 309 Global Const dbCurrency = 5
 310 Global Const dbDate = 8
 311 Global Const dbDecimal = 20
 312 Global Const dbDouble = 7
 313 Global Const dbFloat = 21
 314 Global Const dbGUID = 15
 315 Global Const dbInteger = 3
 316 Global Const dbLong = 4
 317 Global Const dbLongBinary = 11  &apos;  (OLE Object)
 318 Global Const dbMemo= 12
 319 Global Const dbNumeric = 19
 320 Global Const dbSingle = 6
 321 Global Const dbText = 10
 322 Global Const dbTime = 22
 323 Global Const dbTimeStamp = 23
 324 Global Const dbVarBinary = 17
 325 Global Const dbUndefined = -1
 326
 327 REM Attributes property
 328 REM -----------------------------------------------------------------
 329 Global Const dbAutoIncrField = 16
 330 Global Const dbDescending = 1
 331 Global Const dbFixedField = 1
 332 Global Const dbHyperlinkField = 32768
 333 Global Const dbSystemField = 8192
 334 Global Const dbUpdatableField = 32
 335 Global Const dbVariableField = 2
 336
 337 REM OpenRecordset
 338 REM -----------------------------------------------------------------
 339 Global Const dbOpenForwardOnly = 8
 340 Global Const dbSQLPassThrough = 64
 341 Global Const dbReadOnly = 4
 342
 343 REM Query types
 344 REM -----------------------------------------------------------------
 345 Global Const dbQAction = 240
 346 Global Const dbQAppend = 64
 347 Global Const dbQDDL = 4 &apos;96
 348 Global Const dbQDelete = 32
 349 Global Const dbQMakeTable = 128 &apos;80
 350 Global Const dbQSelect = 0
 351 Global Const dbQSetOperation = 8        &apos;128
 352 Global Const dbQSQLPassThrough = 1      &apos;112
 353 Global Const dbQUpdate = 16     &apos;48
 354
 355 REM Edit mode
 356 REM -----------------------------------------------------------------
 357 Global Const dbEditNone = 0
 358 Global Const dbEditInProgress = 1
 359 Global Const dbEditAdd = 2
 360
 361 REM Toolbars
 362 REM -----------------------------------------------------------------
 363 Global Const msoBarTypeNormal = 0               &apos;  Usual toolbar
 364 Global Const msoBarTypeMenuBar = 1              &apos;  Menu bar
 365 Global Const msoBarTypePopup = 2                &apos;  Shortcut menu
 366 Global Const msoBarTypeStatusBar = 11   &apos;  Status bar
 367 Global Const msoBarTypeFloater = 12             &apos;  Floating window
 368
 369 Global Const msoControlButton = 1               &apos;  Command button
 370 Global Const msoControlPopup = 10               &apos;  Popup, submenu
 371
 372 REM New Lines
 373 REM -----------------------------------------------------------------
 374 Public Function vbCr() As String        :       vbCr = Chr(13)  :       End Function
 375 Public Function vbLf() As String        :       vbLf = Chr(10)  :       End Function
 376 Public Function vbNewLine() As String
 377 Const cstWindows = 1
 378         If GetGuiType() = cstWindows Then vbNewLine = vbCR &amp; vbLF Else vbNewLine = vbLF
 379 End Function    &apos;  vbNewLine V1.4.0
 380 Public Function vbTab() As String       :       vbTab = Chr(9)  :       End Function
 381
 382 REM Module types
 383 REM -----------------------------------------------------------------
 384 Global Const acClassModule = 1
 385 Global Const acStandardModule = 0
 386
 387 REM (Module) procedure types
 388 REM -----------------------------------------------------------------
 389 Global Const vbext_pk_Get = 1                   &apos;  A Property Get procedure
 390 Global Const vbext_pk_Let = 2                   &apos;  A Property Let procedure
 391 Global Const vbext_pk_Proc = 0                  &apos;  A Sub or Function procedure
 392 Global Const vbext_pk_Set = 3                   &apos;  A Property Set procedure
 393
 394 </script:module>