Search results

Thanks for that.

Had thought about this subject - doesn't actually affect me - but will be a problem to those who distribute Access apps to customers, checking to see if the users have the right version of Access. Assuming they use RegExp, of course.

After a happy hour of banging my head against a brick wall this morning I thought I'd start a thread where we can vent out spleen against stupid software. My experiences that really spring to mind are. Wanting to add a telephone number to an account which had, since I previously logged in, had...

Just bought mine from Amazon at £29.99 in March 2023. Obviously more expensive now but I bought the equivalent from Amazon last year for my wife's Laptop for £34.75. Currently working through my databases to update to using VBA RegExp. All we need now is for MS to introduce a proper distinct...

Microsoft® Access® 2021 MSO (Version 2508 Build 16.0.19127.20192) 64-bit

Back in the day MS Project worked well integrated with Outlook and manipulating both with VBA (about the year 2005 last used on Office 2003.)

I'm on 2021 bought in 2023 and never knowingly updated. RegExp is there and I 'v been testing it. For declarations and assignments I find I have to use the full VBA.RegExt, VBA.MatchCollection etc but it works well in the two databases I've tested it on.

That's a great relief to those of us who use RegExp all the time. And thanks for the thread as I'm sure I'd never have noticed.:)

Don't worry - in the UK a dog licence was for a long time more expensive than a wedding licence. I can't say if it still is as I haven't had a dog and the last time I got married we 'd only had decimal currency for 4 years!

My comments were not just nostalgia - as Doc Man says - "I remember the "good old days" but I remember how much better they got.", but also serious. I'm lucky in that I don't really think about coding but just do it and seldom wonder what to do but just how to do it in the circumstances. The...

A fascinating thread and I'm pleased to report that I understand it well. What it does show is just how much those of a certain 'vintage' take for granted about basic IT knowledge. It brought back memories of working with 256 kb memory when 64kb was the maximum addressable using paging blocks...

Couldn't endorse this recommendation more! Basically it is still good for everything except additional data sizes added and system limits. Wouldn't be without mine, which is the second edition. Mine cost £46.99 , which was lot of money in 2001 when I bought it!!

Not a new idea - it was our way of rolling out updates in Access 2 days in the early 1990s. We kept an .ini file on the server with the current version number and if your FE was not the latest version you got message telling you to run the batch file and closed your FE.

Can't agree more with this. I literally have thousands of scanned attachments associated with my databases. They are, however, all separate files with paths stored in the databases.

I did promise to shut up, but this reinforces my original point about quantity versus quality: how else do you explain the success of Starbucks (ugh).

Scotland is part of the UK! I would say, however, that my remarks about drinkable do NOT include UK - our coffee in cafes, restaurants etc is generally dreadful! Italian portions are small but generally excellent. American portions are so large that only the first 10% is ever hot. Anyway I...

At least that tablespoon is drinkable! 😀 And please don't lump all Europeans together - Europe's a continent and not a country.

Can't tell if you are agreeing with me, disagreeing with me, or just commenting! The point I was making is that the VB engine is the same whatever the application, it's just the embedding that changes.

There is really no difference between VB (pre .NET) and VBA: just in the past the versions lagged behind VB 5 / 6 etc before they got into Word, Excel, Access, Visio etc. As an MS Engineer said to me at their offices in Slough years back - they are all VBA but the Application that VB is...

Disagree - the feature was very useful at times when using customised Word documents. Multiple tab instances according to need were a deliberate part of the design. Is probably true in Access, however, where as the site shows most (many of the) problems raised are down to poor initial design...