问题1和2的代码应该分别写在哪个事件(Event)里?
解决方案 »
- 再次发问,我说详细点 “ MYSQL 一个字段 同时符合两个条件”,感谢大侠,
- Sql 2000 数据库如何对数据进行加密
- SQL存储过程同参数,不同结果.求高手.在线等
- 如何将下面数据检索出来
- MSSQLSERVER:如何用SQL语句得到一递增列(不能增加字段)的问题。
- 我想了一个星期的问题!!高手请问? 就帮个忙吧
- 存储过程中 ,我想设一个参数既为输入参数,又为输出参数,可以吗?
- 怎样建立信任用户???
- 如何在setup的情况下,把自己写好的数据库导入对方的数据库中
- [跪求帮助]连接数据库时错误:证书链是由不受信任的颁发机构颁发的
- SQLServer中如何数据库中有完全相同的行(除了定义为identity的列不一样),如何消除多余的行。
- SQLServer中能否定义这样的数据类型??????????
if combo1.value="value1" then
Me.t_type_子窗体.Form.OrderBy = "date desc"
Me.t_type_子窗体.Form.OrderByOn = True
else
Me.t_type_子窗体.Form.OrderBy = "name asc"
Me.t_type_子窗体.Form.OrderByOn = True
end if2:与上面一样,代码用me.textbox1.Enabled=false3:在窗体设计器里,将窗体的属性“浏览按钮”改为FALSE。
SELECT S.SupplierName
FROM tblSupplier AS S
inner join tblOrder t2 on t2.supplierid=s.supplierid
inner join (SELECT OI.OrderID
FROM tblOrderItem AS OI
GROUP BY OI.OrderID,oi.received
HAVING SUM (OI.Requested) = OI.Received)) t1 ont t2.orderid=t1.orderidUNION SELECT tblSupplier.SupplierName
FROM tblSupplier left outer join tblorder on tblSupplier.SupplierID =tblOrder.SupplierID
WHERE tblOrder.SupplierID is null
FROM tblSupplier AS S
inner join tblOrder on tblOrder.SupplierID=S.SupplierID(
inner join (SELECT OI.OrderID
FROM tblOrderItem AS OI
GROUP BY OI.OrderID,OI.Received
HAVING SUM(OI.Requested) = OI.Received)) t1 on tblOrder.orderid=t1.orderidUNION SELECT tblSupplier.SupplierName
FROM tblSupplier left outer join tblorder on tblSupplier.SupplierID =tblOrder.SupplierID
WHERE tblOrder.SupplierID is null;========================
有报错,他说Syntx error . in query expression ".
SELECT tblSupplier.SupplierName
FROM (tblSupplier INNER JOIN tblOrder ON tblSupplier.SupplierID = tblOrder.SupplierID)
INNER JOIN
(
SELECT OI.OrderID
FROM tblOrderItem AS OI
GROUP BY OI.OrderID, OI.Received
HAVING (((Sum(OI.Requested))=[OI].[Received]))
) aaa ON tblOrder.OrderID = aaa.OrderID
unionSELECT tblSupplier.SupplierName
FROM tblSupplier left outer join tblorder on tblSupplier.SupplierID =tblOrder.SupplierID
WHERE tblOrder.SupplierID is null
总不成你把你的要求写给我,我来给你做吧?我已经回答得很清楚了。自己试试不行吗?VBA也不是很难。有什么问题,上这里问或是看VBA for ACCESS的帮助也可以找到。