MonkeySoft - Software


The principle of VBAid is to automate tasks based on a database schema. In this case I use MSAccess '97 or 2000. These may use tables or tables linked to another database. eg SQL Server.


Main Tasks

Database Functions

Program Gereration Functions

  • Generate a Database Data Dictionary
  • Create new empty database based on a Data Dictionary .
  • Generate VBCode to create that Database programatically.
  • Copy Data from one database to another.
  • Compare databases and report on any differences
  • Create COM Objects and collections based on each table at the touch of a button.
  • Create VB applications with full form generation that links to the COM objects or includes them in the application. The code is MSAccess 97, MSAccess 2000 and SQL Sever compatible.
  • Generate ASP Code for listing and selecting items based on each database table.


Documentation Functions

Database Schema

Provide full documentation breaking down:-


  • Using VBA in conjuction with MS Word, generate a full indexed data dictionary of a single project or a project group.
  • Project Properties.
  • Full forms breakdown listing all controls, procedures and methods.
  • A full breakdown of all object and collections listing all procedures and methods.
  • An editable section allows the recording of details for Author, description, Installation notes etc.
  • Create a Tree view structure of the database tables and fields
  • Display the properties of fields and tables.