[求助]我会疯了，好不容易写的代码，竟然在其他机上用不了！

AZA

我的电脑是XP SP1,Access2003的，其他电脑是SP2 Access2003.

打开文件的时候，错误提示如下：

Visual Basic for Applications (VBA) encountered a problem while attempting to access a property or method. The problem may be one of the following:
·A reference is missing.
·For help restoring missing references, see the Microsoft Knowledge Base article 283806.
·An Expression is misspelled.
·Check all expressions used in event properties for correct spelling.
·A user-defined function is declared as a sub or as a private function in a module.
·Expressions can resolve a user-defined function only if the function is declared as one of the following:
·A public function in a module
·A public or private function in a code module of the current form or report
·Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8 update is not installed.
·A more recent verion of Jet 4.0 must be installed for Access to function properly when security is set to Medium or High. To obtain the latest version of Microsoft Jet, go to Windows Update.


耗时几个月的成果难道要泡汤！？高手们，救救我吧！

nylgwsf9

应该是其它电脑上没有你用到的控件,你应该检查一下,如果确实没有,你应该拷贝 一个到那台电脑上并登录控件(仅拷贝不行的)

白河寒秋

下载的东西不能解压,奇怪!

binuochao

我这也能行,不过,系统是新装的!建可以重新装一下OFFICE2003试试看!

tmtony

是从引用中删除就可以了啊,我开始也不行,删除这个就可以了,可能是不小心引用了

AZA

以下是引用tmtony在2006-10-26 11:02:00的发言：


请在引用中 请删除
IAS Helper COM Component 1.0 type
IAS RADIUS Protocol 1.0 type library

两个引用就可以了

哇，MVP都来了～～

删除？怎么删除啊？是不是在引用里面把那两个勾去掉？还是把那两个引用对应的DLL文件从硬盘删除？

如果是前者的话，那么我勾掉了，可是这样还是不行啊，那个错误依然存在。

tmtony

请在引用中 请删除
IAS Helper COM Component 1.0 type
IAS RADIUS Protocol 1.0 type library

两个引用就可以了

AZA

有些机上可以，但是大部分机上都不行，都提示了那个错误。

盼望高手能帮忙完善代码，谢谢拉！！

Benjamin_luk

1。将可在 SP2 Access2003中运行的MDB编译一下，转为2002或2000版本后再试试

2。检查各PC中  C:\Program Files\Common Files\Microsoft Shared\VBA 下的文件是否完整

[此贴子已经被作者于2006-10-20 20:08:35编辑过]

andymark

以下是引用AZA在2006-10-19 11:36:00的发言：


我的电脑是XP SP1,Access2003的，其他电脑是SP2 Access2003.

打开文件的时候，错误提示如下：

Visual Basic for Applications (VBA) encountered a problem while attempting to access a property or method. The problem may be one of the following:
·A reference is missing.
·For help restoring missing references, see the Microsoft Knowledge Base article 283806.
·An Expression is misspelled.
·Check all expressions used in event properties for correct spelling.
·A user-defined function is declared as a sub or as a private function in a module.
·Expressions can resolve a user-defined function only if the function is declared as one of the following:
·A public function in a module
·A public or private function in a code module of the current form or report
·Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8 update is not installed.
·A more recent verion of Jet 4.0 must be installed for Access to function properly when security is set to Medium or High. To obtain the latest version of Microsoft Jet, go to Windows Update.

       这不是提示了你问题所在吗,一步一步排除呀