Access 2003 vs Access 2007 [英] Access 2003 vs Access 2007
问题描述
这是一个在Access 2003中工作的代码的简单示例，但是在访问2007中没有
。我已经使用调试器检查了它，并且
的原因是formField1的值在ver中没有变化。 2007年在
代码中作为docmd.gotorecord，acnext向下移动记录。但是它确实在2003年有
。有什么建议吗？
以5条记录的连续形式显示的表格示例。
1
1
1
2
3
示例代码：
当双击第1条记录时，光标应移动到
记录4.
私人Sub formField1_DblClick（取消为整数）
dim vTest as Byte
vTest = 1
Do while [formField1 ] = vTest
DoCmd.GoToRecord ,, acNext
循环
结束子
谢谢。
The is a simple example of code that worked in access 2003 but does
not in access 2007. I have checked it with the debugger and the
reason is the value of formField1 does not change in ver. 2007 in the
code as the docmd.gotorecord,,acnext moves down the records. But it
does in ver 2003. Any Suggestions?
Example of Table displayed in a continous form with 5 records.
1
1
1
2
3
Example Code:
When double Clicking on the 1st record the cursor should move to
record 4.
Private Sub formField1_DblClick(Cancel As Integer)
dim vTest as Byte
vTest = 1
Do While [formField1] = vTest
DoCmd.GoToRecord , , acNext
Loop
End Sub
Thanks.
推荐答案
微软花了大笔资金开发和简化Access /
Windows GUI，包括滚动条和默认值导航按钮。他们
快速，光滑，TTBOMK，万无一失。使用它们！
表格用于编辑数据，而不是愚蠢的按钮。
8月20日，10：12 * pm，pballou< pbal ... @ nctc.comwrote：
Microsoft spent big bucks developing and streamlining the Access/
Windows GUI, including scrollbars and default navigation buttons. They
are fast, slick, and, TTBOMK, foolproof. Use them!
Forms are for editing data, not silly buttons.
On Aug 20, 10:12*pm, pballou <pbal...@nctc.comwrote:
> *有什么建议吗？
>*Any Suggestions?
8月20日，9：28 * pm，lyle fairfield< lyle.fairfi ... @ gmail.comwrote：
On Aug 20, 9:28*pm, lyle fairfield <lyle.fairfi...@gmail.comwrote:
微软花了大笔资金开发和简化Access /
Windows GUI，包括滚动条和默认导航按钮。他们
快速，光滑，TTBOMK，万无一失。使用它们！
表格用于编辑数据，而不是愚蠢的按钮。
8月20日，10：12 * pm，pballou< pbal ... @ nctc.comwrote:
Microsoft spent big bucks developing and streamlining the Access/
Windows GUI, including scrollbars and default navigation buttons. They
are fast, slick, and, TTBOMK, foolproof. Use them!
Forms are for editing data, not silly buttons.
On Aug 20, 10:12*pm, pballou <pbal...@nctc.comwrote:
*任何建议？ - 隐藏引用的文字 -
*Any Suggestions?- Hide quoted text -
- 显示引用的文字 -
- Show quoted text -
我只是简化了代码，以便于理解问题。
我做的不仅仅是尝试向下移动这页纸。它是调度程序的一部分，它通过日期和时间来查找
开放时间段。有了这个说，你有什么想法为什么表格中的
值没有变化？
I just simplified the code to make it easy to understand the problem.
I am doing alot more than just trying to move down the page. It is
part of scheduling program that moves through dates and times to find
open time slots. With that being said do you have any ideas why the
values from the form are not changing??
我不明白为什么代码在07中不起作用。
我会做一些事情：
首先，做一个调试 - >编译一边看在代码。它是否可以编译？
并且，您可以尝试：
尝试使用me.formField1代替[formField]。甚至是我！FormField1
-
Albert D. Kallal（访问MVP）
加拿大艾伯塔省埃德蒙顿
PL ***************** @ msn.com
I don''t see why the code would not work in 07.
I would do a few things:
first, do a debug->compile while looking at the code. Does it compile?
And, you could try:
try using me.formField1 in place of [formField]. Or even me!FormField1
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
这篇关于Access 2003 vs Access 2007的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
