[VBA函数]： 为何我的VBA程序中chr,mid函数总报错？

frankyshu

我在2000下用VBA开发一个器材管理系统，可不知为什么运行时总是报chr或mid函数的工程或库找不到，请高手指点！

秋枫

寄件者：Jim Gray (jgray@chmc.org)
主旨：Re: Chr, Mid, Left & Right
新闻群组：comp.databases.ms-access
View this article only
日期：1999/09/21


This sounds like a reference issue.  This problem is well documented.  If
there are any missing references, functions like left, right ..... freak
out.  Check for missing references:

Open a code module
Select the references option from the tools menu

If there is a broken reference, it will be marked as MISSING: in the dialog
box.  You need to recreate the link to the appropriate file.  Click browse,
locate file and select it.

Jim Gray

<bigx76@my-deja.com> wrote in message news:7s8837$fsh$1@nnrp1.deja.com...

秋枫

You can also solve the specific symptom by using VBA.Mid, VBA.Mid$,
VBA.Chr$, etc. but remember that you still have the reference problem, and
it may bite you in other ways.

秋枫

寄件者：John Vinson (jvinson@cyberSPAMLESShighway.net)
主旨：Re: function 'chr', or 'Mid' not recognized
新闻群组：microsoft.public.access.gettingstarted
View this article only
日期：1999/02/19


On Fri, 19 Feb 1999 11:37:26 +0100, "jean-luc BOUDJEDID"
<jlucb@club-internet.fr> wrote:

>
>
>A newbie question :
>
>I've written an app using access97.
>everything work fine with my machine
>(I have VB5 installed also)
>
>When somebody else uses it, some errors occur :
>
>the functions 'chr' or 'Mid' are not recognized ...
>
>????
>
>Did I use some VB (non VBA) functions ?

This is a frequent bug in A97.  On that person's machine, open any
module in design mode (or hit Ctrl-G to open the debug window); select
Tools... References from the menu. One or more .dll libraries will
probably be marked MISSING.

Make sure the .dll is where it should be, check the box, close and
open Access; you'll be back in business.

秋枫

希望上述对你有帮助。

frankyshu

非常感谢，秋枫！！