Archive for the 'SQL' Category
Thursday, June 5th, 2014
A comprehensive application to manage generation of RMAs (Returned Materials Authority), the receiving of damaged/failed meters into the warehouse, repairs and refurbishment in the workshop and despatching meters back to customers. The client had a very basic in-house developed application to record the repairs and refurbishment aspect using TCL running on PostgreSQL. The project covered […]
Posted in Delphi, SQL, Subversion, Windows | Comments Off on SARMA – Secure Australasia Returns Management Application
Thursday, June 14th, 2012
This was a project more about data manipulation than software development. A local real estate agent was using a commercial application for tracking rental lease payments and had a separate home brewed Access database for managing late payers, task checklists and history of maintenance performed on a property. They also had a few other spreadsheets around the […]
Posted in Access, Office, SQL, Visual Basic for Applications, Windows | No Comments »
Monday, April 16th, 2012
Fraser’s Livestock Transport operate in the remote regions of western Queensland where there are no maps. Each customer might have several pick-up or delivery locations on a property. They had an Excel spreadsheet with customer name, property/location name, and text directions of how to get there. Built up over the years it was getting a […]
Posted in Access, Office, SQL, Subversion, Visual Basic for Applications, Windows | No Comments »
Sunday, May 14th, 2006
Mallet’s Occupational Health and Safety forms was an ambitious project for a small company of heavy machinery operators. They wanted to automate all their paper work. Each machine needed daily inspection with a couple of pages of checklists to be filled in. While that wasn’t too difficult, collecting and filing them before they got lost […]
Posted in Delphi, Office, Pascal, SQL, Windows | No Comments »
Monday, July 13th, 1998
E.A.T.S. was initially developed for a steel fabrication company to streamline their job estimating process and produce quotations ready to send to the customer. The costs of resources used in the manufacturing process are recorded so that the accuracy of estimations can be tracked. It also interfaces with the Mind Your Own Business (M.Y.O.B.) accounting […]
Posted in Access, Office, SQL, Visual Basic for Applications, Windows | No Comments »
Friday, January 13th, 1995
This was a low-cost development for a very budget conscious, computer literate client. Digressoft did the initial database design in Access and discussed the user interface design with the client who then did most of the work to put together the system. We then came back and did the tidy up work and the tricky […]
Posted in Office, SQL, Visual Basic for Applications, Windows | No Comments »
Monday, January 1st, 1990
After 5 years working as an Analyst/C Programmer for Pancom Systems Pty Ltd. I have decided it is time to move onto something more physical. In that time projects included: Development of a cashbook accounting system to run under both CPM and PC-DOS. Modification of an existing client/product management application and underlying database management system […]
Posted in Assembler, C, MS DOS, SQL | No Comments »