by Carl Connett | Aug 4, 2009 | Arrays, Collections, DAO, Databases, Forms, Macros, Microsoft Access, Modules, Queries, Reports, Tables, VBA
This VBA function copies or imports all the objects and database startup properties from a Microsoft Access replicated database into an un-replicated database. It removes tablename_Conflict tables and removes replication-related fields like s_GUID, etc. Background:...
by Carl Connett | Jul 7, 2009 | Automation, Microsoft Access, Microsoft Excel, PivotTables, VBA
This function uses a combination of Microsoft Access, VBA, and Microsoft Excel to transfer the values from an Access form in PivotTable view to the clipboard. It is a good example of automation using late binding. The Challenge My goal was to automate the process...
by Carl Connett | Jun 12, 2009 | Automation, Microsoft Access, Microsoft Word, String Functions, VBA
This VBA function opens/gets a MS Word document and finds the next occurrence of a specific string. The function provides a good example of using late binding automation and the AppActivate() function. One advantage of late binding (using generic objects, like objWd...