OnClick事件未触发 [英] OnClick event not firing
问题描述
我有一个Access 2003表单通过ODBC绑定到SQL Server表。
通常单击表单上的按钮会产生重新查询
表单的效果，而不是触发OnClick事件。有没有人有一个
的解释？这是腐败的证据还是已知的副作用？
TIA
布鲁斯
I have an Access 2003 form bound to a SQL Server table via ODBC.
Often clicking a button on the form has the effect of requerying the
form rather than firing the OnClick event. Does anyone have an
explanation? Is this evidence of corruption, or a known side effect?
TIA
Bruce
推荐答案
br********@comcast.net 写道：
br********@comcast.net wrote:
我有一个Access 2003表单通过ODBC绑定到SQL Server表。
经常单击表单上的按钮有效重新获取
表单而不是触发OnClick事件。有没有人有一个
的解释？这是腐败的证据还是已知的副作用？
I have an Access 2003 form bound to a SQL Server table via ODBC.
Often clicking a button on the form has the effect of requerying the
form rather than firing the OnClick event. Does anyone have an
explanation? Is this evidence of corruption, or a known side effect?
从未听说过它。永远。我想这意味着腐败是可能的，但是
只在某些时候？
-
Rick Brandt，Microsoft Access MVP
电子邮件（视情况而定）至...
Hunter dot的RBrandt
Never heard of it. Ever. I suppose that means corruption is possible, but
only some of the time?
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
br ******** @ comcast.net 写在
新闻：57 ** ******************************** @ e39g2000 hsf.googlegroups.co
m：
br********@comcast.net wrote in
news:57**********************************@e39g2000 hsf.googlegroups.co
m:
我有一个Access 2003表单通过ODBC绑定到SQL Server表。
经常单击表单上的按钮有重新查询的效果
表单而不是触发OnClick事件。有没有人有解释？
？这是腐败的证据，还是已知的一方
效应？
I have an Access 2003 form bound to a SQL Server table via ODBC.
Often clicking a button on the form has the effect of requerying
the form rather than firing the OnClick event. Does anyone have
an explanation? Is this evidence of corruption, or a known side
effect?
命令按钮的OnClick事件中的代码有什么作用？
-
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA /
" David W. Fenton" < XX ******* @ dfenton.com.invalidwrote in message
news：Xn ********************* *************@74.209.1 36.89 ...
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@74.209.1 36.89...
br ******** @ comcast.net 写在
新闻：57 *************** ******************* @ e39g2000 hsf.googlegroups.co
m：
br********@comcast.net wrote in
news:57**********************************@e39g2000 hsf.googlegroups.co
m:
>我有一个Access 2003表单通过ODBC绑定到SQL Server表。
通常单击表单上的按钮具有重新查询表单而不是触发OnClick事件的效果。有没有人有解释？这是腐败的证据，还是已知方的影响？
>I have an Access 2003 form bound to a SQL Server table via ODBC.
Often clicking a button on the form has the effect of requerying
the form rather than firing the OnClick event. Does anyone have
an explanation? Is this evidence of corruption, or a known side
effect?
命令按钮的OnClick事件中的代码有什么作用？
-
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA /
我有时碰到类似的东西。如果我更改某些
控件的名称，有时链接到该控件的事件会丢失。不知何故。为了
修复，我退出VBA代码并返回到表单设计视图。然后我选择失败控件的
属性窗口。然后我向下滑动到
相关事件。通常情况下应该说[事件程序]。但当
它丢失时，该属性为空白。所以我点击省略号（...）和
选择代码生成器。这将打开VBA代码并重新建立链接
到我的编码事件。
Fred Zuckerman
I''ve run into something similar, sometimes. If I change the name of some
controls, sometimes the event linked to that control gets "lost" somehow. To
fix, I exit the VBA code and return to form design view. Then I select the
properties window of the failing control. Then I cursor down to the
associated event. Normally the event should say [Event Procedure]. But when
it''s "lost", the property is blank. So I click on the ellipsis (...) and
select "code builder". That opens the VBA code and re-establishes the link
to my coded event.
Fred Zuckerman
这篇关于OnClick事件未触发的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
