Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mparter
Yak Posting Veteran
86 Posts |
 Posted - 2002-06-20 : 05:42:21
|
| My database has linked tables to SQL Server 2000. I have a form called Machines that contains a subform called SubMachines. When I try to open the main form, Machines, I get the following error message:"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 expresion to variables."Then when I click on OK, it proceeds to open the form but the subform doesn't show. I'm not sure what's too complex as the field to relate the form and the subform is a simple autonumber integer field!I have never seen this error before so I'm just looking for some pointers as to what causes it.Thanks |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-06-23 : 11:31:29
|
| It is difficult to say what night be causing this error.Have you tried break pointing the code (if there is any?) and pinpointing the exact point the error is fired.Check all your queries and properties in case an expression exists within them, that either shouldn't be there or is wrong.Do you have any calculations on incompatible data types anywhere ?check any relevant statement syntax's are typed correctly.Do you have a query with a group by clause in it that has multiple exprsesions in it. e.g. trying to do a sum of a count to a varibale in one expression. (Hope that makes sense ?)Paul |
 |
|
|
|
|
|
Problem with Sub Form