Is it really necessary to re-arrange the column order when I save a query? It tells me MS Access is reducing the QBE grid entries into SQL, optimizing that syntax and when asked for it later the presentation looks scrambled. While this may be needed internally, how much harder can it be to ask the internals to remember the column order?2 votes
Modify query designer to automatically make the appropriate change to all join lines when setting Inner/Left/Right on any join.4 votes
In earlier version of Access, when you modified a query the context menu had the choices of “Save”, “Save As…” and “Close” in the context menu. Since the ribbon was introduced, the context menu only provides “Save” and “Close”, if you’ve made a change in the query and don’t want to over write the existing one, you have to go to the File | Save Object As route to get to the “Save As..” dialog box.20 votes
Why not enableing the user to select "selected" columns / rows via Query - always looping thru itemselected is not very easy and intuitive.
Similar is with queries about Tables, queries, forms, reports, indizes fields (like in combobox) and Macros and all the other collections.3 votes
- Don't see your idea?