Recent content by isladogs

You're welcome You might be interested in my article about Monaco giving details about its features, issues, bugs & fixes https://www.isladogs.co.uk/monaco-sql-editor There will also be several significant Monaco improvements in the next few months

Thanks are due to @MajP for this excellent session.

If you are on 365 then you won't be on LTSC as that is only for retail versions such as 2024. None of the retail versions have Monaco.

If Monaco is available to you, tick the checkbox shown below By default, it is then checked for all new ACCDB files. EDIT: It is, perhaps surprisingly, even available for MDB files opened in a suitable version of A365

The video of Anders Ebro's excellent presentation on Class Modules to the Access Europe User Group on 2 April is now available on YouTube: Enjoy!

Unfortunately the Stackoverflow thread linked in post #4 dates back to 2014 and much of the information is not up to date I've used digital signatures for about 10 years, first to sign EXE files used to distribute my Access apps. More recently to also sign the VBA projects for my ACCDB/ACCDE...

Not necessary. Read my comments again. Better still, read my articles.

That is exactly what will happen. The #If VBA7 clause is used for any app running 2010 or later (32-bit or 64-bit). Its not sprcifically 64-bit code. The #Else clause is only needed if there are users running A2007 or earlier (VBA6) See my series of 5 articles starting with...

Larger monitor => higher resolution => all Access interface items appear smaller

I edited my post to state I'd only done the replace part ...but clearly forgot to submit

Dim strText As String strText = "Hi, CAPSHO I'm writing this message CAPSHO on behalf or Mr. xyz. This matter is CAPSHO significant issue for our organization CAPSHO." strText = Replace(strText, "CAPSHO", "")

There has been a further update to the roadmap on 10 April. The additional item on zooming forms has also been announced publicly: Add Zoom slider magnification to Microsoft Access Access will add a magnification slider (10% to 500%) in the status bar at the lower right of the application...

Just for info, having waited for over a week, the OP did not make any attempt to respond to my request for proof of ownership. To me that indicates that this is probably not his own work. So I have now deleted his database from my hard drive and will not respond to any similar requests from...

First of all you don’t need to set warnings false twice. Delete one of those. Secondly, for testing purposes, disable the set warnings false line and see what happens. Do all the queries run show a message about the number of records that will be deleted? Does it work if you step through the...

The results in post #9 based on June’s query clearly showed there are both zero length strings and null values. That was why the Nz(field name, “”) filters worked. @Duane Just wondering why you thought the fields contained numbers. Possibly due to #9 which threw me at first