Visual Basic and Access Database Programmer
  Neville
Silverman

Visual Basic Programmer, Sydney
Microsoft Access Database Programmer

Custom Built Software
System Optimisation
Office Automation
Website SEO
Phone me with your Visual Basic programming queries Phone Australia
(02) 9453-0456

Client Project: Fujitsu Australia Ltd

Visual Basic and VBA Client ProjectsFujitsu Australia has a division that supplies administration systems to Local Governments.

A Client/Server version has been developed using a modified Legacy system at the Back-End, the Client being written in Visual Basic.

Programming Project Period:

December 1999 to December 2000

Programming Job Description:

Enhancing an administration system for Local Governments

Visual Basic Software:

The system is data driven, and all Menu Items and MDI child Forms are created "on the fly". The rules are defined in a Microsoft Access database. Any new application can be added at will. The Microsoft Visual Basic programming involved the complexities of applying the database Rules, handling dynamic Form creation, and Meta data used to create the transitory objects.

VB Programming Duties:
  • Support of the Client side of the large and complex (about 10 person years of work and a few hundred thousand lines of code) Local Government project for Warringah Council.
  • Providing bug-free and stable systems.
  • Attending to Client bug and enhancement requests.
  • Conversion of DAO Jet Engine to ADO database access objects.
  • Conversion of the system to Component Object Modules (COM) to reduce maintenance overhead.
  • Allow third party access to the system.
  • Consultancy for Fujitsu in their attempt to become autonomous.
  • Ongoing software support for individual projects.
Programming Achievements:
  • Set up a completely new environment to handle the Networking requirements, the Microsoft Visual Basic environment and the Middle-ware for the Client GUI system – including the Unix Server and databases.
  • Produced a stable system.
  • Eliminated of all high priority errors in the Microsoft Visual Basic programs and created a stable system.
  • Reduced program response times by over 70%.
  • Changed thousands of lines of code in implementing consistency and programming standards.
  • Built an open ended ActiveX control to allow all Forms to be converted to controls. The first of these handled Logins, Printer selection, and Screen Printing.
  • Created an open ended DLL to provide Error handling, Server access, Transaction creation, rule definitions, printing, etc.
  • Produced an asynchronous .EXE to play sounds, FTP printing, Server access – without impacting on the Client.
  • Created a "User Exit" interface to allow independent third party access to the records on the Server, and provide access to Microsoft Word and Microsoft Excel.