宏错误2950 [英] Macro error 2950

问题描述

打开表单宏上的宏错误。它在过去的8个月里一直在努力。今天我收到了错误2950.仍然可以在另一个数据库中使用。

Macro error on Open Form Macro. Its been working for the last 8 months. Today I get Error 2950. Still works in another database.

为什么突然间它无效？ WareHouse MaterialsSplit，Form，" [jobID] =" &安培; Nz（[jobID]，0）,, Dialog。任何帮助将不胜感激。

Why all of a sudden is it not working? WareHouse MaterialsSplit, Form, , "[jobID]=" & Nz([jobID],0), , Dialog. Any help would be appreciated.

推荐答案

您好，

根据
关于错误2950的帮助文章，此问题如果 数据库不受信任。请检查数据库是否可信。

According to the help article about error 2950, this issue occurs if the  database is not trusted. Please check if the database is trusted.

是否有错误的详细信息？你在哪里运行宏？我建议你压缩和修复数据库。如果它不起作用，请尝试重新创建表单以检查问题是否仍然存在。如果它不起作用，请检查您的[jobID]。  你的jobID是多少
？ 如果jobID为Null，您使用Nz函数返回0？该字段可以为空还是0？

Is there detail message for the error? Where do you run the macro? I suggest you Compact and Repair the database. And if it doesn't work, please try to recreate the form to check if the issue persist. If it doesn't work, please check your [jobID].  What is your jobID?  You are using Nz function to return 0 if jobID is Null? Could the field be Null or 0?

问候，

Celeste

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