Blog

Microsoft Azure – Digital Transformation

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…

Read More

Integrating Excel Data From SharePoint To Access

Need to link a file in Sharepoint to Access for on-going importing...It's not as easy as it sounds! If you want to link Sharepoint files to Access for on-going automatic updates, this nugget of code will do it! enjoy! Private Sub Command0_Click() Dim blnHasFieldNames As Boolean, blnEXCEL As Boolean, blnReadOnly…

Read More

The Use NZ For Access And Null Values

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…

Read More

Grouping Data By Calendar Quarter

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…

Read More

SQL Partitioning Used For Views To Drive Access

This week brought in some challenging tasks required from SQL partitioning...creating a view which mimics a GroupBy in Access. In SQL, you use PARTITION to get a similar result set to a Group By query.  It will look something like this: SELECT        * FROM        (SELECT  *, ROW_NUMBER() OVER (PARTITION BY…

Read More

Making A List Box With Multiple Options

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 "…

Read More

Enjoy A Freshbooks Discount!

Enjoy a 15% Freshbooks discount by beginning your free 30-day trial through the link provided below: https://rct.freshbooks.com/refer Put in your “Company Name”, your “Email Address” and click the green button that says “Accept Jeff’s Invite”. This will start the account with a 30 day free trial and it will automatically provide the 15% discount…

Read More

It’s Friday, How About Something Fun!

How about something not so business related today, being it's a Friday? This brings back good memories of days well spent playing on my Apple IIe, and my first PC with a 5 MB Hard drive the size of a telephone book, and a new 8088 processor.  We eventually upgraded…

Read More

Record Locking Problems?

Over the last few years I've run into many customers with record locking issues.  Given the scenario of a shared multi-user database with the backend stored in SQL or another Access database, you risk two users simultaneously editing the same record.  You may have a form which presents a list…

Read More

Freshbooks Boot Camp!

Join us Friday Dec 11th at 9:00 am for a Freshbooks boot camp!  Bring your tax numbers, logo, sample clients, and email address - we will help you get setup and running as a professional user of Freshbooks!  Save time and money managing your receivables and invoicing, track time better,…

Read More

Freshbooks In The Globe And Mail

A great article written by Mike McDerment, CEO of Freshbooks, on the Canadian census and importance of data collection and timing intervals.  An excellent read! http://www.theglobeandmail.com/report-on-business/rob-commentary/canadas-new-census-needs-to-capture-nuances-of-fast-evolving-economy/article27406838/. You rock, Mike! Contact us for your Freshbooks needs today.

Read More

Sendkeys

Oh Sendkeys! Last week we ran into a problem whereby a form we want to open automatically has a bad habit of asking for confirmation due to an embedded webpage active-x object which uses cached credentials.  After many hours trying to find a command line option or other work around,…

Read More

Control Tip Text! Don’t Forget it!

We've spent a great number of years building exceptionally diverse databases.  A common request from customers is to provide support and manuals.  This week, we were reviewing one new database and I noted that as a company we are finally starting to standardize our database front ends. In particular, we have…

Read More

Access Report Automation

RCT is pleased to announce we are now selling a Microsoft Access Report Automation tool, that is managed and runs in the Access environment.  You can schedule any report you want to run, as often as you want. The reports convert to PDF's and deliver to recipients you pre-authorize in the database.  If…

Read More

Working With Time In Access

This last week I ran into a couple of scenarios where time is being tracked...in particular it's employee shift times.  The client uses a 24 hr system, and needs to capture shift start and end times.  The problem is employees enter times without leading zeroes, or get confused as to…

Read More

SQL Tips for Microsoft Access VBA

I find myself writing more and more code in VBA to handle SQL updates and inserts lately.  A great tip for doing this is to create a query in Access first, change it to an update or append query as needed, then switch it to SQL view....voila!  You have the…

Read More

Access Queries vs SQL Views.

Lately I find myself revisiting a lot of my databases to change Access queries to SQL views.  Then question has to pose itself...is it worth it? If you don't already know it, SQL runs server side and is much faster and better back end to Microsoft Access.  It can process…

Read More

Office 2016, what’s new?

With Office 2016 being released last week, it’s good to take a closer look at what is new in this year’s release that can benefit your team! Sharing, sharing, and more sharing. It has never been easier to share documents and collaborate on a project when not even on the…

Read More

RCT Now has two Freshbook Certified Consultants!

This past week Jeff and I have completed the appropriate training to become Freshbooks Certified Consultants! What is Freshbooks and what does this mean for you? Freshbooks is cloud accounting software focused towards small businesses and contractors. They make it extremely easy to manage the financial part of day to…

Read More

RCT Launched

Rivercity Technology Services has officially launched. What better way to start the new year than with a new company, new lifestyle in the country, and a passion for all things IT. In 2014 I realized that doing a full time job teaching at a college, while consulting with private clients,…

Read More