=StrConv("JOHN DOE", vbProperCase)
This now becomes John Doe… Read the rest
James Software Development Corner
Helping Others with Software Development and Windows Operating Issues
=StrConv("JOHN DOE", vbProperCase)
This now becomes John Doe… Read the rest
If your sql server is installed with the default collation of case-insensitive, you can accomplish this in sql instead.
You can determine if your installation collation is case-insensitive by running this query:
SELECT SERVERPROPERTY ('Collation') GO
If the result is … Read the rest
In order to do alternate row coloring for an SSRS report that has grouping, you need an expression for your BackgroundColor property different than the typical:
=iif(rownumber (nothing) mod 2 = 0, "LightGrey", "White")
You can use the following expression … Read the rest
Let’s say you have a column in a table that is comma delimited. The value in the column is ‘APPLE, ORANGE, GRAPE’. You want to break down this string value into individual rows. You may also want to create an … Read the rest
In Regedit:
HKEY_CURRENT_USERSoftwareMicrosoftBinary Fortress SoftwareFileSeek
Remove all the data inside the Multi-String values that start with LastUsed.