运行时错误'13' [英] Runtime Error '13'

问题描述

我有一个最初在Access 2中创建的Access数据库，然后转换为Access''97，并在几年前再次转换为Access''03。


在转换为''03期间，确定DAO引用不正确，需要更新到3.6，我们做了。


我有一个不会在03年运行的宏但是会在'97下运行


运行宏时，生成的错误是

运行时错误''13''类型不匹配'

I have an Access DB that was originally created in Access 2, then converted to Access ''97, and a few years ago converted again, to Access ''03.

During the convert to ''03 it was determined that DAO reference was incorrect and needed to be updated to 3.6 which we did.

I have a macro that won''t run in ''03 but will run under ''97

When running the macro, the Error generated is
"Run TIme Error ''13'' Type mismatch"

展开 | 选择 | Wrap | 行号

推荐答案

@ Frabker3


只需将代码重写为更简单，更高效的代码就更容易了。仅当表存在并且其中包含至少1个记录时，以下函数将返回True：

@Frabker3
It was easier just to rewrite the code to something simpler and more efficient. The following Function will return True only if a Table exists AND contains at least 1 Record in it:

展开 | 选择 | Wrap | 行号

你能说吗？哪一行代码生成了错误消息？


欢迎来到 Bytes ！

Can you say which line of your code generated the error message?

Welcome to Bytes!

原帖子的第11行是令人讨厌的线。但是编程中的所有内容都可能在其他地方。

Line 11 of the original post is the offending line. But like everything in programming could be elsewhere as well.

这篇关于运行时错误'13'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！