GetObject Archives - Extra Mile Data

Remove replication from a MS Access database

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

Use VBA to copy MS Access PivotTable values to the clipboard

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

Use a VBA function to open/get a Microsoft Word document and Find a string

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

Remove replication from a MS Access database

Use VBA to copy MS Access PivotTable values to the clipboard

Use a VBA function to open/get a Microsoft Word document and Find a string

Notes

Categories