วีดีโอ

MS is abandoning Access. It's not as sexy as web anything.

Adding my front end's location as a trusted location has worked for me so far. Thanks for the tip on your updated blog post. It saved me a lot of grief.

Many thanks Daniel, I had big problems with my application apart from the hanging one and followed your instructions to roll back. All good now waiting for Microsoft to fix it. Could be a while.

@6:49 I will let you know when I get the EdgeControlFE working, still working the BE code. Web standards is the way to go for the "modern controls" experience.

Awesome and well explained Thankyou

This is very helpful... thank you so much... learned so much with you explaining it via video vs text... any tips to optimize queries? As well as dao vs ado recordset?

I had that error and I saw an old solution from Computer Learning zone TH-cam channel and the issue was fixed by just adding the paths of the databases to be in the list of trusted locations. After closing any database the .laccdb disappears as a normal.

I created a batch file with "taskkill /IM "msaccess.exe" /F"

Thanks for the heads up. I've been recommending 2404 for months now. after 2405 where we had that performance and freezing issue. The one they fixed in 2406 but broke it again on 2407. It's strange they actually introduce new bugs while there's not much on being shared release-notes.

In the article on your website, you finished by saying "In the coming days I will be working further on both articles to add more information." Did this happen and where might I find it? Thanks

Nice compilation, most of which i knew and follow follow. The one about one subform to hold a graphic was new to me. I was amused by how many consist of turning off various conveniences that access provides.

Good on you 👍👏

I'm with you on having as much as possible in the UI driven by the database. Have you considered keeping your templates in a table? You don't need to do all of that string concatenation.

Great demo! Thanks.

Can you please teach me how to prepare this type of menu, thank you very much

Saludos, envia este mensaje : Acceso bloqueado: Error de autorización Client missing a project id. Si eres un desarrollador de esta app, consulta los detalles del error. Error 401: invalid_client

Thanks for your review and update on Microsoft Access Roadmap. Quite disappointing that Microsoft doesn't seem to give the needed attention to user feedback and improvement requests. Thanks so much for your commitment Sir. Regards

Awesome, thanks for sharing your guidelines and best practices. Very helpful.

TNX FOR THE HELP

Thanks for supplying the attachment method database as a download, this saves me a ton of time trying to workout it out for myself the way that it is demonstrated in the db download (method 2)

Each one of these rules deserves its own 10 minute video. And worthy of argument on the nuances. Each developer encounters their own unique challenges which may require variations on these rules but these are a very good start.

Microsoft Access - Best Practices = Don't use it, use a real database

Quite certain best practice is NOT to use Microsoft Access. Real databases exist, and for all other needs just do SQlite.

√√√

Thank you for the basics reminder, I have learned a few of the pitfalls.

I agree with you 100% of your advices. I also use a couple of features (with no issues) that you don't talk about: 1) Calculated fields on tables 2) Data macros Many access developers claim that they don't have to be used, but I dissagree with them.

Thanks Daniel, I learned something new today. I was not previously aware of the Track name AutoCorrect and record-Level Locking properties. I don't recall seeing these discussed anywhere else (or perhaps I was not paying attention).

my access database is very slow as search in list box or barcode reader its about 50k records plz guid me.

