Interfaces to
DGrid Control
for ADO & DAO
DGrid Control Version 1.0
 |
|
DGrid is a Lightning Fast grid control for DAO and ADO recordsets. Simple, Functional, and extremely easy to program. It can be used with or without a Data Control. Zero grid population time! Display a recordset as fast as you can load it! Features include In Cell Editing, Add New Records, Delete Multiple Records, Excel Like Selections, Print, Copy, SaveAs, (selected range or entire grid) FillDown, Series, Find, Edit and Add New Validation, Scroll Bar ScrollTips, Mouse Wheel Support, and Resizable Columns.
If you need a lot of fancy formatting, in cell controls, tree views, and the like you'll probably want to choose another grid. If you just need to display and edit data in a very familiar format, crank out a quick, cheep database program for a customer, or have extremely large recordsets to display and don't want to wait for the fancy grids to populate, then DGrid is a great choice!
Keyboard actions
The Home, End, Page Up, and Page Down keys scroll the grid without changing the active cell or current selection. The Up, Down, Left and Right arrow keys move the active cell accordingly. In Edit Mode, the Tab key moves the active cell to the next cell in the grid. Out of Edit Mode, the Tab key moves to the Goto edit box or the next control on the form. The Enter key moves the active cell based on the EnterMoves property setting. The F2 key and Enter Key will put the grid in edit mode. The Escape key will cancel edit mode and abort adding a new record. Pressing any key or clicking the grid during a lengthy copy or save as operation will cancel the operation.
Compatibility
I wrote this using Visual Basic 6.0. It was written to be used only with Visual Basic 6.0 and I suggest you not attempt to use it in any other environment. It won't work! Both the DAO and ADO versions of the control were written specifically for Microsoft Access databases and the Jet Database engine. Your welcome to try other data sources, but I have not tested the controls in anything but Access. The HTML Help file only works in containers that support .chm help systems. If you can't access context sensitive help in VB make sure a copy of hcdrgidv1.chm is located in your Windows\Help folder. DGrid should run on any 32 bit Windows OS.
DGrid Control Elements
You can contact me at:
Email rww@hillbillycode.com
Phone 719
251-2679
Windows, Visual Basic, Access, Excel, Jet, DAO, and ADO are Trademarks of Microsoft Corporation.