วีดีโอ

Karl, This looks great!

Great work Karl. It's especially good to see direct communications with the Access Dev team after years of talking to a Closed Door!

do you plan to make map chart too??

Being able to reference aliased columns in calculations or in WHERE conditions would be cool too if possible. The only way to currently do this is through a subquery.

I have restarted programming in VB6 after a gap of twenty years. My aim is to resurrect all my older VB6 and my more recent javascript desktop programs, converting each ultimately to modern TwinBASIC and 64bit operation, thereby avoiding forced obsolescence. Enjoying being at the cutting edge for a change!

I've been working on a Personal Electronic Health Record project, and wanted to generate historical reports that I could send to new doctors, giving them a snapshot of what has happened up to now, My plan was to do a query that took dated event information (change of dosage, start of new medication etc.) and use it as a backdrop to see how these events have impacted various other markers that are recorded (blood pressure, weight, glucose/cholesterol and other regularly tested blood and urine biomarkers). I could also be helpful in looking at other event/result environments like, say, how specific marketing campaign events changed (or not) the sales numbers of a product or department. I was going to make an events alone query into a report and convert it to an image file to use as a background image to a biomarker report but...now I'm thinking it would be a lot easier if your team could handle it (without the wiggle/wiggle background positioning) ..cheers 🙂

When will the Modern Chart enhancements become available in the insider/beta channels? Any predictions? Will the Access Team collect feedback with beta releases early enough in the development process to incorporate the feedback into the final release?

for the box and whisker , please add pts for MEAN, MEDIAN, and OUTLIERS

great news! Something that seemed fantastic to me and made Access stand out in the user experience were the pivot charts. I don't know the reason for their discontinuation, but it would be fabulous to have them again.

Thanks Karl! Enjoyed the video and shared on my LinkedIn. ~Linda (Access PM)

My main question on all these charts and their various options is will all the API options and capabilities be exposed to VBA (and/or Javascript, if/when that becomes a development language option in Access) - AND - equally as important, will the related API DOCUMENTATION be both MEANINGFUL, complete, and have USEFUL Demo code (something that is far too frequently short-changed)?

Support for syntax indenting (i.e. the way the SQLTools works in VS Code)

I'd mention that the Intellisense prompt referenced all tables, not just those in the FROM clause. It'd be very important for the prompt to be able to check that clause, so it could consider aliasing. i.e. typing an aliased table would also provide an Intellisense prompt for that table's columns.

very good… Thanks microsoft and thanks Karl

Nice feature, and definitely needed. A great additional feature would be to have the editor be SQL Server aware for Passthru queries that connect to SQL Server. In orherwords bring as much as you can from SSMS Sql editor into the MS Access/Passthru query editor, so the autocomplete would be aware of SQL Server functions and keywords, and even tables of the initial catalog in the connection string.

I've been waiting for this for a long time and have even toyed with building my own using the Scintilla editor. Here are the features I would like you to include in the Monaco editor: - Does the Monaco editor work along with the Query Designer? Can I jump back and forth between views? I expect that comments I make in the SQL view will not be lost when I make changes in the Query Deisign view. - Parenthesis matching. When I select a parenthesis it should highlight the matching parenthesis. Provide a hotkey so I can jump to the matching parenthesis. (CTRL+B in Notepad++) - Do comments have to be on their own line or can I add a comment to the end of a line? - Support for /* block comments */ would be nice. - SQL Formatting. Can you provide a hotkey or automatic SQL formatting? At a minimum can it put a carriage return before these statements: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, INSERT, VALUES, SET, UNION. Another nice to have formatting is putting each SELECT column on its own row. Some SQL formatters have configurable options so you can specify if the comma is before or after each column name. I have written my own SQL formatter in AutoHotkey if you want some cues: www.autohotkey.com/boards/viewtopic.php?t=107188 - The editor should support vertical selection of text. This comes in handy if you need to alias a bunch of coluimns - Dark mode Wish list - Will I be able to embed the Monaco editor onto an Access form? I've got a form where users can edit SQL queries. It would be great if I could use this instead of large text control. - It would be cool if it could convert Access SQL queries to T-SQL for pass-through queries. I created the rules behind a website that does this and I'd be willing to share code with the Microsoft Dev's. accessusergroups.org/sql-converter/ It was stated in the video that the Microsoft Team wanted feedback. Can we see some replies here to acknowledge you are listening? ⁉

Sachin demonstrates adding two hyphen symbols to add a comment, which is presumably a single-line comment as it is in SSMS. Will the Monaco Editor support multi-line comments, using /* Multi-line comment entered here */ ? Also, will the Monaco Editor please allow us to get rid of the visual clutter with the tablename.fieldname that Access is famous for adding? It is really only necessary if a query references > 1 table where two or more tables contain identical field (column) names and the query references that fieldname. The vast majority of queries do not require this additional disambiguation.

