Follow Us:

Call us:  (306) 986-8888

Blog

This last 10 days has been interesting.  On Sunday September 4th a business  I know of (NOT a client until AFTER this attack) was hit by the new CRYSIS ARENA virus.  I was called in by management once their IT support told them they had been hit and bitcoins would be needed.  The fact bitcoins became involved was an immediate flag something was bad. The criminals...

Read More

The Wannacry cryptovirus is causing global problems.  As of Sunday, May 14, the virus has spread to well over 100,000 systems in over 100 countries.  Version 2 is supposedly making the rounds now, the total effect of this virus is not yet known.  This virus attacks unpatched systems running Windows Server 2008 or older on an SMB exploit that was patched in March 2017.  The NSA...

Read More

If you ever come across a scenario where you want to sign the user out of the computer upon exiting Access database, then this guide will help you! In our scenario, a client has a remote server where the database launches upon login, and we want them to be logged off upon exit, to result in no access to the server itself. Here are the steps: You...

Read More

With over 90% of fortune 500 companies already on board Microsoft Cloud, digital transformation and specifically Microsoft Azure are bound to take 2017 by storm. Digital Transformation Firstly, what is a digital transformation? Well the most typical of definitions is: the application of digital technologies to fundamentally impact all aspects of business and society. Every company has used digital transformation in a way, if you say you haven't, you...

Read More

NZ(me.thisfieldhasnovalue,"Evaluating Nulls") Using NZ does ONE evaluation step which gets the data you requested from a field or formula (if it is NOT null), otherwise it will pass in a new value to use in it's place so the formula or expression does not break due to a NULL.  This is required in a lot of scenarios due to the fact you can not evaluate "nothing" to...

Read More

In creating a new report I needed a SQL View for an Access report on quarterly results.  The resulting code is actually quite simple, and because I use a view the report is very quick on a large set of data. SELECT     TOP (100) PERCENT COUNT(TrackNum) AS Tracks, YEAR(StatusDate) AS year, { fn QUARTER(StatusDate) } AS quarter, StatusCode FROM         dbo.StatusHistory GROUP BY YEAR(StatusDate), { fn QUARTER(StatusDate) }, StatusCode ORDER...

Read More

This code allows you to use a multi-select list box   list box with multiple options) instead of a combo box on a search form front end to a query or table.  It  loops through the selected values and builds a string called "criteria" with the selected values all in it as " OR " options.   The example result would look like "("OPEN" or "CLOSED" or "IN PROGRESS") Then it...

Read More