VBA Code Writer for Access 2000/2002/2003 Version 1.02 (COM Add-In)
Functions:
1. Create code for Message Boxes through a user interface. Written by Mark Phillipson Screen Sample
2. The SQL parsing tool converts unformatted SQL, such as that generated by the MS Access QBE to one of three forms:
a) VBA Embedded SQL
b) Access SQL Syntax
c) SQL Server Syntax
Written by DataFast Utilities (datafast@home.com) Screen Sample
3. Create VBA code to walk a recordset using ADO or DAO.
Just insert into a procedure.
Loop and edit, delete or set variables (with or without Progress Meter) or Add New
Written by M Phillipson Screen Sample
How to Install
Using: After installation when you are in the VBE (Visual Basic Editor), select Tools>VBA Code Writer.
*NEW* Dimension variables. Also with this COM Add-In select a variable in code that needs to be declared and select Tools>Dimension Variable. The variable will then be declared as per the table below. The declaration will appear at the top of the current procedure. Then continue to write code without having to move to the top and back down again.
| First 3 Characters | Data Type |
| str | String |
| lng | Long |
| int | Integer |
| dbl | Double |
| bln | Boolean |
| var | Variant |
| sng | Single |
| obj | Object |
| frm | Access.Form |
| rpt | Access.Report |
| cur | Currency |
| dte | Date |
| cmn | ADODB.Command |
| rst | DAO.RecordSet |
| Whole Variable | |
| k, l, m or i | Integer |
| rs | DAO.Recordset |
| r | ADODB.RecordSet |
| db | DAO.Database |