If you want to delete all or some of the tables from your Access database, you can use this DAO approach. You would need a reference to Microsoft DAO 3.x object library. As shown in the example, you can use an array to store the table names, which you want to keep or delete. Sub […]
Continue readingIf you would like to link all Dbase files, any linkable file for that matter, in MS Access, use the following code. I read somewhere that refreshing the links is slower than deleting and creating new links. Sub LinkAllTblsinDir() Dim sTblNm As String, sPath As String, sFileNm As String sPath = “C:\DW\” ‘Turn of the […]
Continue readingCreating scatter plots in Microsoft Access is a challenging problem. Follow these steps to create your own scatter plot: Under forms tab, click New On the New form window select Chart Wizard and Select the table, which has your data, hit OK On the next screen, add two fields for which you want to plot […]
Continue reading