Database Database


Download 466 b.
bet11/19
Sana14.08.2018
Hajmi466 b.
1   ...   7   8   9   10   11   12   13   14   ...   19

Defaults

  • vbDefaultButton1
  • vbDefaultButton2
  • vbDefaultButton3


InputBox

  • InputBox

    • Prompt
    • Title
    • Default
    • X-Pos, Y-Pos
  • Prompt



If

  • If

    • If (Condition) Then
      • statements for true
    • Else
    • End If
  • IIF (Cond., True, False)

  • Select Case (expr)

    • Case value
      • statements
    • Case value2
    • Case Else
    • End Select


Message Box



Do

  • Do

  • For … Next

  • For Each



Do

  • Do

    • Do {While | Until}
      • Exit Do (optional)
    • Loop
    • Do
    • Loop {While | Until}
  • For/Next

    • For counter = start To end Step increment
      • Exit For (optional)
    • Next counter


Sub name (var1 As . . ., var2, . . .)

  • Sub name (var1 As . . ., var2, . . .)

  • End Sub

  • Function fname (var1 As . . .) As datatype

  • End Function

  • Variables are passed by reference

    • Changes made to the parameters in the subroutine are passed back to the caller.
  • Unless you use ByVal







Arrays

  • Arrays

    • Dim array(sub, . . .) As type
    • Dim iSorts(10) As Integer
  • Specifying bounds:

    • (lower To upper, . . .)
    • ReDim [Preserve] array .. .
    • Option Base 0 | 1
    • v 2.0 arrays less than 64KB


Fixed payments

  • Fixed payments

    • PV (rate, nper, pmt, fv, due)
    • FV (rate, nper, pmt, pv, due)
    • IPmt (rate, per, nper, pv, fv, due)
    • NPer (rate, pmt, pv, fv, due)
    • Pmt (rate, nper, pv, fv,due)
    • PPmt (rate, per, nper, pv, fv, due)
    • Rate (nper, pmt, pv, fv, due, guess)
  • rate interest rate per period

  • per specific period number

  • nper # of periods

  • pv present value

  • fv future value

  • due 0=due at end, 1=due at start



Open filename As # file#

  • Open filename As # file#

  • Close # file#, Reset

  • Print #,Put, Write

  • Spc, Tab

  • Get, Input #, Line Input #

  • EOF, LOF

  • Seek # file#, position



CreateObject (class)

  • CreateObject (class)

    • “appname . objecttype”
  • GetObject (file, class)

  • Methods and syntax are defined by the software that exports the object.



Shell

  • Shell

  • DDEInitiate

  • DDEExecute

  • DDEPoke, DDE Send

    • Send data
  • DDE, DDERequest

    • Request data
  • DDETerminate





Collect Data



User Control

  • User Control

    • Match user tasks.
    • Application responds to user control & events.
    • User customization
  • Consistency

    • Layout, Design & colors
    • Actions
  • Clarity

    • Organization
    • Purpose
    • Terminology
  • Aesthetics



The Windows Interface: An Application Design Guide (Microsoft)

  • The Windows Interface: An Application Design Guide (Microsoft)

  • Navigation and Choices

    • Mouse, Icons
    • Keyboard, Short-cuts
    • Menus
  • Selections from a list

    • Single
    • Contiguous Multiple
    • Disjoint Multiple
  • Focus

    • Outline box
    • Cursor


Window components

  • Window components

    • Frame (sizing)
    • Title bar
    • Control-menu box
    • Buttons
      • Minimize
      • Maximize
      • Close
      • Scroll box (thumb)
      • Scroll bar




Do'stlaringiz bilan baham:
1   ...   7   8   9   10   11   12   13   14   ...   19


Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2017
ma'muriyatiga murojaat qiling