Query Designer

[moke123]

When did they update the Query designer.
I didn't see any recent posts about it and the change just took effect the other day.

Intellisense is awesome!

 

[tvanstiphout]

(please edit your subject line, so it is more accurate - or have an Admin do it for you)

The Monaco editor has been in the works for quite a while.

Current Feature Work: Monaco Editor + Modern Chart Improvements

Microsoft's Access team shows the development status of two upcoming features: Monaco SQL editor and Modern Chart improvements, which according to the M365 roadmap will be launched in a few months. The videos are excerpts from their presentation at Access DevCon Vienna on 18 April 2024.Software...

www.accessforever.org

 

[isladogs]

As Tom indicated, the query designer hasn't been updated. The Monaco SQL editor is available in Current Channel Preview and is likely to go to full release either at the end of this month or next. Here's a further example showing what it will look like:

I have put in a request that the pale grey (used above for operators such as INNER JOIN) be changed to something more readable
You can do various things such as change font size, indent lines, comment out parts of a query and much more

 

[arnelgp]

i am sure those colors can be set on the Option (Tools->Options->Editor Format)of the VBA?

 

[isladogs]

i am sure those colors can be set on the Option (Tools->Options->Editor Format)of the VBA?

The Monaco SQL editor is nothing to do with the VBE

 

[moke123]

I was surprised to see it Friday morning on my home machine but didn't have it when I got to my office.