LibreOffice logo
BASEDOCUMENTER
The software tool for documenting your LibreOffice Base applications
 
Database file/home/jean-pierre/Documents/BaseDocumenter/www/databases/NorthWind/TT NorthWind.odb
File actual save date2018-08-01 13:54:50
Scanning done on2018-08-21 17:50:26
Documentation generated on2018-08-21 17:50:37
Table of contents
NorthWind
Controls by form
Form name Control name Control type Caption X,Y Width,Height Root form Data source Master fields Child fields Events by control Required Format
Calculator StartCalc Button   258,37 32,26 Calculator       OnActionPerformed    
  TargetCalcField Numeric   50,37 196,26 Calculator         ✔  
Categories fmtCategoryID Formatted   37,292 67,28 MainForm CategoryID       ✔ Standard
  imgPicture Image   37,159 218,109 MainForm Picture       ✔  
  lblCategoryID Fixed CategoryID 37,275 70,18 MainForm            
  lblCategoryName Fixed CategoryName 37,37 89,19 MainForm            
  lblDescription Fixed Description 37,89 70,19 MainForm            
  lblPicture Fixed Picture 37,141 46,19 MainForm            
  txtCategoryName Text   37,55 283,28 MainForm CategoryName       ✔  
  txtDescription Text   37,107 283,28 MainForm Description       ✔  
Customers_NewRec lblAddress Fixed Address 37,42 92,19 MainForm            
  lblCity Fixed City 37,77 92,18 MainForm            
  lblCompanyName Fixed CompanyName 37,111 92,19 MainForm            
  lblContactName Fixed ContactName 37,146 92,18 MainForm            
  lblContactTitle Fixed ContactTitle 37,180 92,19 MainForm            
  lblCountry Fixed Country 37,215 92,18 MainForm            
  lblCustomerID Fixed CustomerID 37,250 92,18 MainForm            
  lblFax Fixed Fax 37,284 92,19 MainForm            
  lblPhone Fixed Phone 37,319 92,18 MainForm            
  lblPostalCode Fixed PostalCode 38,352 92,19 MainForm            
  lblRegion Fixed Region 38,389 92,18 MainForm            
  txtAddress Text   139,37 283,28 MainForm Address       ✔  
  txtCity Text   139,72 283,28 MainForm City       ✔  
  txtCompanyName Text   139,106 283,28 MainForm CompanyName       ✔  
  txtContactName Text   139,141 283,28 MainForm ContactName       ✔  
  txtContactTitle Text   139,176 283,28 MainForm ContactTitle       ✔  
  txtCountry Text   139,210 283,28 MainForm Country       ✔  
  txtCustomerID Text   139,245 283,28 MainForm CustomerID       ✔  
  txtFax Text   139,279 283,28 MainForm Fax       ✔  
  txtPhone Text   139,314 283,28 MainForm Phone       ✔  
  txtPostalCode Text   140,348 283,28 MainForm PostalCode       ✔  
  txtRegion Text   140,384 283,28 MainForm Region       ✔  
Customers_Sync_Orders lblAddress Fixed Address 37,194 52,18 MainForm            
  lblCompanyName Fixed CompanyName 37,89 92,19 MainForm            
  lblContactName Fixed ContactName 37,141 82,19 MainForm            
  lblCustomerID Fixed CustomerID 37,37 72,19 MainForm            
  lblPhone Fixed Phone 37,246 43,18 MainForm            
  txtAddress Text   37,211 283,28 MainForm Address       ✔  
  txtCompanyName Text   37,107 283,28 MainForm CompanyName       ✔  
  txtContactName Text   37,159 283,28 MainForm ContactName       ✔  
  txtCustomerID Text   37,55 283,28 MainForm CustomerID       ✔  
  txtPhone Text   37,263 283,28 MainForm Phone       ✔  
