home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 2000 March / pcp161b.iso / handson / archive / Issue159 / files / vbwkshp / EditRecipient.frm (.txt) < prev    next >
Encoding:
Visual Basic Form  |  1999-10-02  |  2.8 KB  |  100 lines

  1. VERSION 5.00
  2. Begin VB.Form EditRecipient 
  3.    BorderStyle     =   3  'Fixed Dialog
  4.    Caption         =   "Edit Recipient"
  5.    ClientHeight    =   5145
  6.    ClientLeft      =   2760
  7.    ClientTop       =   3750
  8.    ClientWidth     =   6030
  9.    LinkTopic       =   "Form1"
  10.    MaxButton       =   0   'False
  11.    MinButton       =   0   'False
  12.    ScaleHeight     =   5145
  13.    ScaleWidth      =   6030
  14.    ShowInTaskbar   =   0   'False
  15.    Begin VB.Data Data1 
  16.       Connect         =   "Access"
  17.       DatabaseName    =   "C:\pcplus\vbwkshp\issue159\newslist.mdb"
  18.       DefaultCursorType=   0  'DefaultCursor
  19.       DefaultType     =   2  'UseODBC
  20.       Exclusive       =   0   'False
  21.       Height          =   375
  22.       Left            =   1080
  23.       Options         =   0
  24.       ReadOnly        =   0   'False
  25.       RecordsetType   =   1  'Dynaset
  26.       RecordSource    =   "Recipients"
  27.       Top             =   1680
  28.       Width           =   1455
  29.    End
  30.    Begin VB.CommandButton Update 
  31.       Caption         =   "Update"
  32.       Height          =   375
  33.       Left            =   4680
  34.       TabIndex        =   5
  35.       Top             =   600
  36.       Width           =   1215
  37.    End
  38.    Begin VB.TextBox xAddress 
  39.       DataField       =   "EMail"
  40.       DataSource      =   "Data1"
  41.       Height          =   375
  42.       Left            =   1080
  43.       TabIndex        =   2
  44.       Top             =   1080
  45.       Width           =   3135
  46.    End
  47.    Begin VB.TextBox xName 
  48.       DataField       =   "Name"
  49.       DataSource      =   "Data1"
  50.       Height          =   375
  51.       Left            =   1080
  52.       TabIndex        =   1
  53.       Top             =   480
  54.       Width           =   3135
  55.    End
  56.    Begin VB.CommandButton OKButton 
  57.       Caption         =   "Exit"
  58.       Height          =   375
  59.       Left            =   4680
  60.       TabIndex        =   0
  61.       Top             =   120
  62.       Width           =   1215
  63.    End
  64.    Begin VB.Label Label2 
  65.       Caption         =   "Address"
  66.       Height          =   255
  67.       Left            =   240
  68.       TabIndex        =   4
  69.       Top             =   1080
  70.       Width           =   735
  71.    End
  72.    Begin VB.Label Label1 
  73.       Caption         =   "Name"
  74.       Height          =   255
  75.       Left            =   240
  76.       TabIndex        =   3
  77.       Top             =   480
  78.       Width           =   735
  79.    End
  80. Attribute VB_Name = "EditRecipient"
  81. Attribute VB_GlobalNameSpace = False
  82. Attribute VB_Creatable = False
  83. Attribute VB_PredeclaredId = True
  84. Attribute VB_Exposed = False
  85. Option Explicit
  86. Private Sub Form_Activate()
  87. Data1.Refresh
  88. End Sub
  89. Private Sub OKButton_Click()
  90. Me.Hide
  91. End Sub
  92. Private Sub Update_Click()
  93. With Data1.Recordset
  94.     .Edit
  95.     !Name = xName.Text
  96.     !EMail = xAddress.Text
  97.     .Update
  98. End With
  99. End Sub
  100.