本文介绍了报告+如果声明问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好,


请快速提问。


我有一份报告,提供与所有已处理工作相关的查询。查询中的一个文件是作业的当前状态。该工作可以是打开,关闭也可以是打开。或取消。


查询的记录显示在报告的详细信息部分。


现在我想将以下内容添加到格式事件中报告的详细信息部分,但它不起作用..我不断收到有关声明的错误(对属性的无效引用可见)。有什么建议?字段显示在表单上。状态字段也设置为不可见。我也尝试过这个报告的Open事件,而且也没有用。


如果Me.Status =取消然后

Me.lbl_cancelled.Application.Visible = True

ElseIf Me.Status =" Closed"然后

Me.lbl_cancelled.Application.Visible = False

结束如果


''取消的标签假设出现在如果作业被视为取消,则记录。


提前致谢。

Hi All,

Just a quick question please.

I have a report that feeds off a query relating to all processed jobs. One of the fileds in the query is the current status of the Job. The job can either be "open", "closed" or "cancelled".

The records of the query appear in the detail section of the report.

Now i wanted to add the following to the format event in the detail section of the report, but it doesn''t work.. I keep getting errors regarding the statement (invalid reference to the property visible). Any suggestions? The fields are present on the form. The status field is set to invisible as well. I have also tried this int he Open event for the report, and that didn''t work either.

If Me.Status = "Cancelled" Then
Me.lbl_cancelled.Application.Visible = True
ElseIf Me.Status = "Closed" Then
Me.lbl_cancelled.Application.Visible = False
End If

'' The label cancelled is suppose to appear on a record if the Job is considered cancelled.

Thanks in advance.

推荐答案





现在一切都有意义。

Now it all makes sense.

展开 | 选择 | Wrap | 行号


这篇关于报告+如果声明问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

05-27 23:21
查看更多