Difference between revisions of "Common tasks SP"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
== Categories ==
 +
*'''Interaction'''
 +
**How would I use a value entered in a control to update  a batch of records in the database?
 +
**How to display a caluculated field that uses a value in a column to determine what calculation should be performed? ( SQL CASE WHEN Statement vs onRecordChange Event )
 +
**How do I import and export data from Base?
 +
**Working with DATE / TIME / DATETIMESTAMP fields
 +
**Working with BOOLEAN fields
 +
**How do I setup a main navigation screen.
  
How do I open a form from another form? ( Button click, menu item )
+
*'''Connecting Tables'''
 +
**How to add a sub form to a sub form?
 +
**How do I filter a result set based on a value from a drop down list box?
 +
**How to display a summary ( aggregate ) field for all the records in a table grid control, that updaes when records are added or updated?
 +
**How to set up a field that displays a calculated value based on the entry from other controls? ( display only & how to save this value )
 +
**How do I programmatically copy a record's data to a new record, allwoing for some columns to be changed before being written?
  
How do I filter a result set based on a value from a drop down list box?
+
*'''Controls'''
 +
**How do I display values from more then one column in a list ( combo ) box?
 +
**How can I use a combo box to select values, but allow the user to update the list of available choices?
 +
**How to limit ( alter ) the list displayed in a list box when an item is selected in another list box?
  
How can I use a combo box to select values, but allow the user to update the list of available choices?
+
*'''Macros'''
 +
**How do I open a form from another form? ( Button click, menu item )
 +
**MS Access has the method FindFirst, FindNext for a rowset. Base does not have these, what do I do instead?
  
How to add a sub form to a sub form?
 
  
How to display a summary ( aggregate ) field for all the records in a table grid control, that updaes when records are added or updated?
+
[[Category:Base Example]]
 
+
How to set up a field that displays a calculated value based on the entry from other controls? ( display only & how to save this value )
+
 
+
How would I use a value entered in a control to update  a batch of records in the database?
+
 
+
How to limit ( alter ) the list displayed in a list box when an item is selected in another list box?
+
 
+
How do I display values from more then one column in a list ( combo ) box?
+
 
+
How do I programmatically copy a record's data to a new record, allwoing for some columns to be changed before being written?
+

Latest revision as of 22:13, 24 November 2010

Categories

  • Interaction
    • How would I use a value entered in a control to update a batch of records in the database?
    • How to display a caluculated field that uses a value in a column to determine what calculation should be performed? ( SQL CASE WHEN Statement vs onRecordChange Event )
    • How do I import and export data from Base?
    • Working with DATE / TIME / DATETIMESTAMP fields
    • Working with BOOLEAN fields
    • How do I setup a main navigation screen.
  • Connecting Tables
    • How to add a sub form to a sub form?
    • How do I filter a result set based on a value from a drop down list box?
    • How to display a summary ( aggregate ) field for all the records in a table grid control, that updaes when records are added or updated?
    • How to set up a field that displays a calculated value based on the entry from other controls? ( display only & how to save this value )
    • How do I programmatically copy a record's data to a new record, allwoing for some columns to be changed before being written?
  • Controls
    • How do I display values from more then one column in a list ( combo ) box?
    • How can I use a combo box to select values, but allow the user to update the list of available choices?
    • How to limit ( alter ) the list displayed in a list box when an item is selected in another list box?
  • Macros
    • How do I open a form from another form? ( Button click, menu item )
    • MS Access has the method FindFirst, FindNext for a rowset. Base does not have these, what do I do instead?
Personal tools