Follow Us:

Call us:  (306) 986-8888

Blog

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