Error 3071...Help

[dvannoy]

I am getting and error 3071 in an append query that I have been running for several months. this happened on Monday also. After I rebooted my system the error went away.

Error 3071 states that the query is too complex to run.

The only criteria I have is Date() Or Date() -1

it has always worked before....Does anyone know why all of the sudden it would stop working??

Or can anyone help me to fix this

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[Databaseguy]

Go into the VBE and check your references. Intrinsic functions will quit working when there is a bad or missing reference.

Make a new form with a command button and try the following((Or in the debug window):

Private Sub Command1_click()
msgbox date()
End Sub

If you get an error, references are the most likely culprit.

Also, double check all of your fields and expressions in your query. Just yesterday, I had

Week: =Left(Format([Ship_DAte],"YYYY,MM&quot*"-"& Right(format([Ship_Date],"YYYY-MM&quot instead of =Left(Format([Ship_DAte],"YYYY,MM&quot & "-"& Right(format([Ship_Date],"YYYY-MM&quot and I got that error... Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[dvannoy]

I found the problem...I had added a missing reference to a users system. I also thought what the heck i'll add Visual Basic Application Extensions. As soon as I did that the error popped up. I then thought about it and removed it. Error went away. I would'nt normally Freak out about this sort of thing But when you have 20-30 people calling you all of the sudden saying there getting this error it as you probally know can be a headache.

Thanks for your time DVannoy
A+,Network+,CNA
dvannoy@onyxes.com