2001 Предыдущая операция прервана пользователем |
Private Function MnuNewEntry() 'Реакция на пункт меню "Новая запись" Forms![frmWorkRegime].[sfrmWorkParam].Form.RecordSource = "qryWorkParam" Forms![frmWorkRegime].Controls![sfrmWorkParam].Form.Controls![cboOdjectLine].ColumnHidden = False Forms![frmWorkRegime].Controls![sfrmWorkParam].Form.Controls![txtObject_Name].ColumnHidden = True Forms![frmWorkRegime].Controls![sfrmWorkParam].Form.Controls![txtLine_Number].ColumnHidden = True Forms![frmWorkRegime].[sfrmWorkParam].Form.AllowAdditions = True Forms![frmWorkRegime].[sfrmWorkParam].Form.KeyPreview = True Forms![frmWorkRegime].[sfrmWorkParam].Form.DataEntry = True Forms![frmWorkRegime].Controls![sfrmWorkParam].SetFocus 'Передача фокуса к подчинённой форме. End Function
Private Sub Form_AfterUpdate() On Error GoTo lblError Forms![frmWorkRegime].[sfrmWorkParam].Form.Filter = "" Forms![frmWorkRegime].[sfrmWorkParam].Form.FilterOn = False Forms![frmWorkRegime].[sfrmWorkParam].Form.RecordSource = "qryLasWorkParam" Me.Form.Controls![cboOdjectLine].ColumnHidden = True Me.Form.Controls![txtObject_Name].ColumnHidden = False Me.Form.Controls![txtLine_Number].ColumnHidden = False If Me.Form.AllowAdditions = True Then Me.Form.AllowAdditions = False If Me.Form.AllowEdits = True Then Me.Form.AllowEdits = False If Me.Form.KeyPreview = True Then Me.Form.KeyPreview = False If Me.Form.DataEntry = True Then Me.Form.DataEntry = False Forms![frmWorkRegime].Controls![sfrmWorkParam].SetFocus 'Передача фокуса к подчинённой форме. Exit Sub lblError: MsgBox Err.Source & " " & Err.Number & " " & Err.Description ' Место для обработчика ошибок. End Sub
Private Sub Form_KeyPress(KeyAscii As Integer) If KeyAscii = 27 And Me.Form.RecordSource = "qryWorkParam" Then Call Form_AfterUpdate End Sub
Forms![frmWorkRegime].[sfrmWorkParam].Form.RecordSource = "qryLasWorkParam"
http://www.sql.ru/forum/1240880/2001-predydushhaya-operaciya-prervana-polzovatelem
Комментировать | « Пред. запись — К дневнику — След. запись » | Страницы: [1] [Новые] |