Follow Us:

Call us:  (306) 986-8888

October 2017

I am often asked "Is Microsoft Access going to be here in 5 years?".  Here is a quick synopsis of what I think is the best answer to that question: Microsoft continues to release enhancements and product improvements for Access 2016.  example:  new connectors were released this year showing a powerful interest in tying Access to Salesforce and other 3rd party software and offerings. Companies continue to...

Read More

When I see bad data in a database, there are several things you need to look at to improve the outcomes of your reports.  In general this is all going to fall under GIGO:  Garbage IN, Garbage OUT.  Cliche, but TRUE!  Here are my top 5 tips to help control your data quality: Watch out for NULLS, which tend to break reports and formulas.  Use...

Read More

While not automatic, this is how I do version tracking: Create a local table called TblLocalRevision: Make the RevisionNum and RevNotes fields set to Append Only  -  YES: Enter data in the table to create ONE row only - with ID 1. Enter data in Version nuber ex. 2.3   and notes ex.: Added a logo to the menu and added new sales report. Show the current version number in your...

Read More

Some of our clients are now moving into Touch Screen devices.  There has been a common request for Access development optimized for tablet running Windows 10.  Here are the key changes you need: A windows OS tablet (Panasonic Toughbook or Acer, or other tablet) .  We did testing on non-ruggedized devices, but out clients like rugged options. Modify a registry key to make scroll bars wider so...

Read More