北京 | 上海 | 天津 | 重庆 | 广州 | 深圳 | 珠海 | 汕头 | 佛山 | 中山 | 东莞 | 南京 | 苏州 | 无锡 | 常州 | 南通 | 扬州 | 徐州 | 杭州 | 温州 | 宁波 | 台州 | 福州 | 厦门 | 泉州 | 龙岩 | 合肥 | 芜湖 | 成都 | 遂宁 | 长沙 | 株洲 | 湘潭 | 武汉 | 南昌 | 济南 | 青岛 | 烟台 | 潍坊 | 淄博 | 济宁 | 太原 | 郑州 | 石家庄 | 保定 | 唐山 | 西安 | 大连 | 沈阳 | 长春 | 昆明 | 兰州 | 哈尔滨 | 佳木斯 | 南宁 | 桂林 | 海口 | 贵阳 | 西宁 | 乌鲁木齐 | 包头 |
Form_frm02 产能基础_Edit 窗体里的程序代码
Option Compare Database
Option Explicit
Private Sub Form_Load()
On Error GoTo ErrorHandler
Dim strSQL As String
Dim cnn As Object 'ADODB.Connection
Dim rst As Object 'ADODB.Recordset
ApplyTheme Me
If IsNull(Me.OpenArgs) Then
Me.DataEntry = True
End If
If Me.DataEntry Then
Exit Sub
End If
Me.btnSave.Enabled = Me.AllowEdits
Set cnn = CurrentProject.Connection
strSQL = "SELECT * FROM [02 产能基础表] WHERE [工厂]=" & SQLText(Me.OpenArgs)
Set rst = OpenADORecordset(strSQL, , cnn)
Me![工厂] = rst![工厂]
Me![产线] = rst![产线]
Me![物料编码] = rst![物料编码]
Me![物料描述] = rst![物料描述]
Me![规] = rst![规]
Me![格] = rst![格]
Me![单位] = rst![单位]
Me![年份] = rst![年份]
Me![月份] = rst![月份]
Me![单位小时有效产能] = rst![单位小时有效产能]
Me![日有效作业时间] = rst![日有效作业时间]
rst.Close
ExitHere:
Set rst = Nothing
Set cnn = Nothing
Exit Sub
ErrorHandler:
RDPErrorHandler Me.Name & ": Sub Form_Load()"
Resume ExitHere
End Sub
Private Sub btnSave_Click()
On Error GoTo ErrorHandler
Dim strWhere As String
Dim strSQL As String
Dim cnn As Object 'ADODB.Connection
Dim rst As Object 'ADODB.Recordset
If Not CheckRequired(Me) Then Exit Sub
If Not CheckTextLength(Me) Then Exit Sub
Set cnn = CurrentProject.Connection
strSQL = "SELECT * FROM [02 产能基础表] WHERE [工厂]=" & SQLText(Me![工厂])
Set rst = OpenADORecordset(strSQL, adLockOptimistic, cnn)
If rst.EOF Then
rst.AddNew
End If
rst![工厂] = Me![工厂]
rst![产线] = Me![产线]
rst![物料编码] = Me![物料编码]
rst![物料描述] = Me![物料描述]
rst![规] = Me![规]
rst![格] = Me![格]
rst![单位] = Me![单位]
rst![年份] = Me![年份]
rst![月份] = Me![月份]
rst![单位小时有效产能] = Me![单位小时有效产能]
rst![日有效作业时间] = Me![日有效作业时间]
rst.Update
rst.Close
Form_frm02 产能基础.RefreshDataList '调用子窗体里自定义刷新函数 编译错误:变量未定义
MsgBoxEx "保存成功!", vbInformation
If Me.DataEntry Then
ClearControlValues Me
Else
DoCmd.Close acForm, Me.Name, acSaveNo
End If
ExitHere:
Set rst = Nothing
Set cnn = Nothing
Exit Sub
ErrorHandler:
RDPErrorHandler Me.Name & ": Sub btnSave_Click()"
Resume ExitHere
End Sub
Private Sub btnCancel_Click()
On Error Resume Next
DoCmd.Close acForm, Me.Name, acSaveNo
End Sub