Extraordinary. With a multi-million user base - and thousands of developers who've been through the 'wars' helping users, this level of corporate disinterest is embarrassing. It's been my experience over 30 years, that Access is the go-to solution for small consulting companies that conduct monitoring and survey programs for their clients. Access offers rapid app development, reliable data management, relatively-easy data query ('relative for non-experts), and sufficiently-sophisticated analysis, reporting and export for these consulting companies to rest assured they're providing their clients with quality data. I continue to support at least 20 of these companies with their small, but business-critical, Access 'applications' because they cannot justify the initial and on-going cost of transitioning to cloud solutions, so they rely on Access; it feeds them, it feeds their clients, and it feeds me. How many repeats of this small-scale but valuable contribution must small business be making to society, across the Globe, for Microsoft to have apparently lost interest?

Any ideas why the "Get-ADUser -Filter { cn -like 'John Wick'} | select UserPrincipalName" cmdlet works but only in the PS_GetOutput example with writing to a file? In all other cases, calling PS_GetOutput with the mentioned cmdlet returns vbNullString. I use Excel 2019.

Kindly share your email if you work as a freelancer

How do I retrieve all the data I see if I go to a browser, right click, and choose View Page Source? So far I have not found VBA code that will return 100% of the information.

I think where the data driven menu comes into play more is for quickly implementing a new database using the same menu system. Not a huge amount of time savings, but nice for duplicating the same accordion menu on a new setup. If you edit the html in VSCode, there is an in editor color picker that makes it real easy to change the color scheme. I'm still kicking my self in the head after developing an accordion menu system using actual controls that are repositioned around and controlling all the visibility logic. This just blows what I was doing out of the water. Hopefully the edge browser control is improved to fix all those bugs you mentioned before. Thanks for all your hard work on this.

I just got around to playing with your examples on this Daniel, and I am not using your work around and it seems to be working every time without issue as long as I don't use my favorite Ctrl-Period to come out of design view. If I use F5 or used the Right-Click menu option to go to form view, it works every time. I'm wondering if they fixed the problem partially or my computer is just so fast that it doesn't have the timing problem. The only difference is I'm using a very simple function to set the ControlSource instead of your suggested code. I wanted the html files to load no matter which computer the front end was on. The only bug I encountered was due to the dashes in your form names (Invalid Character). Once I removed the dashes from the file form names, it all worked properly. Eventually, going back and forth from design view and form view does crash access, so there is that. I find access just crashes for no apparent reason while I'm developing way more than it used to. I always do debug compile and save before going to form view. Update: I put a DoEvents in the Open event code, and now everything works. Just realize that this won't work if the form names have dashes in them. Remove the dashes, and it works like a charm. Update2: Sadly, I was able to see the bug but it was very intermittent. I just kept doing Ctrl-W Enter over and over. It did show up occasionally even with your fix in. There is still some sort of timing issue going on. Update3: OK, I got it working now. I wasn't paying attention to the order you had the code. As long as the Do Loop is before the dynamic control source assignment, it all works as you demonstrated. I was so frustrated trying to get it working after that bug started to rear it's ugly head. Now I think I can rely on this and move forward with development. Thank you so much for figuring this out. ' This version works even with the Ctrl-Period method of going to form view and the form opens most of the time Private Sub Form_Open(Cancel As Integer) Private Sub Form_Open(Cancel As Integer) Do While Me.EdgeBrowser0.ReadyState <> acComplete DoEvents Loop Me.EdgeBrowser0.ControlSource = GetHtmlFileName("Menu-V-01.html") End Sub ' Put this in it's own module Function GetHtmlFileName(sFileName As String) As String GetHtmlFileName = "msaccess/" & Application.CurrentProject.Path & "\" & sFileName End Function

Great content as always Daniel, you enrich the Access community immensely. One solid mention than may need to be highlighted... After downloading the sample files, following the video and still failing (due to a number of errors) to have benefited from the functionality you highlighted, seems my Access v 2406 in MS Professional Plus 2021 still is using the prior browser control and not the new Edge Browser control. Unsure but the EB control may only be available in Office 365?

AWesome!

I have another crazy one! Use a file with the extension in capital letters as control source for the edge browser control. You will get lot of symbols as if you have opened it with notepad. I've tested it with images and pdf files so i think the bug happens with binary files. You can use Lcase function for a simple workaround.

excelent video and concepts Thanks

Signed the petition out of moral support

Could this be a way for MS to gauge demand, and then charge for it as another form of artificial segmentation?

VBScript is still around? Hahaha. Throwback to being a script kiddie in 2005. I remember it being convenient for getting code executed on my 'friends' computers until Windows caught up with it.

I found another bug with the edge browser control. If you put an edge browser in not the first tab of a tab control, the browser flashes the page once when loading the form. 🤦‍♂😒😭 They are making it a bit hard to replace internet explorer