With Data6.Recordset
.Edit
If Val(Text2.Text) < 10 Then
If Val(Text3.Text) < 10 Then
.Fields(7) = Text1.Text + "0" + Text2.Text + "0" + Text3.Text
Else
.Fields(7) = Text1.Text + "0" + Text2.Text + Text3.Text
End If
Else
If Val(Text3.Text) < 10 Then
.Fields(7) = Text1.Text + Text2.Text + "0" + Text3.Text
Else
.Fields(7) = Text1.Text + Text2.Text + Text3.Text
End If
End If
.Fields(0) = Combo2.Text
.Fields(1) = Combo1.Text
.Fields(2) = Combo3.Text
.Fields(3) = Text5.Text
.Fields(4) = Text6.Text
.Fields(5) = Text7.Text
.Fields(6) = Val(Text6.Text) * Val(Text7.Text)
.Fields(8) = Text9.Text
.Update
End With
With Data6.Recordset
If bz1 = 1 Then
.AddNew
.Update
End If
.Bookmark = .LastModified
.Edit
If Val(Text2.Text) < 10 Then
If Val(Text3.Text) < 10 Then
.Fields(7) = Text1.Text + "0" + Text2.Text + "0" + Text3.Text
Else
.Fields(7) = Text1.Text + "0" + Text2.Text + Text3.Text
End If
Else
If Val(Text3.Text) < 10 Then
.Fields(7) = Text1.Text + Text2.Text + "0" + Text3.Text
Else
.Fields(7) = Text1.Text + Text2.Text + Text3.Text
End If
End If
.Fields(0) = Combo2.Text
.Fields(1) = Combo1.Text
.Fields(2) = Combo3.Text
.Fields(3) = Text5.Text
.Fields(4) = Text6.Text
.Fields(5) = Text7.Text
.Fields(6) = Val(Text6.Text) * Val(Text7.Text)
.Fields(8) = Text9.Text
.Update
End With
Data1.Refresh
'While Data1.Recordset.EOF = False
st = ""
y = 0
dy = 0
st = Data1.Recordset.Fields(0) + Data1.Recordset.Fields(2) + Data1.Recordset.Fields(1)
Data2.Recordset.FindFirst "品名+供应商+规格=" + "'" + st + "'"
If Data2.Recordset.EOF = False Then
y = Val(Mid(Data2.Recordset.Fields(7), 5, 2)) '库存中的购入日期的月
dy = Month(Now)
If dy = y + 1 Then
sl = sl + Data2.Recordset.Fields(4)
End If
End If
'Wend
Dim fd As String
Private Sub Command1_Click()
Data1.Refresh
Data4.Refresh
'While Data1.Recordset.EOF = False
st = ""
sy = 0
dy = 0
byxs1 = 0
st = Data1.Recordset.Fields(0) + Data1.Recordset.Fields(2) + Data1.Recordset.Fields(1)
byxs1 = Data1.Recordset.Fields(3)
Data2.Recordset.FindFirst "品名+供应商+规格=" + "'" + st + "'"
If Data2.Recordset.EOF = False Then
sy = Data2.Recordset.Fields(8 + Month(Now) - 1)
Data4.Recordset.AddNew
Data4.Recordset.Fields(0) = Data1.Recordset.Fields(2)
Data4.Recordset.Fields(1) = Data1.Recordset.Fields(0)
Data4.Recordset.Fields(2) = Data1.Recordset.Fields(1)
Data4.Recordset.Fields(4) = sy
Data4.Recordset.Fields(6) = Data2.Recordset.Fields(21)
Data4.Recordset.Fields(8) = byxs1
Data4.Recordset.Fields(10) = Data2.Recordset.Fields(8 + Month(Now))
Data4.Recordset.Update
End If
'Wend
End Sub
Private Sub Command3_Click()
Unload Me
End Sub
Private Sub Form_Activate()
Data1.DatabaseName = App.Path + "\telepho.mdb"
Data1.RecordSource = "guige"
Data1.Refresh
Data2.DatabaseName = App.Path + "\telepho.mdb"
Data2.RecordSource = "kcb"
Data2.Refresh
Data3.DatabaseName = App.Path + "\telepho.mdb"
Data3.RecordSource = "xiaoshou"
Data3.Refresh
Data4.DatabaseName = App.Path + "\telepho.mdb"
Data4.RecordSource = "jxczhbb"
Data4.Refresh
Text1.Text = Year(Now)
Text2.Text = Month(Now)
Text3.Text = Day(Now)
If Val(Text2.Text) < 10 Then
If Val(Text3.Text) < 10 Then
fd = Text1.Text + "0" + Text2.Text + "0" + Text3.Text
Else
fd = Text1.Text + "0" + Text2.Text + Text3.Text
End If
Else
If Val(Text3.Text) < 10 Then
fd = Text1.Text + Text2.Text + "0" + Text3.Text
Else
fd = Text1.Text + Text2.Text + Text3.Text
End If
End If
fd = Mid(fd, 5, 4)
End Sub
没有合适的资源?快使用搜索试试~ 我知道了~
print-soft.zip_Soft!_印刷
共122个文件
frm:31个
frx:21个
tmp:17个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 119 浏览量
2022-09-23
11:51:20
上传
评论
收藏 2.5MB ZIP 举报
温馨提示
一款VB编写印刷行业的信息管理软件,麻雀虽小,五脏俱全 ,数据库、串口通信等等应用都在里面,真的适合新手学习用的。
资源推荐
资源详情
资源评论
收起资源包目录
print-soft.zip_Soft!_印刷 (122个子文件)
Module1.bas 306B
Thumbs.db 9KB
DataReport4.DCA 50KB
DataReport1.DCA 49KB
DataReport3.DCA 49KB
DataReport5.DCA 49KB
xiaoshoudy.DCA 49KB
DataReport2.DCA 49KB
de1.DCA 8KB
DataReport3.Dsr 29KB
DataReport4.Dsr 25KB
DataReport5.Dsr 22KB
DataReport1.Dsr 20KB
DataReport2.Dsr 20KB
de1.Dsr 16KB
DataReport4.dsx 18B
DataReport2.dsx 18B
DataReport3.dsx 18B
DataReport5.dsx 18B
DataReport1.dsx 18B
ywdjfrm.frm 33KB
xiaoshou.frm 29KB
ruku.frm 29KB
zhd.frm 24KB
tuihuo.frm 20KB
maincd.frm 18KB
xscx.frm 16KB
kccx.frm 13KB
xiaoshoucxjg.frm 12KB
xinghao.frm 12KB
chssz.frm 11KB
cqcp.frm 10KB
gysmx.frm 10KB
khdan.frm 9KB
pinming.frm 9KB
historyfind.frm 9KB
zhhzb.frm 9KB
zzjtcx.frm 9KB
kcbcx.frm 8KB
xscqkscx.frm 8KB
kcbcxjg.frm 8KB
xhrk.frm 7KB
czydl.frm 6KB
xiaoshoucx.frm 5KB
mmlr.frm 5KB
xskscxjg.frm 4KB
mmsz.frm 4KB
Form7.frm 4KB
sjbf.frm 3KB
sjhf.frm 3KB
lskccx.frm 2KB
maincd.frx 2.71MB
xiaoshoucx.frx 798B
czydl.frx 778B
ruku.frx 56B
gysmx.frx 32B
xiaoshou.frx 32B
pinming.frx 32B
xinghao.frx 32B
lskccx.frx 32B
kcbcxjg.frx 29B
xiaoshoucxjg.frx 29B
xskscxjg.frx 21B
kccx.frx 20B
khdan.frx 20B
chssz.frx 20B
xscx.frx 20B
kcbcx.frx 12B
tuihuo.frx 12B
xhrk.frx 12B
xscqkscx.frx 12B
historyfind.frx 12B
PC01.ICO 1KB
CRDFLE13.ICO 1KB
CRDFLE12.ICO 1KB
BICYCLE.ICO 1KB
KEY04.ICO 1KB
FOLDER05.ICO 1KB
GRAPH12.ICO 1KB
FILES04.ICO 1KB
FILES09.ICO 1KB
ty0191.jpg 206KB
ty0341.jpg 181KB
ty0271.jpg 165KB
ty0261.jpg 163KB
ty0201.jpg 140KB
ty0171.jpg 122KB
ty0311.jpg 120KB
ty0181.jpg 117KB
ty0241.jpg 116KB
ty0331.jpg 113KB
ty0321.jpg 108KB
scen397.jpg 64KB
scen391.jpg 62KB
KHDAN.log 565B
telepho.mdb 1.59MB
mmlr 4KB
mmsz 4KB
MSSCCPRJ.SCC 201B
VB32.tmp 44KB
共 122 条
- 1
- 2
资源评论
朱moyimi
- 粉丝: 64
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功