Create Microsoft Access Form which uses an [login to view URL] ExGrid ActiveX control to display hierarchical information

This project requires expertise using Exontrol’s ExGrid ActiveX control together with Microsoft Access. Exontrol provides very little guidance in how to approach a project like this, but the control can handle the functionality requested below.

Create a single Microsoft Access form to use a single Microsoft Access Table. The structure of this table should place all “technical” and non-visible fields first followed by the fields that are displayed with the user, the first of which is the field used to display a hierarchy. All subsequent fields are for user information only. The first two technical fields are ItemId and ParentItemId which permits the building of the hierarchy similar to that used by a bill of material in manufacturing.

The form has six command buttons as follows

Save

Edit

Add

Delete

Copy

Cut

Paste

Move right

Move left

The form is bound to the Microsoft Access database and is used to maintain the information until a Microsoft TreeView control.

The following functionality is required:

Load the data into the ExGrid control on a bound MS Access form.

Set the column that is used for the hierarchy, perhaps ItemDescription

Add a record

Delete a record

Delete contiguous records

Delete a hierarchy node and all its children

Move a hierarchy node to the left with all its children

Move a hierarchy node to the right with all its childrenSelect an individual record, copy, paste below another selected record

Select contiguous records, copy, paste below another selected recordchild

Select a hierarchy node with its children, copy, paste below another selected record

Select an individual record, cut, paste below another selected record

Select contiguous records, cut, paste below another selected record

Select a hierarchy node with its children, cut, paste below another selected record

Hoisting a node so that only the node record and its children records are displayed, etc.

Microsoft Access Visual Basic

หมายเลขโปรเจค: #31282365

เกี่ยวกับโปรเจกต์