VBAid |
|
|
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.
|
|
|
|
