Search results

IMO, don't save the composite assembled FullAddress in the table. Only store raw data. It is an unforced error to design a table knowing that data in a single row could ever be in conflict with itself. Do you drive without a seat-belt, or paddle without a PFD? • No. It's not safe. • Anything...

Good code expresses intent. In expressing your intent, whether you want to... • do something, or • get something ...is a critical distinction.

Don't do it. Ask your AI about the data principle SSoT. You should never design and use a data structure in which a single data point, like a date, is split into component parts that co-exist with the single source they were split from. This invites the unforced error that your stored data is...

Wow, nice work!!!

If a form exposes two lists, one of which may be considered 'Active' based on its visibility state, then on that form I'd do... Public Property Get ActiveList() As Access.ListBox If Me.List0.Visible Then Set ActiveList = Me.List0 Else Set ActiveList = Me.List2 End If...

But how do you escape in your own mind the logical conclusion that if war makes us all stronger, psychologically, emotionally, spiritually, that you are not promoting it? I suggest that if you fail to actively and vigorously oppose war, then you are a tacit supporter, because war is a creature...

Are you f%$&ing serious? In order to make our people feel closer to God, let's subject some random subset of them to abject horror and violent death? Let's destroy their homes, kill their neighbours, and thereby 'force them to be stronger,' and 'make the church bloom?' War is hell. War destroys...

Exactly. And so why do we believe what we do? I worked at a homeless shelter for a while, and I had to get a criminal record check, so I went to the police station. There was a woman there, processing my request, and she told me, "Those people choose to be there you know." That was her belief...

If I bother to look, I can find videos supporting anything, and if I only cite the ones I prefer to agree with, then I am a science cherry picker.

Describe more exactly where you are stuck in accomplishing that task.

Table design should be determined by what fields belong to the object the table represents, not how frequently those fields are used. If you have a table tShip that stores data about ships in your navy, and maybe that table has a field called "ReactorMegawatts." And maybe your navy has 1000...

It doesn't seem like a problem to me to iterate over items in a list and deal with each one individually. I have not studied your problem, but I would avoid a crosstab and deal directly with the raw data. A crosstab is slower to generate, requires two loops, and the fields are drawn from the...

Let me play devil's advocate for a minute. If you live in a society that is obviously exceedingly wealthy and you yourself want for nothing, and you understand that in life there is no assurance at the time of your birth that your needs will be fulfilled. The universe owes you nothing. You...

If you believe the sun is at the centre of the solar system, but you don't believe anthropogenic climate change is real, then you are a science cherry picker, trusting what scientists tell you in one domain, and not trusting what you are told in another. If you stand out in your backyard and...

No, if a group is cohesive, coherent, and pursues noble ideals, it cannot be assimilated. Consider the example of the history of the Jewish people. A group can only be assimilated as a result of its own internal moral decay. If you fear assimilation, renew your commitment to the ideals of...

My dad's generation was destroyed by war. He could hear the British bombers at night staging over Amsterdam. He could hear the occupying army, who for effect attached steel plates to their boots, marching the cobblestone streets. • It is a measure of the relative peace, stability, and luxury...

We really would be better off if there were unicorns and leprechauns. I think it's hard to calculate the costs and payoffs of social media. One interesting and not well advertised side-effect of social media is that people forming relationships now, and having children, almost 90% of the time...

Tip: you can run Compile from the keyboard (and Comment and Uncomment block). • Put your IDE menus into design view • Drop a toolbar command onto the main menu • Customize the name to include an ampersand (&) character preceding the key you want as a short-cut • Return menus to normal • Hit...

Trump promised winning, so much winning. We were going to get tired of winning, remember? If you don't agree he has under-delivered, then talk to your doctor. You might be suffering from "Lowering The Bar Derangement Syndrome."

Bill Gates predicts no one will need more than 640K.