Dick Watson
My feedback
-
1 vote
Dick Watson shared this idea ·
-
4 votes
An error occurred while saving the comment -
3 votes
Dick Watson shared this idea ·
-
6 votes
An error occurred while saving the comment Dick Watson commented
You can do this from the Edit toolbar in the VBA IDE.
-
7 votes
Not sure if this is a bug report, or something very specific for your database.
Please share more information so we can understand the issue.
Thanks,
The Access TeamDick Watson supported this idea ·
An error occurred while saving the comment Dick Watson commented
Try editing a chart control on a scaled high DPI screen. See thread https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_winother-mso_2016/has-anybody-at-microsoft-ever-edited-an-access/2f92f12e-38d3-4a2e-a2d2-52a521ff0d7f for screenshot examples.
-
4 votes
Dick Watson shared this idea ·
-
32 votes
Dick Watson supported this idea ·
An error occurred while saving the comment Dick Watson commented
QBE needs ability to show non-equi-joins in the QBE grid. Show the line with a click button in the middle, say, that can show the exact join expression. Why not make it possible in the QBE grid to drill-down the displayed tables (open their table design), or, even better, create or edit embedded subqueries (open them in their own Query Editor) similar to what is done for setting a lookup query?
-
65 votes
Dick Watson shared this idea ·
-
233 votes
The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!
Thanks,
Ebo [MSFT[Dick Watson supported this idea ·
You can do this by editing the SQL by hand in the pathetic Assess SQL editor. Once you do this, the QBE grid becomes useless and/or destructive to your query.
As a more generalized solution, this should be added to the QBE grid as, say, a click box on the relation line that allows a non equi-join to be defined/indicated for that relationship. QBE should also get the ability to define/edit a subquery.