Search results

@MajP Article now updated. You are correct that the limit using VBA was also increased to 50 with Access 2013.

Yes that needs updating. Thanks for pointing it out. I made use of the workaround by @Royce on several occasions but it didn’t always work eg when there were spaces in the expression. However I think it was much later that the code bug was completely fixed as suggested in the final post in that...

Thanks. I've fixed it in my post as well.

I created something very similar to the second screenshot above many years ago, originally to get around the (then) limit of 3 CF colours. However the idea of using colour values stored in a table remains just as useful now that limit no longer applies More info in my Colour Conditions...

Well I learned something skimming the first part of that PDF where I read that …

1. ONLY isn't a recognised keyword in Access 2. As Category Type should only have one item per record, no single record should be both Car And Bike . . . UNLESS you are using MVFs in which case a different approach is needed. One approach would be to do 2 separate queries filtering for Car and...

For many years, I did exactly this process with about 30 CSV files each night at about 2 am, importing data into the SQL server BE for my main school database. The import files were also very large so the total process typically took around 45-60 minutes. However, the process was completely...

If you read the MS article that I linked in my own article, the change was designed such that all existing code will continue to work. However, for early binding you no longer need the separate Regular Expressions library from 2508 onwards For late binding the code remains Set regEx =...

Its read only. I did experiment with setting extended file properties using VBA a few years ago. Unfortunately, it can only be done for a limited range of Office file types - those in XML format e.g. .xlsx, .docx, .pptx.

As already stated, retail versions receive security and feature updates. LTSC versions ONLY receive security updates , typically monthly. If purchased from official channels, LTSC are sold with a volume license agreement. If an individual copy is purchased from resellers, the software may not...

So its retail version of 2021 and has been updated regularly. As you are now on version 2508, you have RegExp in the VBA library as explained at the start of this thread.

It probably updates automatically during idle time. What is the version and build info? See File Backstage View … Account…About Access (as in the screenshots earlier in this thread)

The important point is the version you have (2108) rather than the bitness. LTSC editions do not receive feature updates . . . though @arnelgp seems to have found a way of doing so with 2024 LTSC

I don’t believe bitness is relevant. I have tested in both bitnesses and RegExp is present in both cases.

That's also surprising! I have the E5 Enterprise edition of 365 and that does include RegExp in VBA

Now that’s interesting and also unexpected. 👍 From the screenshot, that is 2024 LTSC but its getting updates as if it were a retail version. According to the MS website, the latest version of 2024 LTSC is 2408 (Build 17932.20540)...

I also have 2021 Pro LTSC for which the latest version is 2108 (Build 14334.20296) LTSC are volume licensed versions - not retail - and do not receive regular feature updates The latest retail version for 2021 is Version 2508 (Build 19127.20222)...

You’re welcome.

Perfect. Thanks I've updated and published the article with that information

Thanks. That’s what I hoped to see. So 2021 and 2024 should also be fine. Anyone able to test using 2016?