runtime -expression找不到函数 [英] runtime -expression can't find function
问题描述
打开mde时，用户会收到一条消息（如）日期（Format（Now（），yyyy）表达式具有Microsoft Access无法找到的功能。我检查了所有引用并重新注册了它们。非常感谢任何帮助.Alan
When opening an mde users get a message (like) a date (Format(Now(),"yyyy") expression has a function that Microsoft Access cannot find. I checked all the references and re-registered them. Same message. Any help is greatly appreciated. Alan
推荐答案
检查错误机器上的引用。
打开一些VBA代码（例如，通过按[CTRL + G]）并选择工具/引用。
每个以MISSING开头的库名必须取消选中，并且（例如，Microsoft软件版本x.xx）替换时必要的。
由于访问没有清理添加的库，通常会出现不必要的refenreces。
只需删除尽可能多的文件而不会出现执行错误;调试/编译所有模块
Nic; o）
Check the references on the "error machines".
Open some VBA code (e.g. by pressing [CTRL+G]) and select Tools/References.
Each libraryname starting with "MISSING" must be unchecked and (e.g. microsoft DAO version x.xx) replaced when necessary.
As access doesn''t cleanup added libraries, often unnecessary refenreces are present.
Just delete as many as possible without getting an error executing "Debug/compile all modules"
Nic;o)
打开mde时用户得到一条消息（比如）一个日期（格式（现在（），yyyy&q uot;）表达式具有Microsoft Access无法找到的功能。我检查了所有参考文献并重新注册了它们。同样的消息。任何帮助是极大的赞赏。 Alan
When opening an mde users get a message (like) a date (Format(Now(),"yyyy") expression has a function that Microsoft Access cannot find. I checked all the references and re-registered them. Same message. Any help is greatly appreciated. Alan
检查您正在使用的代码，并且仅出于测试目的，确定导致错误的函数（通过删除所有其他函数调用）。我担心我对MDE不是很熟悉，但我相信一旦你解决了问题，我们就可以找到一些解决方法。
@Nico - 我还没有意识到Ctrl-G甚至直接从主Access窗口直接进入即时窗格：）
Check the code you''re using and, just for testing purposes, determine which function is causing the error (by removing all other function calls). I''m afraid I''m not very familiar with MDEs but I''m sure once you''ve isolated the problem we can find some way of resolving it for you.
@Nico - I hadn''t realised that Ctrl-G takes you straight to the Immediate Pane even directly from the main Access window :)
嗨
感谢您的回复。该表单称为生日，并具有基于date（）的控件。该表格还有一个动画，可以在这个人的生日那天弹出一个球。这基于oncurrent事件中的以下表达式：
Hi
Thanks for responding. The form is called birthday and has a control based on date(). The form also has an animation that bounces a ball on the person''s birthday. This is based on the following expression in oncurrent event:
这篇关于runtime -expression找不到函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
