Search results

And the irony of NEW low code tools is that their ultimate goal is to allow ANYBODY with a desktop computer to create their own database but now on the WEB. Most must wish they can get as popular as Access IT departments are likely to have the same problem but quite possibly on a bigger scale.

There's a lot of advantages to living in the UK and the USA - I often wonder whether our own self-criticism and anxiety holds us back (and a problem in all other countries)

I might be tempted to have a field in the database just to record email sent date... as well

I know its ages since we spoke about this but I came across a discussion about pairing in a stack overflow discussion directly relevant to the above. How do you constrain a database so there are only unique pairs in a database table? If Kirk is friends with Victoria if we store that as a...

Quite possibly my ignorance I have never done anything but development by myself and then really only in two platforms.

That to me seems to be an optimal way of supporting citizen developers, improving security while taking advantage of MS Access's flexibility.

I see IT departments disliking MS Access applications often but consider this an illogical argument. What they actually dislike is the fact that there is only a single developer and they don't know how the business logic works. So if that single developer goes no one knows how to fix or adjust...

I have answered questions but I m often unsatisfied with my own answers. I often make the effort purely because I think I learn as much from answering as asking. I do accept that if I am going to ask a question I should if possible create a worked example of the starting point and the target end...

Don't think its practical but wow a starship I think one day - probably not in our lifetimes but maybe in our descendents - it will be a thing... I certainly wouldn't really want to go on a startship unless there was somewhere nice to go... but it might be the step before there is somewhere to go.

It certainly wasn't obvious to me initially but the benefit of trying to solve other peoples coding problems is often felt more by the improved understanding of the person answering the question rather than the person receiving the answer. This is why I think teachers get so good.

I'm hoping that by the time I get round to buying an electric car- range will be 1500 miles and you'll be able to get all your power from solar and there'll be solid state batteries. I've got a feeling its just a case of when... I'm hoping for stellar improvement in the efficiency of solar as...

Big congratulations - My wife asked me a couple of times - "But why did you choose to go to that particular consultancy?" I said - "They've got a couple of MVPs" She said - "What does that mean?" I said - "They know what they're talking about"

I would probably choose the same if I had the same task.

I should say that with my naming conventrion the number part is only a prefix a textual word description comes after my prefix... so for example t001users - anyway only personal preference. I do have to write queries against a massive oracle database at work and it can be really difficult to...

Its a great project and I even come across Northwind in SQL Server examples - Naming convention seems perfectly fine to me.. One thing which seems quite personal to me which might be of interest- I usually prefix my table descriptions with incremental reference t001 t002 etc.... going forward...

So I have started implementing this specifically for my case which is for a whisky distillery splitting whisky into bottles. As a first step I went through Arnel's and CJs code and just made sure I understood it. I just thought I would document it here so others can follow more easily as well as...

Hi guys I've actually updated some details on PHPRunner which is a personal favourite web application code generator that I use. Its basically MS Access for the web - a CRUD Web application Creation tool that connects to MySQL / Oracle / MS Access / Postgres and SQL Server. I've used it against...

I think we might be going round in circles here. You could argue that a 1-1 relationship is the most common relationship and is the core of what a tuple is defined as. We just rarely model it specifically because it is covered by putting all the attributes in the same table and therefore...

Big thanks guys right on the money.

I think the best position is to try and give something back if at all possible. Even for open source... At the end of the day if it adds value for you the value should be proporational to the value you get from it... Yes we are often forced into situations especially in markets that lack...