查询在Access97中有效，但在Access 2003中失败 [英] Queries works in Access97 but fails in Access 2003

问题描述

我已将Access97应用程序转换为Access2003。几乎在所有情况下它都可以正常工作，但在某些情况下却没有。从查询中附加的WHERE子句中，在SQL语句中对表单中的控件进行引用主要存在问题。

WHERE（（[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[ ]！[FilterPDCAID]）AND（（[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[ ; *"& [Forms]！[frmPDCAÖversikt]！[FilterKortBeskrivning]&" *"）AND（（[tblPDCA]。[AvslutDatum]）Null））OR（（（[Forms]！[frmPDCAÖversikt ]！[FilterÅtgärdade]）= True）AND（（[tblPDCA]。[PDCAID]）喜欢[Forms]！[frmPDCAÖversikt]！[FilterPDCAID]）AND（（[tblPDCA]。[AnsvSign]）喜欢[Forms]！[ frmPDCAÖversikt]！[FilterAnsvSign]&" *"）AND（（[tblPDCA]。[KortBeskrivning]）喜欢"*"& [Forms]！[frmPDCAÖversikt]！[FilterKortBeskrivning]&" *" ;）和（不（[tblPDCA]。[AvslutDatum]）是空的））;

有没有人可以帮我这个？

解决方案

对于fa无疑和准确的回复，请查看Office论坛的此链接并在那里发布您的问题。

适用于VBA，Office（VSTO），宏和VBScript问题


这是VB.Net论坛。 :)

I have converted a Access97 application to Access2003. In nearly all cases it works fine but in some cases it does not. There are mostly problem referecing a control in a form from the SQL statement as in attached WHERE clauses in a query.

WHERE ((([tblPDCA].[PDCAID]) Like [Forms]![frmPDCAÖversikt]![FilterPDCAID]) AND (([tblPDCA].[AnsvSign]) Like [Forms]![frmPDCAÖversikt]![FilterAnsvSign] & "*") AND (([tblPDCA].[KortBeskrivning]) Like "*" & [Forms]![frmPDCAÖversikt]![FilterKortBeskrivning] & "*") AND (([tblPDCA].[AvslutDatum]) Is Null)) OR ((([Forms]![frmPDCAÖversikt]![FilterÅtgärdade])=True) AND (([tblPDCA].[PDCAID]) Like [Forms]![frmPDCAÖversikt]![FilterPDCAID]) AND (([tblPDCA].[AnsvSign]) Like [Forms]![frmPDCAÖversikt]![FilterAnsvSign] & "*") AND (([tblPDCA].[KortBeskrivning]) Like "*" & [Forms]![frmPDCAÖversikt]![FilterKortBeskrivning] & "*") AND (Not ([tblPDCA].[AvslutDatum]) Is Null));

Is there anyone that can help me with this??

解决方案

For a faster and accurate response, check this link for the Office forum and post your question there.


For VBA, Office (VSTO), Macros and VBScript Questions


This is the VB.Net forum.     :)

这篇关于查询在Access97中有效，但在Access 2003中失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！