Visual Studio Code Open Folder
How to open an Angular Application inside of Visual Studio Code
After you've created a new Angular app (click the link to the left to learn how), you will need to open it up in a text editor to be able to change and add things to it.  For this, I recommend Visual Studio Code.  It's a...
Introduction to Excel PowerPivot Webinar
In this free Excel PowerPivot webinar, Excel Instructor Seth Bonder explains how to add PowerPivot functionality into Excel, how to create a data model and much more. To learn more about PowerPivot, or to enroll in one of our PowerPivot classes, please visit our Excel PowerPivot...
Create new angular app
How to create a new Angular Application
This post will talk about how to create a new Angular Application using the Angular CLI (command-line interface).  If you don't have the Angular CLI or Node installed yet, be sure to check out how to do that here. Once we have Node and the Angular...
How to Build an Error Handler in Access VBA
Dealing with errors in VBA code, especially in Access, is a vital part of setting up procedures. If nothing else, an error-handler can give the user a better idea of what’s glitching, if something does. And having a message box come up to give the user...
Angular CLI Version
How to download and install the Angular Command Line Interface (CLI)
Angular is becoming a very popular JavaScript framework that allows you to create single-page applications (SPAs).  It's backed/created by Google and it's not too hard to get an app up and running.  This post will discuss what you need to install and what you need to...
Free Webinar: Introduction to Angular
https://youtu.be/dwHe1aDR6Nc
How to Add a Calculated Field to an MS Access Query
Calculated fields are a really big help in Access; they let us derive data from existing information. And they’re flexible, too. If one of the source items changes, the calculation updates immediately, just like an Excel formula. But some people aren’t aware you can add them...
html tooltip
How to create a tooltip using only HTML
Sometimes websites aren't very specific.  You see something on the page but have no idea what to do with it or what it's for.  Enter tooltips!  They are helpful little windows that pop up to explain what something is on a webpage.  They usually show up...
How to Create a Watermark in Photoshop
Creating a watermark, whether for use in company stationery, or websites, or wherever, has become fairly important recently. It’s part of what is known as product branding. I won’t go into the discussion of designing logos, as it’s a very involved process. But many companies want...
developer console debug
How to use the console to debug in JavaScript
JavaScript is a great language.  It allows you to add all kinds of interactivity into your webpages.  However, sooner or later, we will make mistakes in our code.  The good thing is Chrome and FireFox both have JavaScript debuggers built into them so finding the general...
How to (Better) Convert to Grayscale in Photoshop
When we convert a color image to grayscale in Photoshop, we  obviously toss out color. But sometimes this makes the image look a little flat. Color can make an image look vivid, and not just because color is there. It also allows subtle contrasts, enhancements, and...
full screen background CSS
How to create a full screen background
In this post, we'll talk about how to create a full-screen background using CSS and HTML.  We are going to bypass all the CSS properties that exist for backgrounds to do this, so consider this a type of CSS hack (:  What we are going to...
How to Use the Organizer in Microsoft Project
The Organizer is one of the lesser-known features in Project. And it’s a shame that this one is overlooked. It can be a major help in both building templates and making already-built elements easily available. One common example is calendars. If you build a company calendar,...
redirect page with only HTML
How to redirect a HTML page
Sometimes in the web design world, you'll need to redirect a page.  Maybe it's because the page no longer exists, the page has been updated and moved, or it could be a page that you don't want the user to be on for very long.  There...
Using the ISNULL Function in Crystal Reports
The IsNull function in Crystal allows us to deal efficiently with nulls, or empty fields, in a data source. I talked about this in an earlier post. We don’t want to skip partly empty records, in most cases. But if we bring in nulls, we have...
for vs for in loops
For of vs For in JavaScript Loops
In JavaScript there are two kinds of for loops: for of and for in.  The difference can be seen when looping through arrays.  Let's take this array for example: var greetings = ["Hi","Hey","Hello"] It's just a normal array with three strings (words) in it called greetings. ...
How to Work with Nulls in Crystal Reports
Crystal Reports handles nulls, or completely unfilled fields, in a particular way. And it’s very important that anyone using the program understands the details clearly. A null, in Crystal’s view, is a database field which never had anything in it, and doesn’t now. A real-life example...
loop through object javascript
How To Loop Through An Object In JavaScript
In JavaScript there's a way to access all the items in an object called the for in loop.  It allows you to iterate (or loop) through all the key value pairs in an object.  For example, if we had this object: var jsobj = { company:...
Using Bitmap Mode in Photoshop with Text
Someone had a question about working with text in Photoshop using Bitmap mode. “Between 50% threshold, pattern dither, diffusion dither and halftone screen, which one is more suitable for text use?” This is the image mode which converts to strictly black-and-white pixels. We want to be...
stop loop from nested
How to stop a loop from inside a nested loop
There are times in JavaScript when we'll have a loop inside of another loop and we'll want to stop the outer most loop from inside the inner one.  Here is a block of code that is showing what I'm talking about: var i = 0; while(i...