Then we apply the same principles for a date range query.Ĭlick here to Download: odb27-User-Parameters-Part1.odb We look at how to create a query to search for a specific employee ID. We first see how to limit the number of records in our result set, then see the distinct feature, we calculate the weekly and annual salary, then we look at how to create a constant value in our output.Ĭlick here to Download: odb26-Limit-Distinct-Calcs-Const.odb Video 26 - Limit Distinct Calculations and Constants.We will change the phone number field to a Pattern Field to only allow numbers to be entered into our phone number field.Ĭlick here to Download: odb13a-Edit Mask.txtĬlick here to Download: odb13b-Pattern Field.odbĬlick here to Download: odb14-Form Properties.odb

We will protect our employee-ID field, then then change the sort order of our table to sort the records by last name (instead of employe-ID), then add some buttons to our form to allow us to select the next and previous records.Ĭlick here to Download: odb09-ProtectAField Add Buttons.odbĪn introduction to the filter on the navitgation toolbar, how to change the background color/insert a background graphic also adding a logo on your form.Ĭlick here to Download: odb10-Filter Background.odbĬlick here to Download: odb10-Gender-Text-VarChar.odbĪdd a radio button to replace the Gender Textbox on an updated version of odb10, then we take the original odb10 output change the Gender field type from Fixed Character to VarChar, then we need to update the data in that field, then we can add the radio buttons and check out the data source.Ĭlick here to Download: odb11a-Radio-Button.odbĬlick here to Download: odb11b-Gender-Text-VarChar.odbįirst we show how to do a date drop down down box, then we format a date on our table and show how to get the date formatting from the table, then we will create a new field (on our table) with a dollar value and have it show on our form with a dollar sign.Ĭlick here to Download: odb12-Dates and Dollar Signs.odb

Video 9 - Protect a Field, Sort, Add Buttons.

Group items in query openoffice base