CoderDream的专栏

先做好代码员

Edit Method Example

'This example uses the Edit method to replace the current data with the 'specified name. The EditName procedure is required for this procedure to run.

Sub EditX()

 Dim dbsNorthwind As Database
 Dim rstEmployees As Recordset
 Dim strOldFirst As String
 Dim strOldLast As String
 Dim strFirstName As String
 Dim strLastName As String

 Set dbsNorthwind = OpenDatabase("Northwind.mdb")
 Set rstEmployees = _
  dbsNorthwind.OpenRecordset("Employees", _
  dbOpenDynaset)

 ' Store original data.
 strOldFirst = rstEmployees!FirstName
 strOldLast = rstEmployees!LastName

 ' Get new data for record.

strFirstName = Trim(InputBox( _
   "Enter first name:"))
 strLastName = Trim(InputBox( _
   "Enter last name:"))

 ' Proceed if the user entered something for both fields.
 If strFirstName <> "" and strLastName <> "" Then
  ' Update record with new data.
  EditName rstEmployees, strFirstName, strLastName

  With rstEmployees
   ' Show old and new data.
   Debug.Print "Old data: " & strOldFirst & _
    " " & strOldLast
   Debug.Print "New data: " & !FirstName & _

" " & !LastName
   ' Restore original data because this is a
   ' demonstration.
   .Edit
   !FirstName = strOldFirst
   !LastName = strOldLast
   .Update
  End With

 Else
  Debug.Print _
   "You must input a string for first and last name!"
 End If

 rstEmployees.Close
 dbsNorthwind.Close

End Sub

Sub EditName(rstTemp As Recordset, _
 strFirst As String, strLast As String)

 ' Make changes to record and set the bookmark to keep

' the same record current.
 With rstTemp
  .Edit
  !FirstName = strFirst
  !LastName = strLast
  .Update
  .Bookmark = .LastModified
 End With

End Sub

阅读更多
个人分类: 程序设计
想对作者说点什么? 我来说一句

input method editor

2011年02月22日 525KB 下载

没有更多推荐了,返回首页

不良信息举报

Edit Method Example

最多只允许输入30个字

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