Видео

In this case, you already have all the data avilable, why perform a lookup that has to go find, open an object, then search through it and pass back a value? DLookUps are inefficient in a general sense and as much as possible, should be avoided.

Thank you for your support!

I'm not sure I understand the question. For perpetual licensed versions, 2024 is the most recent. For subscription based, then MS365 is the latest, but the build will depend on your update channel and what settings your IT department have put in place.

Thanks

Nice comment. Thanks for the counterpoint. I truly mean this, you've given me some serious food for thought about my channel. Sorry if you felt the content was emotionally charged, but after the same poor output for at least 15 years now what do you expect? I'm tired of the same crap, time and time again. It clearly shows a complete lack to caring. There's no other word for it. You don't repeatedly put out sub-par updates and features requiring months, if not years of fixes if you take pride in your work. Yet this is exactly what we keep being fed. Did you see all the bugs since CTR came out, Modern Charts, Modern Web Browser, Monaco SQL Editor, ... need I really go on, seriously?! Am I happy that we have a new SQL Editor, sure, I just wish they actually knew what QA was and took a minimum of pride in their work. Is it ready for production, God NO! What they've put out is a pre-beta version ready for their own internal testing, certainly not ready for end-user usage. As for crashes, I can't speak for others, but my system has no add-ins, just a standard install. It's a VM with nothing more than Office specifically to avoid any potential conflicts. Whether or not 3rd party developers are used, or not, is inconsequential to the discussion. MS, the Dev Team are responsible at the end of the day. It's their responsibility to oversee things and ensure quality. It is no different than any other project management task. Nothing else to say here. As for Access' Project/Product Management, what can I say, the product, features, updates speak volumes, but I'm not surprised based on past performances and the fact that our current PM is only 1/4, 1/5, 1/6 (not sure any what she had stated in an online meeting anymore) devoted to Access as she's responsible for so many other products/programs. Then again this just shows the importance put on Microsoft Access internally at Microsoft. I spent 10-15+ years providing constructive feedback! Reporting issues, screenshots, repo databases, pre-beta testing, with Access it doesn't work. You're simply ignored! They don't listen to our advice, if they did trust me Access would be a FAR better product!!! They don't even fix reported issues with documentation when it's reported. You want constructive criticism, look at years of feedback on uservoice/feedback portal and it's never used or actionned! They do as they please 'point final'. I've gotten better interactions with several other Microsoft teams (Outlook, Power Automate) when I've asked questions and reported issues, than from the Access team to the point that since about July I no longer even waste my time with them anymore! Look at what happened with the Research Panel, another joke. Look at the Roadmap, they can't even keep that up to date. The 2 elements they had on the go are both released, they can't even update the status to reflect that and that means the Roadmap is empty making Access look dead, again. The fixes page hasn't seen an update since February. So all the bugs go without support. And people are going to talk to me about Microsoft's Support, get real! No Release Notes! And then, let us not forget, this particular 'feature' was originally set for 2021 release (if my memory serves me). So MS had an extra 3 years and this is WHAT we get?! My opinion and statements were based on more than just this one new feature release. There's a clear pattern of behavior here. We can pretend everything is peachy, or we can call a spade a spade. Nothing will ever improve with the former this has been proven with the past 15+ years of Access development. It's just more of the same for Access. New 'feature' = lots of problems. Nothing new to report here.

In my opinion, the best option is to migrate to proper Web development technologies (.net, php, blazor, ...). Microsoft is slowly phasing out VBA (Outlook is just the first IMHO), desktop apps, how long will Access continue to be viable in it's current state? I think this current situation demonstrates a serious managerial issue, a fundamental lack of understanding of what people were asking for and a complete lack of internal QA! It's sad to keep seeing Access get degraded rather than upgraded.

It depends on your update channel. Are you on the current channel or some other one ? If the option doesn't appear in the options dialog, you haven't received the new feature yet. It's your db an mdb or an accdb?

I would like to make some php videos, but have been very busy actually doing PHP development for a client and simply haven't had much time.

Let's just hope with enough time Microsoft can make it work as it should!

Sadly, when office updates you will have it appear one day. I'm just hoping they fix this mess, fast!

Glad you liked the video!

Thank you for sharing.

There's no doubt that Microsoft is definitely trying to drive business to their cloud offerings, $$$! Access has been an afterthought for quite some time now. Even when they do release new 'features' they are far from ready for production and take months, if not years, to become stable and many bugs never get addressed, many features never get added leaving is with subpar tools. When I say this I'm referring to things like the Modern Charts, Modern Web Browser control, then new Monaco SQL Editor, ... Access is definitely not a priority.