Employees_FillAuto fmtEmployeeID Formatted   37,55 129,28 MainForm       OnFocusLost ✔ Standard
  lblAddress Fixed Address 315,89 52,19 MainForm            
  lblCity Fixed City 593,89 30,19 MainForm            
  lblEmployeeID Fixed EmployeeID 37,37 74,19 MainForm            
  lblFirstName Fixed FirstName 524,37 63,19 MainForm            
  lblLastName Fixed LastName 37,89 62,19 MainForm            
  lblTitleOfCourtesy Fixed TitleOfCourtesy 176,37 91,19 MainForm            
  txtAddress Text   315,107 268,28 MainForm         ✔  
  txtCity Text   593,107 268,28 MainForm         ✔  
  txtFirstName Text   524,55 337,28 MainForm         ✔  
  txtLastName Text   37,107 268,28 MainForm         ✔  
  txtTitleOfCourtesy Text   176,55 337,28 MainForm         ✔  
Employees_Sync_Orders fmtEmployeeID Formatted   122,37 67,28 MainForm EmployeeID       ✔ Standard
  lblAddress Fixed Address 37,180 75,19 MainForm            
  lblCity Fixed City 37,215 75,18 MainForm            
  lblEmployeeID Fixed EmployeeID 37,42 75,19 MainForm            
  lblFirstName Fixed FirstName 37,111 75,19 MainForm            
  lblHomePhone Fixed HomePhone 37,146 75,18 MainForm            
  lblLastName Fixed LastName 37,77 75,18 MainForm            
  txtAddress Text   122,176 283,28 MainForm Address       ✔  
  txtCity Text   122,210 283,28 MainForm City       ✔  
  txtFirstName Text   122,106 283,28 MainForm FirstName       ✔  
  txtHomePhone Text   122,141 283,28 MainForm HomePhone       ✔  
  txtLastName Text   122,72 283,28 MainForm LastName       ✔  
Orders_2Combos EmployeeCity Combo box   30,88 190,20 MainForm 
SELECT 
	DISTINCT "City" 
FROM 
	"Employees"
     OnTextChanged ✔  
  EmployeeName Combo box   30,157 190,20 MainForm 
SELECT 
	DISTINCT "LastName" 
FROM 
	"Employees" 
WHERE 
	"Employees"."City" = 'Kirkland'
     OnTextChanged ✔  
  MainForm_Grid Gridcontrol   245,31 637,441 MainForm            
  … CustomerID Text CustomerID     MainForm CustomerID       ✔  
  … EmployeeID Formatted EmployeeID     MainForm EmployeeID       ✔ Standard
  … OrderDate Time OrderDate (Time)     MainForm OrderDate       ✔ 24h short
  … OrderDate Time OrderDate (Time)     MainForm OrderDate       ✔ 24h short
  … ShipAddress Text ShipAddress     MainForm ShipAddress       ✔  
  … ShipCity Text ShipCity     MainForm ShipCity       ✔  
