Forms z Event procedures forms and controls z
- Slides: 22
Forms z Event procedures forms and controls z Filters z Validating data in a form z User-defined functions
Form Events
Form Events
Form Events
Form Events
Form Events
Form Events
Form Events
Control Events
Control Events
Control Events
Control Events
Filters z Filtering allows users to choose own subset of rows and supply own ordering from a table or query z Form methods and properties yfilter by selection yfilter by form yapply filter method y. Filter and Filter. On property y. Filter event and Apply. Filter event
Filters z Filter by selection yuser selects field to filter and clicks Filter by selection button z Filter by form yuser clicks Filter by form button, selects value from a list for a particular field, and clicks Apply filter button z Apply. Filter ymethod of the Do. Cmd object
Filters z Filter property ytakes the form of an SQL WHERE clause z Filter. On property ydetermines whether a record source is being filtered z Examples. . .
Filters Filter property [Last. Name] = “Smith” And [City] Like “S*” Filter. On property If Filter. Options = 2 Then Me!lbl. Warning. Visible = Me. Filter. On Else Me. Filter. On = False End If
Filters z With Apply. Filter method, can specify y. WHERE clause yquery yboth yexample Do. Cmd. Apply. Filter. Name: =“qry. Simple” Do. Cmd. Apply. Filter Where. Condition: =“ID = 5”
Filter Event z Two arguments y. Cancel -- when set to true in the procedure, cancels the filter event y. Filter. Type x 0 -- ac. Filter. By. Form x 1 -- ac. Filter. Advanced z Uses ymake certain controls are disabled (reset with Apply. Filter event) yclean out a previous Filter property
Apply. Filter Event z Two arguments y. Cancel -- when set to true, cancels the procedure y. Apply. Type x 0 -- ac. Show. All. Records (removes filter) x 1 -- ac. Apply. Filter (applies new filer) x 2 -- ac. Close. Filter. Window (tried to close filter window without specifying a new filter
Apply. Filter Event z Uses ytrap attempts to remove a filter or set a new one ymodify filter expression manually yreset display of form before Filter event was applied ychange or update display of form before Access applies filter
Validating Data in a Form z Blank fields can often be checked using Before. Update event z Controls can often be validated using Lost. Focus event z Errors that occur when attempting to save can be trapped with the Error event
User-Defined Functions z Why create functions? y. For code used multiple times either in a class module (private functions) or through the entire application (public functions) yexample Public Function Close. Open(y as String) On Error Resume Next Do. Cmd. Close Do. Cmd. Open. Form y End Function
- General controls vs application controls
- He who controls the past controls the future
- Simple and compound events
- Sentinel event list
- Independent or dependent
- Dependent events examples
- 5 ws of event management
- Bridge breaks in central java killing 5
- Newsworthy event (s) background event (s) sources
- Bsbhrm506
- Issuing products
- Full form and contracted form
- That weak form
- Alert warning symbols and controls worksheet
- Alert/warning symbols and controls worksheet
- Differential association example
- Examples of problems using scientific method
- Physical technical and administrative controls
- Negative control
- What is negative control
- Bosch rexroth electric drives and controls
- Demolition hazards and controls
- Organizational structure and controls chapter 11