From what I know, unfortunately, you can't turn off this notification in Internet Explorer as it is a security 'feature'.

@DanielPineault Ok noted, can we allow every time through vba code if we can't disable

No, not to my knowledge, that would kind of defeat the security if it was that easy to bypass it.

There is no way with the modern accdb file format beyond brute force attack . There are also applications you can buy to crack the password or some companies you can hire as well, but I'm most cases you are looking at days, if not longer to crack.

There are so many alternatives on the market now. Then there's the fact that most new developers go to web technologies that can do everything Access does, and more and are far more flexible.

@@DanielPineault Realy? I dont think so.

You don't think what? That there are alternatives or that new developers like web programming languages over an old VBA driven application like Microsoft Access? FileMaker is one alternative for instance. AirTable. Zoho PowerApps Caspio knack teable Nocodb kexi LibreOffice base Apache OpenOffice base Symphytum glom (web.archive.org/web/20190228143420/www.glom.org/wiki/index.php?title=Main_Page) ...

Glad to help, but at least this one is very straightforward and won't take too long to master. It truly is simple.

@@DanielPineault Cannot get your code to work. Only gives me the name of the file no metadata?

Does this happen if you use my meta data form?

@@DanielPineault Yes

What's your office installation 32 or 64 bit? You renamed the exiftool(-k).exe to exiftool.exe?

I don't have a lot of audio or video file to test with, but the exiftool does return all sort of info on the files I quickly tested. You could also try the technique explained in: www.devhut.net/how-to-retrieve-a-files-properties-with-vba/

You're most welcome.

Thanks.

My pleasure, glad it helped at least one other person!

Not much of an upgrade between 2016 and 2024, and no Access included.

Yes, I too experience such issues.

@@DanielPineault It has to do with windows explorer preview being turned on. When it is off, I dont experience the event. BUt I think there is a video accelleration setting that can be reset in excel. Not sure

That exactly the point made in the video; windows explorer preview causes problems, there's obviously a bug.

Don't you love that. It's just odd because it wasn't an issue previously. Microsoft just doesn't seem to be able to make updates without breaking something else.

Glad you found it useful.

Don't forget, it is still part of several MS365 subscriptions. But, as Microsoft seems to be trying to slowly phase out VBA and desktop apps, who knows what the future holds for Access!

I don't think there's truly much, but you can always review pages such as: support.microsoft.com/en-us/office/what-s-new-in-office-2024-and-office-ltsc-2024-baadecbe-a8fc-4435-8cb8-70e93fd08b56

Thank you

You mean class implements?

@@DanielPineault It is directive in class modules.

I'd tend to agree. The 'improvements' between 2021 and 2024 are pretty minimal.

@@DanielPineault no Publisher in 2024 though, sad for those of us who use it

Indeed, they're killing the product. Per support.microsoft.com/en-us/office/microsoft-publisher-will-no-longer-be-supported-after-october-2026-ee6302a2-4bc7-4841-babf-8e9be3acbfd7 they are now referring people to use Microsoft Create.

For the average person the changes made in the past 10, or even 20 years are in consequential.

@@DanielPineault So if I can get 2021 pro for $20... then it's a no brainer? I care more about Excel updates than Word though...

I'd be very skeptical to be able to purchase any version of office for $20!

Thank you for those kind words and thank you for taking the time to post your feedback. I truly appreciate it.

I don't have firsthand knowledge, but according to support.microsoft.com/en-us/office/what-s-new-in-office-2021-43848c29-665d-4b1b-bc12-acd2bfb3910a Co-authoring was available in Word, Excel & PowerPoint (but want available in the LTSC edition) They also mention the autosave feature lower in the article.

According to Microsoft's documentation: "Internet access is required for the following situations with Office 2024: Internet access is required to look up device pre-entitlements in case your device came bundled with a copy of Office. Internet access is required to redeem and associate a copy of Office with your Microsoft account or your device ID. Internet access is required to activate apps, like Word, Excel, and PowerPoint. Regular internet access is required to keep your apps up to date and to benefit from automatic updates and security patches. Periodic internet is required to keep your apps activated. Because Office 2024 does require the internet in the above situations, it is not an appropriate solution for use in fully disconnected scenarios. If you require a totally disconnected solution, consider using Office LTSC 2024." -- Microsoft "If you do not connect to the Internet periodically, your applications will go into reduced functionality mode, which means that you can view or print your documents, but cannot edit the documents or create new ones. To reactivate your Office applications, simply reconnect to the Internet." -- Microsoft

I think most people feel the same as you.