Orders_Browse datOrderDate Date   122,141 72,28 MainForm OrderDate       ✔ Standard (short)
  datRequiredDate Date   519,37 72,28 MainForm RequiredDate       ✔ Standard (short)
  datShippedDate Date   926,72 72,28 MainForm ShippedDate       ✔ Standard (short)
  fmtEmployeeID Formatted   122,72 75,28 MainForm EmployeeID       ✔ Standard
  fmtFreight Formatted   122,106 43,28 MainForm Freight       ✔ Standard
  fmtOrderID Formatted   1292,72 66,28 MainForm OrderID       ✔ Standard
  fmtShipVia Formatted   1292,37 75,28 MainForm ShipVia       ✔ Standard
  lblCustomerID Fixed CustomerID 37,42 74,19 MainForm            
  lblEmployeeID Fixed EmployeeID 37,77 74,18 MainForm            
  lblFreight Fixed Freight 37,111 74,19 MainForm            
  lblOrderDate Fixed OrderDate 37,146 74,18 MainForm            
  lblOrderID Fixed OrderID 1230,77 51,18 MainForm            
  lblRequiredDate Fixed RequiredDate 426,42 82,19 MainForm            
  lblShipAddress Fixed ShipAddress 426,77 82,18 MainForm            
  lblShipCity Fixed ShipCity 426,111 82,19 MainForm            
  lblShipCountry Fixed ShipCountry 426,146 82,18 MainForm            
  lblShipName Fixed ShipName 823,42 92,19 MainForm            
  lblShippedDate Fixed ShippedDate 823,77 92,18 MainForm            
  lblShipPostalCode Fixed ShipPostalCode 823,111 92,19 MainForm            
  lblShipRegion Fixed ShipRegion 823,146 92,18 MainForm            
  lblShipVia Fixed ShipVia 1230,42 51,19 MainForm            
  SubForm Subform       MainForm Order Details (Table) OrderID OrderID      
  … SubForm_Grid Gridcontrol   37,244 824,235              
  … … Discount Formatted Discount       Discount       ✔ Standard
  … … OrderID Formatted OrderID       OrderID       ✔ Standard
  … … ProductID Formatted ProductID       ProductID       ✔ Standard
  … … Quantity Formatted Quantity       Quantity       ✔ Standard
  … … UnitPrice Formatted UnitPrice       UnitPrice       ✔ Standard
  timOrderDate Time   193,141 40,28 MainForm OrderDate       ✔ 24h short
  timRequiredDate Time   590,37 40,28 MainForm RequiredDate       ✔ 24h short
  timShippedDate Time   997,72 39,28 MainForm ShippedDate       ✔ 24h short
  txtCustomerID Text   122,37 282,28 MainForm CustomerID       ✔  
  txtShipAddress Text   519,72 282,28 MainForm ShipAddress       ✔  
  txtShipCity Text   519,106 282,28 MainForm ShipCity       ✔  
  txtShipCountry Text   519,141 282,28 MainForm ShipCountry       ✔  
  txtShipName Text   926,37 282,28 MainForm ShipName       ✔  
  txtShipPostalCode Text   926,106 282,28 MainForm ShipPostalCode       ✔  
  txtShipRegion Text   926,141 282,28 MainForm ShipRegion       ✔  
Orders_CalculatedField CustomerID Text   171,55 340,28 MainForm CustomerID       ✔  
  lblCustomerID Fixed CustomerID 171,37 72,19 MainForm            
  lblOrderID Fixed OrderID 37,37 52,19 MainForm            
  lblShipAddress Fixed ShipAddress 521,37 75,19 MainForm            
  lblShipCity Fixed ShipCity 37,89 53,19 MainForm            
  lblShippedDate Fixed ShippedDate 330,89 79,19 MainForm            
  OrderID Formatted   37,55 124,28 MainForm OrderID       ✔ Standard
  ShipAddress Text   521,55 340,28 MainForm ShipAddress       ✔  
  ShipCity Text   37,107 283,28 MainForm ShipCity       ✔  
  ShippedDate Date   330,107 72,28 MainForm ShippedDate       ✔ Standard (short)
  SumOfDetails Numeric   478,107 77,26 MainForm         ✔  
  timShippedDate Time   401,107 40,28 MainForm ShippedDate       ✔ 24h short
Orders_CalculatedField_Grid OrderDetails_Grid Gridcontrol   37,37 824,442 MainForm            
  … OrderDate Time OrderDate (Time)     MainForm OrderDate       ✔ 24h short
  … OrderDate Time OrderDate (Time)     MainForm OrderDate       ✔ 24h short
  … OrderID Formatted OrderID     MainForm OrderID       ✔ Standard
  … ShipAddress Text ShipAddress     MainForm ShipAddress       ✔  
  … ShipCity Text ShipCity     MainForm ShipCity       ✔  
  … SumOfDetails Numeric Total Order     MainForm TotalOrder       ✔  