I use charts extensively for stock charting. Would be great to have candlestick charts added/

Word cloud is cool especially if it used to linked to a powerpoint presentation.

This charting is a welcome feature upgrade. These visualizations bring a PowerBI charting ability to Access. Very cool.

Any new feature in Ms Access is welcome but in my opinion to improve charts was not a priority.

In my experience as a facilities manager I appreciated a robust data dashboard to keep my eyes on important metrics. Often had to have my team provide a bridge to excel to achieve that as limitations in Access was there. Adding more charts to Access is a big win. I now create solutions for small entities that need major assistance in managing real estate portfolios and cannot afford enterprise level CAFM/CMMS solutions. Your work here will definitely assist me in meeting specific needs. 👍

Hi, many thanks colin, you are generous.

Thank you for all your efforts on this New Feature, we truly appreciate your efforts on this. What I would strongly require is a feature where the editor could show me the End if for its If construction statement. This will visually make it easier for the programmer to get to the endif of a particular If statement if the connections are visually shown in the editor. I have seen this feature in some other editor's many years ago and I wish if Access would have the same. Also please work on the Responsive Forms feature and have it released at your earliest possible convenience. Its because nowadays we are working on modern hardware and we run into alot of resolution issues if its not a desktop that a user is working on. We usually have faced resolution issues running Access (Any version) on a Microsoft Surface Laptop/Tablet. Please help us also make the forms look like web forms. This would be of great help to us as developers and to our users of our implemented projects.

For the dev team: if we can have it in Dark mode as well that would be amazing!

Great news. Will it work on linked tables- say to sql server? No matter what, a great new feature, and the sql editor needed some love and care for a long time.

Awesome - looking forward better SQL development! Request to the Microsoft Access team - Currently the SQL editor right-click popup menu has the standard Cut/Copy/Paste options. Please add: Execute (F5), Parse (Ctrl+F5) and Property Sheet (Alt+Enter). SSMS uses the name Property Window (F4) whereas Access uses Property Sheet - prefer the SSMS option. Thanks!

Thanks for the vid, looking fwd to the Monaco sql improvements? Any news of them fixing all the bugs in the new Edge Bowser control our is it getting left to Daniel Pineault to come up with workarounds?

Finally: the did it! 😂😂😎😎

News flash for all Access devs: the year is 2024, mobile is king everywhere. Also we're still waiting for a proper SQL editor. In 2024.

Will it support a Forms!formName!ControlName reference ? To me this is the secret weapon of Access development.

Super, wurde auch Zeit.

awesome, long overdue feature!!!

Very cool

Good news! Thanks for sharing. 🤗

Wow! Been waiting for this for years!! :)

Good to see the twinBASIC programming language getting a wider audience. 👍

AccHitTest ... Kannt ich gar nicht! Sehr spannend! ... und dann bei 50:00 die Bombe: "Geht nicht mit negativen Koordinaten ... " - Als gelernter M$ler, nur mild verwundert. Mannomann! Wir schreiben das Jahr 2024. ich habe genau diese Konstellation hier am Schreibtisch, weil der eine oder andere Kunde das eben auch hat ... Wetten werden angenommen, wann M$ den Bug fixed: Ich sage: nicht vor 2030! Danke für den Upload!

QUESTION: does anyone know if the fact that Access was obviously a rip off of Apple Macintosh’s Fourth Dimension database software has anything to do with Access never being changed to work across platforms like the other office products? I’m a huge fan of Access, worked with it since the very first release to improve processes and visibility at my workplace and share a patent with two others for which I did all the application work, so not criticizing Access - even though Fourth Dimension was in my opinion decades ahead of Access (and Paradox).

I really appreciate these, thank you

Did you start with Fox News? 😁

Always brings a smile to my face. Thank you Karl and Viktoria for doing what you do!

I've just bumped to this project, it's just amazing. I was wishing and hoping for this for years! Edit & Continue ! Are you kidding :)))

Thank you for the sharing , it's wow

I believe that it is better to concentrate on solving problems that others d works around just an example is cascaded combo box also enhancing controls proberties an addition to creating reusable component that do a lot of steps of logic just for example pre built wizard that can be used in doing some logic in business or master details form builder or pre built wizard tha can be used as report launcher all those examples that enhance the reusability and make developer focus more on building business logic you must study tha the transformation that oracle do between forms developer and oracle apex as a tool

⭐⭐⭐⭐⭐

Karl Du brauchst einen Mode-Berater 😂

Thanks for sharing. And like Word or Excel, would be nice to get a zoom bar for Access forms, more then say larger then 22 inches of design area.

Excellent presentation. Very curious about a lot of subjects they mentioned. I am a Access VBA developer in the Netherlands

Excellent. Thank you so much to both Karl and the Access team