List 7-168 FormSlipHistoryフォームのPutHistoryプロシージャ


  1: Public Sub PutHistory(SlipID As Long)
  2:     ' 引数に指定された伝票番号を持つ伝票の更新履歴を表示する
  3:     Dim objSlip As Business.Slip
  4:     Dim objRec As ADODB.Recordset
  5:     
  6:     On Error GoTo ErrHandle
  7:     
  8:     Set objSlip = CreateObject("Business.Slip")
  9:     
 10:     Set objRec = objSlip.GetSlip_Details(SlipID)
 11:     
 12:     Set DGrid_History.DataSource = objRec
 13:     
 14:     DGrid_History.Refresh
 15:     
 16:     Set objSlip = Nothing
 17:     
 18:     Me.Show 1
 19:     
 20:     Set objRec = Nothing
 21:     
 22:     Exit Sub
 23: 
 24: ErrHandle:
 25:     ' エラーハンドラ
 26:     MsgBox Err.Description, vbOKOnly, "履歴の取得に失敗しました"
 27:     Set objSlip = Nothing
 28:     Set objRec = Nothing
 29: End Sub