VBA-SQL Tool for testing SQL
Shared by: exx10251
Notes on the VBA-SQL Tool for testing SQL If you are using Access 2007 (not Access 2003) you may need these extra steps: The initial screen includes a security message – click ‘Options’ and select ‘Enable Content’. Then click on the ‘Add-Ins’ tab to get the correct screen layout: Whichever version you are using: 1. Click ‘Table list’ and choose table to display data – any SQL entered acts on these 2. Type SQL into top pane. When semi-colon is entered it is entered (or the Execute SQL button is clicked), the results are shown in bottom pane: 3. Click on ‘Previous SQL’ to list previous statements so you can run one again (or correct it and run it again!). 4. Click the Clear SQL button to clear the top pane. 5. Click the Clear Results button to clear the bottom pane.