Let’s say you have a column on your table named name_title that contains an employee’s name and their title separated by a comma as such: ‘John Doe, Manager’.
The LEFT method will grab everything to the left of the comma …
Microsoft Excel – Turn off error checking when entering numbers into Excel text fields
In order to turn this error checking off:
1) Click File
2) Click Options
3) Click the Formulas tab.
4) Under the Error checking rules, uncheck ‘Numbers formatted as text or preceded by an apostrophe’.
…
Facebook – Not Getting Chrome Notifications
Some documentation states to enter m.facebook.com and when the popup box comes up to allow notifications, click Allow. I have done that, and it still doesn’t work. Here is how I fixed it.
If entering m.facebook.com doesn’t bring up the
… Google Chrome – Open Dialog Box cause Chrome to Freeze or Crashes
Lately, for me, Chrome freezes immediately after opening the ‘Open Dialog Box’ when attempting to attach a file to an email or during the process of attaching the file to an email. This can happen in any web application using …
WordPress – Remove Email and URL in Comment Section, and Add Plugin to Remove Hyperlink from URL Placed in Comment Textbox
- In the Discussion Settings, uncheck the checkbox that states “Comment author must fill out name and email”.
2) Edit the function.php file in your File editor and add the three functions to the bottom of the php file shown in …
Plugins – iThemes Security – How to enable/disable the file editor (to edit WordPress php files)
With the iThemes Security plugin, there is an option to turn off the php Editor.
In the Dashboard, click Security, then Settings in the far left column.
Under WordPress Tweaks, click the Configure Settings button
Check or Uncheck the Disable …
Microsoft Visual Studio – How to Delete rdl.data Files in BIDS
An rdl.data file will be created each time when the report is viewed with different input parameters. The data file caches the data so running the report again in the IDE with no changes to the parameter data will render …
Windows 10: Windows Update Error or Loop
First Try This:
Start Command Prompt as administrator.
Enter the following commands
- net stop wuauserv
- net stop cryptSvc
- net stop bits
- net stop msiserver
- ren C:\Windows\SoftwareDistribution SoftwareDistribution.old
- ren C:\Windows\System32\catroot2 Catroot2.old
- net start wuauserv
- net start cryptSvc
- net start bits
- net
Microsoft Visual Studio – Debugging doesn’t start
There have been many suggestions to get this working. I will give you three that worked for me in the order they should be tried.
- Restart your computer. Some of the projects files run in the background. Stop them if
SQL Server Reporting Services (SSRS) – How to Hide Columns When Exporting to CSV
You can suppress elements that you don’t want to include in a CSV export by doing the following:
- Click an element.
- In the properties windows, Choose “NoOutput” in the DataElement Output property.