Відео

The Monaco SQL editor SUCKS !!! If you choose to write your query in SQL View, it forces you to save the query before entering a single character. This is a disaster for ad hoc queries. It looks lousy in dark mode and provides no way of changing the color scheme. There's simply not enough contrast to be usable. So, while it may be "supported" as Karl promotes... who cares if it isn't usable? You MS junior developers should go back to school before you start screwing up such a major piece of software. And please, please, please, take everyone from the QC Team with you (provided you have one). So, I don't care what it CAN do... it DOESN'T do the prerequisites. ABSOLUTELY USELESS! ... oh, and thanks for making it the default; forcing me to turn it off every time I open one of my databases for the 1st time. Really appreciate it! There are so many things that need to be fixed and yet MS introduces a new poorly tested half complete enhancement. And yet for all its shortcomings and lack of support it's still the best RAD db software available. Unqualified, uneducated, misinformed, poorly managed... yet for years, and for some of us, decades; it's been nothing but being ignored or supported by incompetence.... Microsoft's Feature Update motto? "We're here to make your life and workflow much, much worse; don't thank us... it's what we do!" Congratulations Microsoft on another poorly executed job.

hãy làm video tương tác giữa TwinBASIC và excel

Great work thanks man

Just downloaded the beta and, hey, I like it. A cinch to install just unzip it. Super light and quick, a total contrast to the bloated, sluggish behemoth which is visual studio. I imagine this would be a good way to pick up the skills you could apply to automate excel or access.

Great!

It would be great if they can add a SQL Formatter into the editor, like the ones you can download for VS Code. That would be insane!

does ms office have modern charts

This is great. So many things I will incorporate into my own practice. Thank you so much!

Sir I am one of the supporters of this language...I am looking forward for this...thanks to the creator of twinbasic...

Will we be able to add gridlines?

Wow, Great. Does this also means we later will see the Monaco Editor being used for editing VBA code inside Access? That would be very very welcomed....

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!

I really appreciate these, thank you