Avoid using References in Access VBA

When I investigated the problem opening the same database in Access 2010 and Access 2013 / 2016  that breaks the DB I came to the conclusion that this is originated by a bug in Access that doesn’t allow the DB to use references to other office applications (in your case Outlook) when downgrading the version. …

VBA Project Conversion to 64-Bit

Synopsis This document describes the steps to convert a typical VBA project from 32-bit to 64-bit. This document is a work in progress and is derived from experience in Excel VBA projects, but should be applicable to Access, etc. Applicable Cases For the most part, written VBA in 32-bit is identical to 64-bit. There are …

Two VLOOKUPS Are Better Than One

You’ll Never Look At Excel The Same Once You See This Tip! Hi there! Ever have to use VLOOKUP to match data on one spreadsheet to another? If you have more than, 50,000 records in either spreadsheet, it’s probably going to be slow. Painfully slow if you have 200,000 or more records! What if I …

UPC Generator Version 2 PL/SQL

With this function to replace the old UPC Generator query we expect to solve the conflicts when multiple users are obtaining DUMMYs UPCS. Use: select F_GET_DUMMY_UPC() from dual; Source Code: create or replace function F_GET_DUMMY_UPC return varchar2 is   UPC varchar2(20);   RESULT varchar2(20);   UPCCount number; begin   WHILE 1=1   LOOP     UPC := …