List 7-76 FormProductフォームのBTN_UNDELETE_Clickプロシージャ
1: Private Sub BTN_UNDELETE_Click()
2: ' [復帰]ボタンが押されたときの処理
3: Dim PRODUCTID As Long
4: Dim objProduct As Business.Product
5:
6: On Error GoTo ErrHandle
7:
8: ' 削除の確認
9: If MsgBox(g_objRec.Fields("PRODUCTNAME").Value & _
"を復帰してよろしいですか", _
vbYesNo, _
"復帰の確認") = vbYes Then
10: ' 復帰する
11: PRODUCTID = g_objRec.Fields("ID").Value
12: Set objProduct = CreateObject("Business.Product")
13: objProduct.UndeleteProduct PRODUCTID
14: RefreshData
15: g_objRec.MoveFirst
16: g_objRec.Find "ID=" & PRODUCTID, 0, adSearchForward
17: Set objProduct = Nothing
18: End If
19:
20: Exit Sub
21:
22: ErrHandle:
23: ' ビジネスオブジェクトの呼び出しに失敗
24: MsgBox Err.Description, vbOKOnly, "製品の復帰"
25: Set objProduct = Nothing
26: End Sub