E.C.N. database template

 

The ECN database uses the Microsoft Office 2000 VBA and Visual Basic 6.0 as software platform for further development. The main application uses the Microsoft Access 2000 VBA libraries and a series of helper applications written in VB6.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Important: The administrator password for this sample application is amydognera

Definitions:

 

PART NUMBER  = XXXYYY is a six characters string, first three characters for the part group, followed by three characters representing the part’s position in the group.

 

PROJECT NUMBER is a six-character string, first three for project category, next two for project position in category, and the last character used to define the phase of the project.

 

Security rules for ECN database:

 

1.        Only the ECN database administrator can generate a new ECN number.

2.        A filed in ECN database can be edited by any ECN user as long as that field is an empty filed, except signatures fields.

3.        A critical field is a field that requires login a password prior to be edited.

4.        A critical field containing valid data in a saved record will be owned (locked) by that user who has saved the record and only the owner can further edit that field.

5.        A signature field accepts as valid candidates users a certain number of users designated by the ECN database administrator.

 

General rules for ECN database:

 

1.        Label’s caption text is editable to allow easy changes for field’s destination. Only the ECN administrator can edit them. Changes to the label’s caption are reflected in the report’s labels caption.

2.        An ECN report (hard copy) can be saved as a PDF file or output directly to a shared printer.

3.        A combo-box type of entry field accepts any input text or a selection from the drop down list. The drop down list captures selective data as indicated by the user after a double-click on the corresponding field.