Office中国论坛/Access中国论坛

标题: [求助]有没有禁止使用鼠标滑轮的ap函数，该如何写？i [打印本页]

作者: beaccesssuper 时间: 2007-3-21 19:27
标题: [求助]有没有禁止使用鼠标滑轮的ap函数，该如何写？i
[求助]有没有禁止使用鼠标滑轮的ap函数，该如何写？
谢谢，在线等。

此外对数据的显示占带宽问题，比如求一组查询结果每个项目的最值均值等应该将计算公式写道窗体上还是用sql语句，哪个更快最值均值结果不用存储。

此论坛如何贴图，试了几次都不行，请指点，谢谢。
[em01][em06][em06][em06][em06][em06][em06][em06][em06][em06][em06][em06]

作者: 一点通 时间: 2007-3-21 19:35
1.可以用"滚轮"关键字搜索一下旧贴

2.不明什么意思

3.图片可以直接上传(不能用贴图的方式),数据库要用WINRAR打包后上传

作者: beaccesssuper 时间: 2007-3-21 19:53
2的意思就是在窗体里只显示结果但不存储到表，是在窗体的设计视图中的recordsource里加计算公式快还是在查询纪录时在sql语句里用公式那个快如meas_sql = "SELECT round(Avg([Ul_V]),2) & iif(IsNull(StDev([Ul_V])),'','±' & round(StDev([Ul_V]),2)) as Meas_ul, " _
'             & " round(Avg([P_W]),2) & iif(IsNull(StDev([P_W])),'','±' & round(StDev([P_W]),2)) AS Meas_P, " _
'             & " round(Avg([Phi_lm]),2) & iif(IsNull(StDev([Phi_lm])),'','±' & round(StDev([Phi_lm]),2)) AS Meas_phi, " _
'             & " round(Avg([phi_lm]/[P_W]),2) & iif(IsNull(StDev([phi_lm]/[P_W])),'','±' & round(StDev([phi_lm]/[P_W]),2)) AS [Meas_eta], " _
'             & " round(Avg([x]),4) & iif(IsNull(StDev([x])),'','±' & round(StDev([x]),4)) AS Meas_x, " _
'             & " round(Avg([y]),4) & iif(IsNull(StDev([y])),'','±' & round(StDev([y]),4)) AS Meas_y, " _
'             & " round(Avg([T_K]),2) & iif(IsNull(StDev([T_K])),'','±' & round(StDev([T_K]),2)) AS [Meas_T], " _
'             & " First(tdtaBenchHaloDaten.Calc_EKn) AS Ekn, " _
'             & " round(Avg([Reflektor_Halbwertswinkel]),2) & iif(IsNull(StDev([Reflektor_Halbwertswinkel])),'','±' & round(StDev([Reflektor_Halbwertswinkel]),2)) AS Meas_HW, " _
'             & " round(Avg([Reflektor_MaxLichtstaerke]),2) & iif(IsNull(StDev([Reflektor_MaxLichtstaerke])),'','±' & round(StDev([Reflektor_MaxLichtstaerke]),2)) AS Meas_Imax, " _
'             & "fctEstimatedLD([tdtaBenchHaloDaten].[idBenchDaten]) AS Estim_LD, " _
'             & " Count([tdtaBenchHaloMesswert].[Ul_V]) AS [Anzahl von LpNr], [tdtaBenchHaloMesswert].[Alter_h] FROM tkeyBench " _
'             & "LEFT JOIN ((tdtaBenchHaloDaten LEFT JOIN tkeyBenchHaloLampe ON [tdtaBenchHaloDaten].[idBenchDaten]=[tkeyBenchHaloLampe].[idBenchDaten]) LEFT JOIN tdtaBenchHaloMesswert " _
'             & "ON [tkeyBenchHaloLampe].[idLp]=[tdtaBenchHaloMesswert].[idLp]) ON [tkeyBench].[idBench]=[tdtaBenchHaloDaten].[idBench] " _
'             & " where tdtaBenchHaloDaten.idBenchDaten=" + Str$(rs_clone!idBenchDaten) + "  AND (tdtaBenchHaloMesswert.Ul_V)>0 GROUP BY [tdtaBenchHaloMesswert].[Alter_h],tdtaBenchHaloMesswert.Alter_h, fctEstimatedLD([tdtaBenchHaloDaten].[idBenchDaten]) " _
'             & "ORDER BY [tdtaBenchHaloMesswert].[Alter_h] "

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)