All of the playlists selected for updating no longer exist
There is a good reason for that, and it must be accepted as an intrinsic limitation of the entire “criteria grid” concept.
To maintain compatibility with the query design grid, the trick is to switch the criteria and the field, like this: Note: add other columns without a criteria to display these fields, if needed.
” The vital question that is often overlooked, or asked only in passing is: “why do you need this option, and how do you intend to use it?
” Depending on the answer, the solution can be surprisingly simple.
Many apparently good solutions will totally mess up the query grid when the query is next opened.
The demo file contains one query that looks perfectly reasonable in SQL view, but gets totally mangled by the query design grid.
Simply add this message: “A blank filter means that you do not want to filter on this field; use [Del] to delete the value from a combo box.” Perhaps also “none”, “all active products”, “VIP only”, etc.Luckily, with a few easy-to-follow instructions, it's not hard to navigate i Tunes and sync your device for quick, easy file transfers.This is such a frequent request that literally hundreds of pages can be found describing one technique or another to achieve the desired result.When controls on a form are used as criteria in a query, Null values usually break the mechansim.This is the reason for the vast majority or requests to add “all” as an option.