Edit Method Example

shekaibing

shekaibing

2016-01-29 12:39

Edit Method Example,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
展开更多 50%)
分享

猜你喜欢

Edit Method Example

电脑网络
Edit Method Example

Edit Method

电脑网络
Edit Method

s8lol主宰符文怎么配

英雄联盟 网络游戏
s8lol主宰符文怎么配

AddNew Method Example

电脑网络
AddNew Method Example

In Javascript Class, how to call the prototype method.(three method)

Web开发
In Javascript Class, how to call the prototype method.(three method)

lol偷钱流符文搭配推荐

英雄联盟 网络游戏
lol偷钱流符文搭配推荐

Edit Box

编程语言 网络编程
Edit Box

example2.php

Web开发
example2.php

lolAD刺客新符文搭配推荐

英雄联盟
lolAD刺客新符文搭配推荐

PSV《Rewrite》中文奖杯一览

PSV《Rewrite》中文奖杯一览

算法讨论:哲学家就餐问题

算法讨论:哲学家就餐问题
下拉加载更多内容 ↓