Search results

I'd just like to thank Isladogs for starting this thread. Has been extremely useful, especially where it is reminding me of things I know but had forgotten!

I did know a lot more in the past, when the controls were essential. I usually found the problems when I just couldn't to with the controls in Access, what I could do in Word. As you say time to move on - and thank you for the info about using UserForms directly in Access - wish I known that...

Ah but they don't work fully - I suggest you do some extensive usage - some properties of the controls just aren't exposed. And your right - MS Forms Date picker has now gone (using Access 2021). Most of my usage was with 2003 and earlier and to be honest I just don't have the inclination...

In general the Forms2 controls, which you can insert into Access forms - especially the Date Picker. Not so useful as they once were in older version as MS has 'enhanced' Access.

The other real advantage of user forms is that most Active X controls run with all facilities which is not true with Access forms.

I'd love to be "holier than thou" on this but actually I've done far worse - I went for years not realizing that right clicking on the start button was a shortcut to Explorer. It has certainly been a feature since Access 97, when I wrote my own equivalent since I didn't like it as it was too...

Agreed - at root the Excel spreadsheet sheet that you see is still dao technology.

Security is all relative. Access is weak but probably good enough in most situations, whereas keeping all your financial details on your mobile phone is never safe. As we were told at GCHQ - security doesn't need to be good - it needs to be good enough. At its simplest if your threat horizon...

Much of the discussion on this thread has been, quite sensibly, about security issues; however, the initial question was far more fundamental - can the commercial available offering do the job that the current system does? The simplest answere I'd give is to ask the people who use the current...

I'm not doubting the technology- it's the people involved and their management of the systems to ensure the collection and retention.

I wouldn't be so sure about that! I wrote an archive database for my wife's school as few years back. I could tell tell you the results for the public exams in 1910 and the records of school governors meeting for the first 70 years of the 20th century which were stored on paper,, but not...

Don't give anyone advice, especially yourself! There is only one sensible bit of advice ever - "You are never too old for a teddybear"

No - you're a youngster! All depends on your point of view.

A fascinating thread but nowhere have I seen anything that would ever encourage me to use a MVF instead of a properly normalised database. Obviously just my opinion. 🙂

My favourite 'Lehrerism' remains: "Life is like a sewer - what you get out of it depends on what you put into it"

The point being covered here by some and ignored by some is that the date/time data type is exactly that and the time element is a date fraction. If all you are interested in is time values then it is the wrong data type!

I agree good, clear tutorials - whereas the RegEx library often has examples of exactly what you are looking for. They are very different sorts of resource, which both have their place.

This thread has gone long past where any contribution from me on RegEx makes any sense but for those who are scared of using Regular Expressions I recommend Reg Ex Library this is my go to when flumoxed.

If you do your import in code it doesn't care about the extension.

Everything about Copilot where it has intruded on me has been an absolute nuisance: it certainly doesn't write good English and tries to improve what has already been written (and altering it's meaning in the process). Doc-man's toolbox analogy works but my real tool box is organised by having...