Simple Software - Microsoft Access
|
|
Simple Software - Microsoft Access |
|
Crosstab Missing Values - SQL solution with no missing values to replace the MS Access CROSSTAB query Find and Replace for MSAccess queries - Ever needed to duplicate a group of MS Access queries and then change a key piece of data in each one? Use this VBA code to do it MS Access COALESCE Function - The functionality of the SQL Server COALESCE function in MS Access MySQL IsNull Function - When you are translating MSAccess JET SQL into MySQL syntax this function saves a translation to IFNULL MSAccess Not In List Event - Simple VBA code for remembering text typed into a combo box VBA Date Format 1st 2nd 3rd - VBA create the date format for the st part of 1st SQL Server MS Access VBA ISO Date Function - Useful when converting an MS Access to SQL Server Microsoft Access security groups and users output as a table - Useful when converting an MS Access database to Access 2010 Replacing the Calendar Control in Access 2010 Applications - Useful when converting an MS Access database to Access 2010 Set Tool Tip from VBA in Access 2010 Applications - Use when debugging Access runtime applications MS Access Query Search - Use when searching for obsolete function calls in query source Application.CompactRepair - Compact and Repair an Access database from VBA VBA Code to search all textboxes in an Access 2010 database - Useful when converting an Access database to Access 2010 VBA Code to log errors to a text file in an Access 2010 database VBA function to copy tables to an empty database to remove Access security - Use when converting to Access 2010 as security is not supported Filter on Empty Master - This new property of subforms causes forms to fail to display DAO Update - Code to update fields in an Access table or query A tree grows in BASIC - A piece of programming history Parse XML - VBA function to parse an XML element from a string Northwind 2010 - The original Access sample database converted to Access 2010 Web Service in Access 2010 - Using the weather.gov web service from Access 2010 VBA Code to load a tab delimited file to a MS Access table VBA Code to load a delimited file to a MS Access table Adventure Works on Access Pretty Print VBA MS Access VBA code to find and replace values in a Word document Read MS Access lockfile in Excel VBA Form Generator for Microsoft Access 2013 Function to Refresh Table Links in MS Access VBA Add subtotals to an Excel export using MS Access VBA Make DDL - Generate DDL statements for source control in MS Access 365 Care and maintenance of MS Access databases Northwind 365 - The original Access sample database converted to Access 365 |