Dialogue box Problems

qurn

Registered User.
Local time
Today, 13:48
Joined
May 2, 2005
Messages
63
I recently made a search form using the Like ""*" & [Forms]![search]![Text0] & "*" Or Is Null" in the Criteria. Now when I open the querie it opens a dialoge box that say's "enter paramiter value" then it has a little text box to put in the values for the criteria. but I don't want these boxes to come up how can I get rid of these?
 
Like ""*" & [Forms]![search]![Text0] & "*" Or Is Null"
is invalid. You are missing a field name:

Like ""*" & [Forms]![search]![Text0] & "*" Or SomeField Is Null"
 
just a field name, not a column name?I have tons of fields whitch one should I use, and how can I tell to use that one
 
Last edited:
field name is the same as column name when talking about a table or query.

As Pat said, you have to be specific when using an OR statement. That means that you will have to specifically state (after the OR) what field or textbox that you want evaluated for NULL.
 
I understand what your saying, but it doesn't seem to work. For example text 8 refers to the Date column. I've tried Or text8 is null, and Or Date is null and I still get the dialogue boxes. Every time I put in anything, it automaticaly put quotatians around it.
 
Is this a query that you are putting this into?

Can you post the exact syntax you are using? Maybe a screenshot would help.

Also, if you are referencing a field, then you must enclose the field in brackets []. If your field name is DATE, then change it. You should never use a reserved word as a field name, name of object, etc.
 
Every time I put in anything, it automaticaly put quotatians around it.
This is Access being TOO helpful. Surround you column names with square brackets [] to tell Access that they are not literals and Access will stop surrounding them with quotes.
 

Users who are viewing this thread

Back
Top Bottom