在VBA发布后访问Windows 7上的问题 [英] Access 2007 on Windows 7 Problems After VBA Launched

问题描述

我有一个Access 2007表单，其中包含一个由VBA函数填充的控件。 它在Windows XP下运行正常。 当打开Access，打开数据库，打开表单时，它在Windows 7（64位）下工作正常。

但是，如果我然后打开VBA环境（不更改）任何语句）并返回到表单，该函数不再正常运行。

声明：

Me.RecordsetClone.FindFirst" [TrnID ] =" &安培; KeyValue

在打开VB之前按预期工作。 打开VB后，错误＃3059：用户取消操作。

如果我退出Access然后重新打开数据库，则表示没问题。 打开VB后，它就不再有效了。

任何线索？

 

 

 

解决方案

使用此错误意味着：

"您在正常完成之前停止了操作。某些数据更改可能尚未保存。"

 

那么您是否会中断.FindFirst命令的执行？

当您调试错误时，代码在什么行上断？

 

 

I have an Access 2007 form with a control populated by a VBA function.  It works fine under Windows XP.  It works fine under Windows 7 (64-bit) when Access is opened, the database is opened, and the form is opened.

However, if I then open the VBA environment (without changing any statement) and return to the form, the function no longer runs properly.

The statement:

Me.RecordsetClone.FindFirst "[TrnID]=" & KeyValue

works as expected before VB is opened.  After VB is opened, it errs with Error #3059 : Operation canceled by user.

If I exit Access then re-open the database, it is OK.  Once VB is opened, it no longer works.

Any clues?

 

 

 

解决方案

Usely this error means:

"You stopped the operation before its normal completion. Some data changes may not have been saved."

 

So do you interrupt the execution of the .FindFirst command?

When you Debug the error, on what line does the code breaks?

 

 

这篇关于在VBA发布后访问Windows 7上的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！