Forms z Event procedures forms and controls z

  • Slides: 22
Download presentation
Forms z Event procedures forms and controls z Filters z Validating data in a

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

Form Events

Form Events

Form Events

Form Events

Form Events

Form Events

Form Events

Control Events

Control Events

Control Events

Control Events

Control Events

Control Events

Control Events

Control Events

Filters z Filtering allows users to choose own subset of rows and supply own

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

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.

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

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

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

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

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

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.

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

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

Civil PreTrial Procedures Civil pretrial procedures Procedures thatCivil PreTrial Procedures Civil pretrial procedures Procedures that
DPS 304 Purchasing Procedures Traditional procedures Modern ProceduresDPS 304 Purchasing Procedures Traditional procedures Modern Procedures
Classroom Procedures Ms Proepper Grade 3 Procedures ProceduresClassroom Procedures Ms Proepper Grade 3 Procedures Procedures
General Procedures Sub Procedures Part II Function ProceduresGeneral Procedures Sub Procedures Part II Function Procedures
Event Generator Event Generators Information needed Event GeneratorEvent Generator Event Generators Information needed Event Generator
Event Planning Event Planning An event planner isEvent Planning Event Planning An event planner is
3 Mouse Event Action Event Mouse Event Action3 Mouse Event Action Event Mouse Event Action
Event Handling Model of AWT Event object EventEvent Handling Model of AWT Event object Event
Index Event Handling Events Event Source Event ListenerIndex Event Handling Events Event Source Event Listener
Mouse Event Handling in CCLI Event Mouse EventMouse Event Handling in CCLI Event Mouse Event
boolean on Touch Event Motion Event event booleanboolean on Touch Event Motion Event event boolean
event C event B event A BDDs onevent C event B event A BDDs on
Catastrophic Event Catastrophic Event An event that resultsCatastrophic Event Catastrophic Event An event that results
system 32config Sec Event EvtSys Event EvtApp Eventsystem 32config Sec Event EvtSys Event EvtApp Event
Google Forms Google Form Google Forms Google FormsGoogle Forms Google Form Google Forms Google Forms
Forms Manager What is Forms Manager Forms ManagerForms Manager What is Forms Manager Forms Manager
Dynamic Forms Designing Forms Forms Basics What kindDynamic Forms Designing Forms Forms Basics What kind
Controls and Protection Systems Karen S White ControlsControls and Protection Systems Karen S White Controls
Sanitation and GMP Controls for Listeria Listeria ControlsSanitation and GMP Controls for Listeria Listeria Controls
Price and Quality Controls Price Controls Legal restrictionsPrice and Quality Controls Price Controls Legal restrictions
Examples of Price Controls Price controls and naturalExamples of Price Controls Price controls and natural
ABPO Controls Requirements Machines containing power converter controlsABPO Controls Requirements Machines containing power converter controls
Internal Controls INTERNAL CONTROLS Copyright 2011 We ComplyInternal Controls INTERNAL CONTROLS Copyright 2011 We Comply
Positive Controls Positive controls help ensure interpretable resultsPositive Controls Positive controls help ensure interpretable results
Advanced loop controls Loop Controls Recall from lastAdvanced loop controls Loop Controls Recall from last
Internal Controls for Federal Grants Internal Controls forInternal Controls for Federal Grants Internal Controls for
l Who controls the past controls the futurel Who controls the past controls the future
Controls System Installation Status Ernest Williams for ControlsControls System Installation Status Ernest Williams for Controls
Control Phase Lean Controls Lean Controls Welcome toControl Phase Lean Controls Lean Controls Welcome to
Gas Furnace Controls Part 3 Gas furnace controlsGas Furnace Controls Part 3 Gas furnace controls
Export Controls EXPORT CONTROLS Copyright 2011 We ComplyExport Controls EXPORT CONTROLS Copyright 2011 We Comply
Internal Controls Agenda Basics of Internal Controls whatInternal Controls Agenda Basics of Internal Controls what
He who controls the present controls the pastHe who controls the present controls the past
Controls Middleware CMW Presentation to the Controls BoardControls Middleware CMW Presentation to the Controls Board
Internal Controls Training 1 Internal Controls What doInternal Controls Training 1 Internal Controls What do
Chapter 21 Using Controls Using Controls The easeChapter 21 Using Controls Using Controls The ease
NET Validation Controls Today What Validation controls doNET Validation Controls Today What Validation controls do
INTERNAL CONTROLS PAGE 361 INTERNAL CONTROLS Objectives WhenINTERNAL CONTROLS PAGE 361 INTERNAL CONTROLS Objectives When
Boiler Controls Instrumentation K Karthikeyan Manager Controls InstrumentationBoiler Controls Instrumentation K Karthikeyan Manager Controls Instrumentation
Server Controls Validation Controls A validation control orServer Controls Validation Controls A validation control or