设为首页收藏本站Access中国

Office中国论坛/Access中国论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

12下一页
返回列表 发新帖
查看: 3083|回复: 15
打印 上一主题 下一主题

[与其它组件] [求助]我会疯了,好不容易写的代码,竟然在其他机上用不了!

[复制链接]
跳转到指定楼层
1#
发表于 2006-10-19 19: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.


耗时几个月的成果难道要泡汤!?高手们,救救我吧!

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?注册

x
分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 分享分享 分享淘帖 订阅订阅
2#
发表于 2006-10-19 19:50:00 | 只看该作者
我这里可以,按上面提示检查一下原因

3#
 楼主| 发表于 2006-10-19 20:31:00 | 只看该作者
谢谢!

能帮忙看看代码有什么需要改进的地方吗?

很奇怪,有些机上完全可以(都是XP SP2 Access2003),有些却不行,这是否跟登录Windows的权限有关?我们公司是用Windows Professional XP的操作系统。


[此贴子已经被作者于2006-10-19 12:32:28编辑过]

4#
发表于 2006-10-19 22:52:00 | 只看该作者
C:\WINDOWS\system32\stdole2.tlb

C:\WINDOWS\system32\iashlpr.dll

C:\WINDOWS\system32\iasrad.dll

以上引用文件你检查一下,缺失的话去拷贝一个。
5#
 楼主| 发表于 2006-10-20 01:34:00 | 只看该作者
试过了,我甚至把那三个文件复制过去并覆盖了原来的文件,但还是不行啊,sigh……
6#
 楼主| 发表于 2006-10-20 01:42:00 | 只看该作者
高手们,有其他办法吗?
7#
 楼主| 发表于 2006-10-21 00:22:00 | 只看该作者
up!!!!!
8#
发表于 2006-10-21 00:36:00 | 只看该作者
以下是引用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.

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

9#
发表于 2006-10-21 04:05:00 | 只看该作者
1。将可在 SP2 Access2003中运行的MDB编译一下,转为2002或2000版本后再试试

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

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

10#
 楼主| 发表于 2006-10-26 17:45:00 | 只看该作者
有些机上可以,但是大部分机上都不行,都提示了那个错误。

盼望高手能帮忙完善代码,谢谢拉!!
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|站长邮箱|小黑屋|手机版|Office中国/Access中国 ( 粤ICP备10043721号-1 )  

GMT+8, 2024-11-3 05:37 , Processed in 0.084329 second(s), 34 queries .

Powered by Discuz! X3.3

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表