Search results

Not sure why the error, but it may just be an issue of needing to recreate the command button that is used inthe switchboard to run the report.

I don't know if you are still checking the post re: Qry still runs after cancelling event/closing form posted by qckslvr1999, but I have figured out a relatively easy way to get the second, default, parameter prompt to not appear after cancelling a custom dialog parameter form. It's nothing...

I don't know if you are still having trouble with this problem, but I figured out a way to fix most of the problem (albeit a bandaid). I have set up a custom dialog to enter criteria for a report...I did it just like the Access help instructs...using a macro with open, close, ok and cancel...

I have a report that lists three records, four of the fields in these records are based on fields from a main table that are lookups to different queries (i.e., [pollutant code] field stores a number from a lookup that displays the code number and a description of the pollutant...only the...

Thanks...using And instead of Or did work. But it still doesn't make sense why using Not Like...Or...Or... DID work on one of my databases (just as the Not Like...And.... worked). Thanks again.

jwindon: The query is a simple filter query, off one field in one table, so there are no joins. Jack Cowley: I tried importing to a clean db...that did not work. I forgot to mention that I tried the Not In ("xxx", "yyy", "zzz") expression, and that does work, but it's not as convenient because...

I have built this very basic query in which I want to filter out a few records. I have attempted several versions of the Not Like "xxx" Or "yyy" or "zzz" criteria (all in the same criteria line, in different lines, in different instances of the same field, etc.) The best I get is the first...