|
本帖最后由 yori2007 于 2012-6-12 09:49 编辑
不知道为什么,新建记录,新建以C开头的记录可以成功录入,而以V开头的不能录入。
Public coTBuyInvoice As New Collection
Public Sub NewTBuyInvoice()
On Error GoTo NewTBuyInvoice_Err
Dim mId As String
mId = InputBox("请输入发票号", "提示")
If mId & "" = "" Then
Exit Sub
End If
If DCount("InvoiceId", "tbTBuyInvoice", "InvoiceId='" & mId & "'") <> 0 Then
MsgBox "此发票号已经存在,请重新输入!", vbExclamation, "提示"
Exit Sub
End If
'新建发票
Dim rs As New ADODB.Recordset
rs.Open "tbTBuyInvoice", CurrentProject.Connection, adOpenDynamic, adLockOptimistic
With rs
.AddNew
![InvoiceId] = mId
![BuildDate] = Date
![BuildMan] = DLookup("EmployeeId", "tbEmployee", "UserName='" & mUserName & "'")
.Update
End With
rs.Close
Set rs = Nothing
DoCmd.Requery
'打开新记录编辑
Dim fm As Form
Set fm = New Form_fmTBuyInvoice ‘打开新窗口
fm.FilterOn = True
fm.Filter = "Me.InvoiceId='" & mId & "'" ‘过滤
fm.AllowAdditions = False ‘表头不可编辑
fm.Caption = "编辑发票" & mId
fm.Visible = True
coTBuyInvoice.Add Item:=fm, Key:=CStr(fm.Hwnd)
Set fm = Nothing
NewTBuyInvoice_Exit:
Exit Sub
NewTBuyInvoice_Err:
MsgBox Err.Description
Resume NewTBuyInvoice_Exit
End Sub
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
|