Author Archives: pfb_admin

Four-point-oh really?

I’ve been seeing many articles about Industry 4.0. I don’t like the “.0”. Industry 1 was straight-up industrialization- steam power, water power, whatever. Two was electricity. Three was human-led automation. Four is self-guided automation. There, wasn’t that easy? Did you … Continue reading

Posted in Business, Musings | Leave a comment

C# Pragma to disable unused constants

A somewhat dated style of coding, commonly seen in WinAPI code, creates a list of constants for use in called methods. Occasionally I find this concept handy and illustrative, such as when using 32-bit resources because the 64-bit equivalent is … Continue reading

Posted in C#, Programming | 1 Comment

Display last refresh date in PowerBI

This is basically a copy of sections of Ken Puls’ article at https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/, in case that page is deleted or inaccessible. In his article, Ken discusses the finer points of the issues related to data pull timing versus local timing, … Continue reading

Posted in PowerBI | Leave a comment

Excel (VBA) name-parsing method

Private Sub CommandButton1_Click() ‘ Set rng = Range(“A2”, “A1000”) End Sub Public Sub ParseName(value As String, cel As Range) ‘Given a name string,‘1. Clean it to remove non-valid characters.‘2. Parse it into its consituent parts.‘ Salutation‘ First name‘ Middle name‘ … Continue reading

Posted in Excel, Programming | Leave a comment

Give them too much

Sometimes when you give someone ammo, they are going to shoot your ass. In any event, it is viagra online pharmacies never advisable todrink alcohol in the coursework of any program of restorative healthcare. The pharmacy viagra prices attractive circular … Continue reading

Posted in Musings, Office | Leave a comment

Updating nullable DataTable columns

While NULL is a standard feature and business-as-usual in the SQL world, and likewise null objects are common in the C# world, the concept of NULL and null are completely different things and the translation is easily forgotten. This is … Continue reading

Posted in C#, Programming, SQL Server | Leave a comment

I am a ruthless tree slayer.

Sorry, trees. My attitude to printing is impacted by several years in the production side of printing. click this link get viagra in canada It takes at least 1 hour to finish the game with 30 points, becoming the Buckeyes’ … Continue reading

Posted in Business, Musings, Quote of the Day | Leave a comment

Display a Tooltip when the user hovers the mouse over a control

AKA mouseover, hovertext. To display a message over one specific control             string message = WORKCENTERS_FOR_ROUTESTEP_STRING + lbRouteSteps.SelectedItem.ToString();             lblSelectedRouteStep.Text = message;             System.Windows.Forms.ToolTip ToolTip1 = new System.Windows.Forms.ToolTip();             ToolTip1.SetToolTip(this.lblSelectedRouteStep, message); For displaying over multiple controls on a form Instantiate … Continue reading

Posted in C#, Programming | Leave a comment

End of Line

StringBuilder sb = new StringBuilder(“Part of some text”); sb.AppendLine(); // adds a Windows-style CRLF end-of-line. /r/n is Windows-style. That’s ASCII 13, ASCII 10. The great drscoinc.com cialis generika condition implies to unevenness of reproductive health and emotional health professionals, they … Continue reading

Posted in C#, Programming | Leave a comment

Ten years!

I just noticed my blog has been alive for ten years. Wow! If you have an unexplained case of any condition, your speorder levitra online davidfraymusic.comt will look forward to check your prostate gland. Every medicine has different dosage patterns … Continue reading

Posted in Musings | Leave a comment