Automate Filling Out Forms and Processing Form Data

Now Available!  Spectraforms ActiveX control allows you to include Spectraforms' forms in your own software applications. 

Spectraforms^® Designer allows you to write software to take control of Spectraforms.  Spectraforms provides a COM* Automation (sometimes called OLE Automation) interface to allow control through other programming languages include:

• Microsoft Visual C++
• Microsoft Visual Basic
• Microsoft .NET Languages, such as as C#
• Borland Delphi and C++ Builder
• Other languages that support Windows COM application programming.

Write applications that:

• Transfer your form data to a database
• Automatically populate form data from a database
• Automatically generate forms to document industrial process, such as automatically filling out and printed a quality control form for a defective part
• Automatically generate and print invoices, purchase orders, sales price quotes, and shipping labels with barcodes
• Process employment forms such sick leave, vacation, time cards, W2 forms, and travel
• Many other functions

Contact Starpoint Software for further information including the Spectraforms COM interface documentation and type libraries.

* COM is an acronym for Component Object Model

 

Spectraforms® COM Database Examples
Click on an image to view full size

Spectraforms® Report Generation

Spectraforms® replace report engine software such as Crystal Reports® to generate reports from your database.  Design report templates in Spectraforms® Designer.  Write software using COM Automation to read your database and populate the report template.

		Spectraforms can replace your existing report generation software.  The secret to Spectraforms quality reports is the data grid element.  Shown here displaying a table report from Compliance Navigator®, rows in the data grid automatically expand vertically, and wrap text to accommodate all text in a cell.  You specify the appearance of the report in the form template, and use COM Automation to populate the report from your database.  No other reporting system can give such professional and customizable reports.
		Spectraforms is not limited to tabular reports.  Shown here is a master-detail report showing findings for an audit from a Compliance Navigator® database.

 

Invoice, Purchase Orders, Sales Forms

Use Spectraforms® designer to create professional looking invoice, purchase orders, and other sales and accounting forms.  Automatically generate printed invoices from your order entry software.  Design financial report templates in Spectraforms Designer and use COM Automation to populate the templates with data from your accounting system.

Starpoint Software uses Spectraforms to automatically generate invoices from our order-entry software.  We designed an invoice template.  When an order is placed, we use COM Automation to fill out and print the invoice for the order.  The invoice is saved to a separate file so a copy of every invoice is retained, and the appearance is much more customizable and professional looking that invoices done in Microsoft Excel®, Crystal Reports®, QuickBooks®, Peachtree®, or other accounting packages.

 

Database Connection Example

In the example below, the small utility program in the bottom left of the window connects to a database of car information.  As you scroll through the records in the database, the utility program uses COM Automation to populate a form with information from the current database record, also updating the picture of the item.