Freelance
Freelance job, am asking for estimate...
TBD
Aug 25, 2021
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
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.