VBA Code Writer

From within the VBA editor of IDE you can bring up a list of forms, reports or controls and filter them by typing just part of the name. Then by clicking the okay button the selected object name is pasted into the code. The same can be done for a list of tables, queries and field names. One of the options is to list all the variables in the current procedure. Another part of the functionality is to parse the SQL text from a Microsoft Access query so that it can be inserted into the VBA code editor. Also if you forget to dimention a variable then simply selected variable and then in turn select the Dimention Variable menu item to have the variable Dim statement added to the beginning of the current procedure. Note in order to have a list of controls or fields you will have to select forms of reports/tables or queries in the 1st instance.