Email Your Question

5459 Elizabeth Lk. Rd
Waterford, MI 48327


Wes Wilson President


ERW Custom Programming, Inc. BBB Business Review

FoxPro and Visual FoxPro Programmers Wanted

The Future of Visual FoxPro - A Video

Since 1981

(248) 683-4182          


Partial Project List


Program Description

Major Features/Benefits

Language and OS

Attorney, Social Security

Tracks client information and associated case information

Many sub forms and lookup tables. The biggest feature is that it does a lot of automation with Microsoft Word forms (templates already sitting on users' drives - fills in data from database). Is helping them move in a paperless direction.

MS Access front end; MS SQL Server 2000 backend; runs on Windows workstations and Windows server

Construction and maintenance of Air Ports, Commercial complex buildings

Nationwide, Internet based program used by 1200 people. Micro-level details of Project Forecasting. Scheduling and Calendaring the employees work. Greatly helpful for Human resource management

Intensive Reporting, Charting on Project Forecasting. Forecast Vs Actual comparison. Automatic Data Import procedures. Automatic Updates to the Client machines. Automatic Forecasting based on History data. Automatic Emailing to employees with their work schedules. Easy expandability. Saving lot of Project Manager’s and higher officials time and also provided JIT status on any project for Project Manager, Branch Manager, District Manager, and Regional Manager and to anybody. Access to the level of information is controlled by Securities assigned to the user

Visual Basic 6.0, Crystal Reports 8.5, SQL Server 2000, MS Automation. Runs on Win98, ME, 2000 and XP

Customer Service System

Customer Service department uses this system to track and respond to Customer Problems and Warranty related issues

Allows the user to quickly enter Customer  information.   Allows the user to narrow down the complaint to a specific part and ship the correct part/s based on the Customers Complaint.  Automatically generates Packing Slips for the shipping department, Track the warranty claim and track the quality of components being produced.  Allows the user to track customer feedback through a questionnaire system.   Allows the user to file reports based on failed components for further evaluation by the quality control department

Visual FoxPro 7.0

Event Management

Management System for conducting horse shows.  Including scheduling, payments, and judges results

Allows networking multiple wireless laptops to decrease setting up events at the show

Visual FoxPro 8.0

Gas Storage

Tracks daily well readings along with field storage facilities.

Allows entering well reading in blocks of 7 day periods of time using MS Excel that writes the data back to SQL Server.  Edit checking done at MS Excel cell level by a program written by ERW

Visual FoxPro 8.0, Office Automation, SQL Server

Health related products,  Networked Customers

Greatly helpful for daily business operations. Will allow the accurate Commission/Referral Bonus calculations for the Networked customers as per the Business Policies

Automatic Commission / Bonus processing system. Numerous reports. Prepares and Prints the Paychecks on schedules. Easy and smooth Order processing. Printing Invoices with bar-coded shipping labels

FoxPro 2.6. Runs on Win98, ME, 2000 and XP

Heat treat metal parts

Stores heat treating recipes and tracks work orders

Displays pictures of parts, automatically faxes invoices to customers. Grabs and stores signatures from electronic signature pads. Has helped them become relatively paperless.

MS Access front end and backend (Jet); Windows on workstations; Linux on server





Industrial Catering

Vendor purchases and sales to customers

It creates vendor orders based on customer needs. Creates invoices and order forms. Does some graphing of historical data so they can track sales statistics.

MS Access front end; Jet backend; Windows on workstations and server


Tracks policy information for McDonald's restaurant owners

Tracks customers and the restaurant locations. Has autofax feature for sending proposals to customers.

Visual FoxPro 6.0 runs on Windows workstations and server

Legal Newspaper

Tracks legal notices (mostly mortgage foreclosures)

Allows users to set up notices that appear in the paper and invoice customers (attorneys). They are trying to become paperless.

MS Access front end; MS SQL Server 2000 backend; runs on Windows workstations and Interland server


Customer Order Tracking System. System will enable to track the Orders in Shop Floor and will efficiently improve the communication and interrelationships of the department

Flexibility, Expandability. All the customer orders and the status of the given orders are being tracked very easily since we implement this solution.

Visual FoxPro 7.0 and Oracle 9.0. Runs on Win98, ME, 2000 and XP

Medical Billing

Medical Billing Software: Required to meet the Government Mandated Ansi X12 standard for Medical Billing.  HIPPA compliant

Allows ClincPro's Clients (600 Nationwide) to Submit Claims directly using the current billing standard.

Visual FoxPro 7.0

Mortgage Loans

Tracks loan production and commissions

Allows the Company to quickly enter and Track Mortgage Loans. Allows the user to track and pay Commissions for the Loan originator and subordinates. Generates Complex reports for Tracking Loan Production and Commissions

Visual FoxPro 8.0

Pipe and Fittings

Handles inventory, purchase order and quote placement and tracking

Addresses the need to "link" a quote with a purchase order and along with maintaining catalogs across multiple vendors.

Visual FoxPro 8.0, Crystal Reports

Private School

School lunch program

Keeps track of kids and the lunch program they are on. Program is not complete.

MS Access front end; Jet backend; Windows on workstations and server

Produce Growers

Tracks apple and pear production and sales

Many reports on sales and production including customer invoices.  Also tracks profit.

MS Access front end; Jet backend; Windows on workstations and server

Stock Broker

Handles all aspects of processing for the Broker Dealer Relationship

Allows for the management of Sales of Financial Instruments and Stocks the a proprietary Commission Payment system

Fox 8.0, ASP.Net, SQL Server

Workers Compensation Self Insured Group Funds

Management System for a Self Insured Group Fund

Performs Promulgation of MOD's Calculates Premium. Tracks Losses and Payroll. Automates all aspects of the Policy Life Cycle. Provides powerful reporting capabilities

Visual FoxPro 8.0, SQL Server