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 14, 2015 | DataOne News
DataOne is pleased to announce the launch of our new website which represents the excitement and energy with which we help our clients and meet their unique needs. With over 17 years of service to our valued clients, we look forward to many more years of nurturing...
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...
