Ms Access 2003中Report.Load()事件的替代方法 [英] Alternative for Report.Load() event in Ms Access 2003

问题描述

我在Access 2003中创建了一个应用程序，并在具有Access 2007的另一台计算机上继续使用该应用程序.我创建了一个报告，该报告的方法将数据从记录集加载到报告中的某些未绑定字段.此方法从报表的三个字段中获取三个参数值.该报告的数据源是一个查询.

I created an application in Access 2003 and continued to work on it on another computer with Access 2007. I created a report with a method that loads data from a recordset to some unbound fields on the report. This method takes three parameter values from three fields on the report. The report's data source is a query.

我在报表的Load()事件中调用该方法，例如LoadSummary([field1],[field2],[field3])，并且在Access 2007中可以正常工作.

I call the method in the report's Load() event, like LoadSummary([field1],[field2],[field3]) and works fine in Access 2007.

我切换回Access 2003，并且Load事件不可用.我尝试使用Open，Page和Activate事件调用该方法，但是都失败了，因为似乎在这些事件触发时，尚未使用数据填充字段.

I switched back to Access 2003 and the Load event is unavailable. I've tried calling the method using the Open, Page and Activate events but all fail because it seems like when these events fire, the fields have not been populated with the data yet.

请帮助.如何在Access 2003中使用它?欢迎任何大开眼界.谢谢.

Please help. How can I get this to work in Access 2003? Any eye openers are welcome. Thanks.

推荐答案

尝试报表标题部分的OnFormat事件.如果这样不起作用，请尝试在详细信息部分的OnFormat事件中，但是在报表级别的布尔变量中，因此它只执行一次.

Try the OnFormat event of the report header section. If that doesn't work try the detail sections OnFormat event but but in a report level boolean variable so it only does it once.

这篇关于Ms Access 2003中Report.Load()事件的替代方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！