记录源错误 [英] Record source error

问题描述

我已经设置了一个数据库，以便用户可以通过在未绑定的参数表单上输入条件来运行报告。有时表单有效，然后其他时候没有，我们得到以下错误。


此表单或报表上指定的记录源''~sq_cParamForm~sq_cFindMgr'不存在。


如果用户开始运行报告然后在完成报告之前退出报告，则会出现此错误。当发生这种情况以便运行报告时，我必须进入数据库并用我的备份文件中的表单副本替换表单。


有没有办法防止这种情况发生？


谢谢，

I have set up a database so that users can run a report by entering the criteria on an unbound parameter form. Sometimes the form works and then other times it does not and we get the following error.

The record source ''~sq_cParamForm~sq_cFindMgr'' specified on this form or report does not exist.

This error seems to happen if a user starts to run a report and then exits out of it before they complete it. When this happens in order to run the reports I have to go into the database and replace the form with a copy of the form from my backup file.

Is there any way to keep this from happening?

Thank you,

推荐答案

我希望如此，但不知道是什么导致它，很难说是什么。


你需要提供一些与问题有关的信息。

I expect so, but without any knowledge of what is causing it, it''s hard to say what.

You need to provide some information that pertains to the problem.

我不确定是什么导致它。该表单具有管理员名称的未绑定组合框，开始日期的未绑定框，结束日期的未绑定框和运行报告的命令按钮。我认为问题可能是当用户开始在表单中输入信息时，他们从管理员名称下拉框中选择一个名称，输入开始日期，然后他们决定不运行报告并关闭它。我不确定这是否会使表单挂起，因为当您尝试返回并尝试运行报告时，我们点击Managers Name的下拉框时会收到错误消息。我们在错误消息上单击确定并关闭参数表单，将出现输入参数值框（就像在正常访问报告中未在参数表单中运行一样。


希望这有助于理解我遇到的问题，尝试尽可能地解释。我想知道我是否在管理器名称组合框的更新后事件中放置了一个重新查询程序，如果这样做有帮助的话。


非常感谢任何帮助。

I''m not exactly sure what is causing it. The form has an unbound combo box for the Manager Name, an unbound box for the start date, an unbound box for the end date and a command button to run the report. I thought the problem might be that when a user starts to enter the information in the form, they choose a name from the Manager Name dropdown box, enter the start date and then they decide not to run the report and just close out of it. I am not sure if this makes the form hang up because then when you try to go back in and try to run the report as sooon as we click on the drop down box for the Managers Name we get the error message. We click on OK on the error message and close the parameter form, an Enter Parameter Value box comes up (as it would in a normal access report that is not being run from a parameter form.

Hope this helps in understanding the issue I am having, tried to explain as best as I could. I wonder if I put a requery procedure in the after update event of the Manager Name combo box if that would help.

Any assistance would be very much appreciated.

当您在字段中输入数据时，是否在VBA中运行代码，或者您是否等待OnClick事件？


我想你需要发布你正在运行的代码。


-AJ

Are you running code in VBA when they enter data in the fields, or do you wait for an OnClick event?

I think you need to post the code you are running.

-AJ

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