I thought Access was going the way of the Dodo a while back, then they invested in it, a bit. Then this. Then they're killing VBA slowly (Outlook first)... How long can Access continue without a web version.... Next they're disabling ActiveX controls by default. I just don't know anymore. What I do know is it is a mess. No central focus, lots of bugs with every new feature which they never completely address. Most features that are released are incomplete and take years to 'complete', just look at the 'Modern Charts'. Also, if you look at various usergroup videos and blog postings, you'll notice turnover within the Dev Team and Product Management, so a lot of lost knowledge there which also hurts progress. So much wasted potential, so poorly managed (I don't know if that's at the product level or upper management), underfunded & understaffed, ... How much longer will this keep going on for? Your guess is as good as mine!

I'd start by reviewing: support.microsoft.com/en-gb/office/what-s-new-in-excel-2024-for-windows-and-mac-faee26b6-ad74-40a8-9304-aa6db716553f which seems to indicate only the New LAMBDA function.

@@DanielPineault Thanks so much for that quick reply.

No problem. We'd need an Excel MVP to truly tell us if there are any others, but then again I'd expect them to be on that page.

​@@DanielPineault I tried to reply here with a link to a Microsoft community post with related query but it seems to be filtered out (by RUclips?)

I think RUclips block URLs except for video creators, but you could try being creative when posting it (omit http www, add a few spaces etc), it might work, but no guarantees.

Thank you for the ideas.

Yes, I don't think you're alone in that and truthfully Microsoft is trying to force everyone over to MS365.

I was sooooooooo close to doing the same this last couple weeks 😂👍 Think I might just buy a discounted 2021 though 🤔

It would currently seem that way.

Lol!

Truly glad you found it useful and thank you for your feedback!

Oh, Microsoft wants everyone on MS365 and has been pushing in that direction for several years now!

​​@@DanielPineaultYou are rigth but as Mike Wolfe said or wrote Microsoft don't want desktop applications! ☹️.

The only issue, and I agree that is their current goal, their is no web version of Access. They've webified Outlook, Excel, Word, PowerPoint, but not Access! So until they do that, we REQUIRE a desktop app. There is no doubt this was intentionally done. Nothing in an organization such as Microsoft just happens. They didn't forget about Access. The goal is pretty clear, if you want Access, and many people do, then join our SAAS and pay monthly for the rest of your life. Remember, a company only has one, true, objective and that is to make money to pay their shareholders. Everything else is secondary. The money is in SAAS although some believe that mentality is changing.

Office 2024 is merely a snapshot of Microsoft Office at a given point in time (whenever they decided to package it up as a 'new' version for sale). So by the time it is actually available, it is behind the MS365 version. The difference is that MS365 incurs a never ending monthly subscription fee and the minute you stop, all your applications cease to work and you can no longer use any of your files whereas Office 2024 is a one time fee and you can use the software for as long as you wish. No, there has been no change on the file size limitation in any version. You can either use multiple backends or switch to an alternate RDMS to get around the issue.

Office 2024 is a snapshot in time of MS365. So in reality, if you're running MS365 current channel, then you already have Office 2024 and probably more as you get feature updates which Office 2024 does not get. For perspective, 180$ is a one time cost vs. 7$ is a monthly subscription fee for the rest of your life. When you stop paying the monthly fee, you have nothing and can't use any of your Office files anymore. With a perpetual version (..., Office 2021, Office 2024, ...) it is yours for your life. But in your case, with MS365 already, Office 2024 is of no value to you unless you wish to get out of monthly fees, but from an application, feature perspective you have the best, most up-to-date version available.

Co-installation hasn't been a good idea since Office 2007. It used to be super easy and reliable to do, but now you should use VMs to segregate editions. Backwards compatibility used to be Access' biggest feature, this is no longer true. Thus, there are no guarantees of compatibility between versions especially moving forward. Now you get blank sections or files that you simply can't open. You can no longer open older files without having access to intermediary versions of Access to perform the file format conversion. New, worthwhile features... That's always a matter of opinion. As one person already started, most people could still simply use Office 97 for what they actually do. In the case of Access specifically, I haven't seen any real worthwhile new features in 10-20 years. The only one that might be of interest is the new SQL Editor, but that isn't even part of Office 2024 and has been pulled from testing because of issues.

MS Access has always been treated oddly, I feel that it's likely be removed altogether within the next few versions of office since they're slowly adding some of its more useful features into Excel

I totally agree. Access has always been Microsoft Office's ugly stepchild. A major second class citizen, ignored, understaffed, never advertised, ...

My pleasure, glad you liked it.