Query Form

[danny123]

Hi there,

In my access database i have one query form which dynamically creates the query and perform it on the database.

suddenly it started giving the error 3315.
Field cant be zero length string.

It happens only when i put the search condtion like
Modified by --> Contains --> "xxx"

but when i search the same thing for other user name it works fine.

Please advice.

Thanks
Danny

 

[Guus2005]

Field cant be zero length string.

Assumes that you want to insert or update a field which can't be zero length. Duh...

It happens only when i put the search condition like
Modified by --> Contains --> "xxx"

but when i search the same thing for other user name it works fine.

I am not sure what you mean by this.