Hi,
I have completed an Access application on my test server and it is now on the production server. The application runs great! (On my pc) Except...
There is one report that will not run on the production server. I have made sure that the version of Access (2000) and the version of VB (6.0) are the same.
When the gets run (from a button), it comes up and says "Run-time error "3071": This expression is typed incorrectly, or it is too complex to be evaluated. For example a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables"
The code stops on a DOCMD.OPENREPORT (both report options give the error) statement that runs the report.
This has nothing to do with a complex expression (does it?)
Here's the code:
Run_Report:
...
'Run the report w/criteria
If strcrit9 <> "" Then
strwhere = strwhere & strcrit9 & " AND "
ListBoxWhereClause = Len(strwhere)
ListBoxWhereClause = ListBoxWhereClause - 5
strwhere = Left(strwhere, ListBoxWhereClause)
DoCmd.OpenReport stDocName, View:=acViewPreview, WhereCondition:=strwhere
rs3.Close
Exit Sub
Else
'Run the report wo/criteria
DoCmd.OpenReport stDocName, View:=acViewPreview
rs1.Close
rs2.Close
Exit Sub
End If
Also..
When I exit out of the same application (via an exit button on my switchboard) I get the strangest message. "The Microsoft Jet database engine cannot open the file 'Path\db1.mdb'. It is already opened exclusively by another user or you need permission to view its data.
I am not using db1.mdb. That is not the name of my appl! Nor am I creating an .mdb name "db1"!
So wherre is that coming from? Remember, this works fine on my pc and server.
Lost and Frustrated
I have completed an Access application on my test server and it is now on the production server. The application runs great! (On my pc) Except...
There is one report that will not run on the production server. I have made sure that the version of Access (2000) and the version of VB (6.0) are the same.
When the gets run (from a button), it comes up and says "Run-time error "3071": This expression is typed incorrectly, or it is too complex to be evaluated. For example a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables"
The code stops on a DOCMD.OPENREPORT (both report options give the error) statement that runs the report.
This has nothing to do with a complex expression (does it?)
Here's the code:
Run_Report:
...
'Run the report w/criteria
If strcrit9 <> "" Then
strwhere = strwhere & strcrit9 & " AND "
ListBoxWhereClause = Len(strwhere)
ListBoxWhereClause = ListBoxWhereClause - 5
strwhere = Left(strwhere, ListBoxWhereClause)
DoCmd.OpenReport stDocName, View:=acViewPreview, WhereCondition:=strwhere
rs3.Close
Exit Sub
Else
'Run the report wo/criteria
DoCmd.OpenReport stDocName, View:=acViewPreview
rs1.Close
rs2.Close
Exit Sub
End If
Also..
When I exit out of the same application (via an exit button on my switchboard) I get the strangest message. "The Microsoft Jet database engine cannot open the file 'Path\db1.mdb'. It is already opened exclusively by another user or you need permission to view its data.
I am not using db1.mdb. That is not the name of my appl! Nor am I creating an .mdb name "db1"!
So wherre is that coming from? Remember, this works fine on my pc and server.
Lost and Frustrated