by James Pilcher | Feb 15, 2015 | VBA
Common wisdom tells the serious Access developer that using subdatasheets will slow his application. In particular, the automatic subdatasheets cause the biggest slowdown. Here I’ve written some code that you can drop into any Access database and become the hero that...
by James Pilcher | Feb 3, 2015 | VBA
Access Subform Observations Just a quick note based upon some observations I made this past month: Access subforms are loaded before the Form_Load event on the main form. Linked subforms are synchronized with the main form before the Form_Current event fires on the...
by James Pilcher | Jan 31, 2015 | VBA
Cascading updates in Jet relations Jet, your default database engine for Access, offers an option to turn on cascading updates when creating a relation object, often referred to as a relationship during database discussions. On first blush, this can seem like a good...
