| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 743 人关注过本帖
标题:求助: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
快速回复:求助:STemp问题
数据加载中...
 
   



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

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