Orders_Details_Sync_Cust-Prod-Emp btnCustomers Button Customer 81,195 127,26 MainForm       OnMousePressed    
  btnEmployees Button Employee 371,195 127,26 MainForm       OnMousePressed    
  btnProducts Button Product 226,195 127,26 MainForm       OnMousePressed    
  datOrderDate Date   122,141 107,28 MainForm OrderDate       ✔ Standard (short)
  datRequiredDate Date   519,37 107,28 MainForm RequiredDate       ✔ Standard (short)
  fmtEmployeeID Formatted   122,106 75,28 MainForm EmployeeID       ✔ Standard
  fmtOrderID Formatted   122,37 66,28 MainForm OrderID       ✔ Standard
  lblCustomerID Fixed CustomerID 37,77 74,18 MainForm            
  lblEmployeeID Fixed EmployeeID 37,111 74,19 MainForm            
  lblOrderDate Fixed OrderDate 37,146 74,18 MainForm            
  lblOrderID Fixed OrderID 37,42 74,19 MainForm            
  lblRequiredDate Fixed RequiredDate 426,42 82,19 MainForm            
  lblShipAddress Fixed ShipAddress 426,77 82,18 MainForm            
  lblShipCity Fixed ShipCity 426,111 82,19 MainForm            
  NavigationBar Navigation bar   302,144 379,27 MainForm            
  SubForm Subform       MainForm Order Details (Table) OrderID OrderID OnCursorMoved    
  … SubForm_Grid Gridcontrol   37,244 824,235              
  … … Discount Formatted Discount       Discount       ✔ Standard
  … … OrderID Formatted OrderID       OrderID       ✔ Standard
  … … ProductID Formatted ProductID       ProductID       ✔ Standard
  … … Quantity Formatted Quantity       Quantity       ✔ Standard
  … … UnitPrice Formatted UnitPrice       UnitPrice       ✔ Standard
  timOrderDate Time   193,141 59,28 MainForm OrderDate       ✔ 24h short
  timRequiredDate Time   590,37 59,28 MainForm RequiredDate       ✔ 24h short
  txtCustomerID Text   122,72 282,28 MainForm CustomerID       ✔  
  txtShipAddress Text   519,72 282,28 MainForm ShipAddress       ✔  
  txtShipCity Text   519,106 282,28 MainForm ShipCity       ✔  
Orders_Tabbed btnDetails Button Details 94,0 96,38 MainForm       OnActionPerformed    
  btnOrders Button Orders 0,0 95,38 MainForm       OnActionPerformed    
  datOrderDate Date   43,162 75,28 MainForm OrderDate       ✔ Standard (short)
  datRequiredDate Date   339,68 75,28 MainForm RequiredDate       ✔ Standard (short)
  fmtEmployeeID Formatted   43,118 78,28 MainForm EmployeeID       ✔ Standard
  fmtOrderID Formatted   635,164 69,28 MainForm OrderID       ✔ Standard
  lblCustomerID Fixed CustomerID 43,53 72,18 MainForm            
  lblEmployeeID Fixed EmployeeID 43,101 74,18 MainForm            
  lblOrderDate Fixed OrderDate 43,147 65,18 MainForm            
  lblOrderID Fixed OrderID 635,147 52,18 MainForm            
  lblRequiredDate Fixed RequiredDate 339,53 83,18 MainForm            
  lblShipAddress Fixed ShipAddress 339,101 75,18 MainForm            
  lblShipCity Fixed ShipCity 339,147 52,18 MainForm            
  lblShipCountry Fixed ShipCountry 635,53 73,18 MainForm            
  lblShipPostalCode Fixed ShipPostalCode 635,101 92,18 MainForm            
  SubForm Subform       MainForm Order Details (Table) OrderID OrderID      
  … SubForm_Grid Gridcontrol   25,-7 823,183              
  … … Discount Formatted Discount       Discount       ✔ Standard
  … … OrderID Formatted OrderID       OrderID       ✔ Standard
  … … ProductID Formatted ProductID       ProductID       ✔ Standard
  … … Quantity Formatted Quantity       Quantity       ✔ Standard
  … … UnitPrice Formatted UnitPrice       UnitPrice       ✔ Standard
  timOrderDate Time   118,162 42,28 MainForm OrderDate       ✔ 24h short
  timRequiredDate Time   413,68 43,28 MainForm RequiredDate       ✔ 24h short
  txtCustomerID Text   43,70 285,28 MainForm CustomerID       ✔  
  txtShipAddress Text   339,118 285,28 MainForm ShipAddress       ✔  
  txtShipCity Text   339,164 285,28 MainForm ShipCity       ✔  
  txtShipCountry Text   635,70 285,28 MainForm ShipCountry       ✔  
  txtShipPostalCode Text   635,118 285,28 MainForm ShipPostalCode       ✔  
