News

Updates, Tips and News from DataOne

VBA Tip: Speed Bump

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...

Greetings and Salutations!

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...

MS Access / VBA Tip

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...

Another great MS Access Tip from DataOne

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...