标题:求助:STemp问题
取消只看楼主
呜噜嘿咻
Rank: 1
等 级:新手上路
帖 子:3
专家分:0
注 册:2010-2-1
结帖率:0
 问题点数:0 回复次数:0 
求助:STemp问题
If IsNull(Me![入库时间]) = True Then
        '弹出提示“铝材类型”文本框不可以为空信息
        MsgBox "请输入“入库时间”,它不可以为空!", vbOKOnly, "输入“入库时间”"
        '把光标置于“铝材类型”文本框内
        Me![入库时间].SetFocus

    Else
        '为保存计划“查询语句”字符变量赋值
        STemp = "INSERT INTO 保护膜表"

        STemp = STemp & "( 序号,入库时间,入库单号,供应商,型号,粘度,"

        STemp = STemp & "保护膜,品名,厚度,宽度,长度,重量,"
        
        STemp = STemp & "库号,备注,剩余重量)"
        
        STemp = STemp & "VALUES ( ''&" & Rs.RecordCount + 1 & ","
        
        STemp = STemp & "'" & Me![入库时间] & "','" & Me![入库单号] & "',"
        STemp = STemp & "'" & Me![供应商] & "','" & Me![型号] & "',"
        STemp = STemp & "'" & Me![粘度] & "','" & Me![保护膜] & "',"
        STemp = STemp & "'" & Me![品名] & "','" & Me![厚度] & "',"
        STemp = STemp & "'" & Me![宽度] & "','" & Me![长度] & "',"
        STemp = STemp & "'" & Me![重量] & "','" & Me![库号] & "',"
        STemp = STemp & "'" & Me![备注] & "','" & Me![剩余重量] & "')"
        


剩余重量在那里添加语句 让 剩余重量 = 重量 呢?我添加都是出错,希望大侠指导下。。谢谢啦!~
搜索更多相关主题的帖子: STemp 
2010-02-01 08:51



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-296989-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.430036 second(s), 8 queries.
Copyright©2004-2025, BCCN.NET, All Rights Reserved