Products_FastSearch FastList List box   62,37 304,272 Form 
SELECT 
	"ProductName" 
FROM 
	"Products" 
ORDER BY 
	"ProductName" ASC
     OnKeyPressed ✔  
Products_FastSelect LeftList List box   62,37 165,272 Form 
SELECT 
	"ProductName" 
FROM 
	"Products" 
ORDER BY 
	"ProductName" ASC
       ✔  
  MoveAllLeft Button << 270,207 45,20 Form       OnActionPerformed    
  MoveAllRight Button >> 270,107 45,19 Form       OnActionPerformed    
  MoveOneLeft Button < 270,176 45,20 Form       OnActionPerformed    
  MoveOneRight Button > 270,75 45,20 Form       OnActionPerformed    
  RightList List box   359,37 164,272 Form         ✔  
Products_ListBoxFilter CustomersAll-SQL Combo box   37,340 367,20 MainForm 
SELECT 
	"CompanyName" 
FROM 
	"Customers" 
UNION 
SELECT 
	'(All)' as "Bogus" 
From 
	"Customers" 
ORDER BY 
	"CompanyName";
       ✔  
  ListBox-All List box   37,371 367,222 MainForm 
SELECT 
	DISTINCT "CompanyName" 
FROM 
	"Customers"
       ✔  
  MainForm_Grid Gridcontrol   428,13 823,441 MainForm            
  … ProductID Formatted ProductID     MainForm ProductID       ✔ Standard
  … ProductName Text ProductName     MainForm ProductName       ✔  
  … QuantityPerUnit Text QuantityPerUnit     MainForm QuantityPerUnit       ✔  
  … SupplierID Formatted SupplierID     MainForm SupplierID       ✔ Standard
  … UnitPrice Formatted UnitPrice     MainForm UnitPrice       ✔ Standard
  SuppliersListBoxMono List box   37,12 367,152 MainForm 
SELECT 
	"CompanyName" 
FROM 
	"Suppliers" 
ORDER BY 
	"CompanyName" ASC
     OnChanged ✔  
  SuppliersListBoxMulti List box   37,176 367,152 MainForm 
SELECT 
	"CompanyName" 
FROM 
	"Suppliers" 
ORDER BY 
	"CompanyName" ASC
     OnChanged ✔  
Products_Sync_Orders fmtProductID Formatted   37,55 67,28 MainForm ProductID       ✔ Standard
  fmtUnitsInStock Formatted   163,55 44,28 MainForm UnitsInStock       ✔ Standard
  lblProductID Fixed ProductID 37,37 62,19 MainForm            
  lblProductName Fixed ProductName 37,89 82,19 MainForm            
  lblQuantityPerUnit Fixed QuantityPerUnit 37,141 93,19 MainForm            
  lblUnitsInStock Fixed UnitsInStock 163,37 74,19 MainForm            
  txtProductName Text   37,107 283,28 MainForm ProductName       ✔  
  txtQuantityPerUnit Text   37,159 283,28 MainForm QuantityPerUnit       ✔  
Products_ZoomImage imgPicture Image   37,107 127,64 MainForm Picture     OnMouseEntered
OnMouseExited		 ✔  
  imgZoom Image   290,107 631,316 MainForm Picture          
  lblPicture Fixed Picture 37,89 46,19 MainForm            
  lblProductName Fixed ProductName 37,37 82,19 MainForm            
  txtProductName Text   37,55 283,28 MainForm ProductName       ✔