This code is a custom control I wrote for use in our companies products. It has tons of implemented ideas in it - way, way too much to list. So a full HTML help file is also included.
The grid will bind directly to an ADO recordset, or will make an internal copy of the recordset if you wish.
I would like to thank everybody that posts on this site. Some of the examples have been invaluable over the years, so I like to return the favors.
'**************************************
'Windows API/Global Declarations for :ntFlexGrid - GRADIENT/PICTURE BACKGROUND! Drag/drop, formatting - TOO MUCH TO LIST!
'**************************************
Uses ADO and MSHFlexGrid. Explore the help file before using the grid.
I included the MSHFlexgrid control in the Zip File for those that might not have it already.
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
Re-scan downloaded files using your personal virus checker before using it.
NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
Scan the source code with Minnow's Project Scanner
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
Terms of Agreement:
By using this code, you agree to the following terms...
You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
I would really appreciate votes on this. I had to lose the first 12 excellent votes as I submitted on the last day of February, so I resubmitted it a day later. (If this comment was disrespectful, please report it.)
Repeated my vote (5+) and I repeat my note: The most professional grid in pure VB with free source I've every seen! ___ / Let's see if you can win this month contest without a gradient background option ;-))) / Regards and MANY thx for sharing! LiTe (If this comment was disrespectful, please report it.)
Excellent hard work. I have been using a commercial grid for my home projects, but I am going to change to yours. Thanks for sharing your work. Any changes or updates let me know. I hope you win this month. It just kills me how people here will use someone else's code but won't take the time to vote. (If this comment was disrespectful, please report it.)
3/2/2005 8:25:31 AM:
Nice, very nice. 5 form Croatia. Thnx for sharing!!!!! ;-)) (If this comment was disrespectful, please report it.)
Really amazing! ***** I tried to email u from psc's mail service but got bounced one. could u drop me a word? (If this comment was disrespectful, please report it.)
3/2/2005 2:54:49 PM:
Absolutely brilliant, some excellent work. (If this comment was disrespectful, please report it.)
3/2/2005 8:15:20 PM:
I work for a major global corporation and we use this grid and helped with beta testing. The grid works better than any other product (even more expensive products) that we reviewed before making the purchase.
Simply put, I can outpace client expectations and surprise folks with short development time due solely to this grid's functionality and usability.
If you like this one, reduce your access ado coding efforts by using their database connection dll. It isn't free (like the grid) but it's worth 20 times the cost in reduced coding efforts. (If this comment was disrespectful, please report it.)
The reason it takes a little extra time to load with larger recordsets is because of the way it builds the indexed recordset internally. This is what allows the grid to have the filter capabilities it has. Being able to 'Stack' filters is a major plus for many of my programs. Otherwise, if you try to just keep making the filter string longer, you start getting ADO errors.
You will notice though, that once that is finished, the scrolling around is quite fast, regardless of the size of the recordset, because I am treating it as a 'virtual' grid and only loading and drawing the rows that are onscreen.
If someone comes up with a better way, please let me know.
I am currently porting this grid over to .Net also, and it will have a gradient background!
I appreciate the votes and support.
(If this comment was disrespectful, please report it.)
P.S. Honesty goes a long way. You could have said you reposted 'cause you found a huge bone-head mistake & were embarrassed to have it out here on PSC. Nothing wrong wanting to compete for the prize when you post a good piece of work. Good luck. (If this comment was disrespectful, please report it.)
look lavolpe dont say there are no comparison someone voted on my code 1* only without giving any reason i dont think that was fair ethier and darrny u have my apology u have a fine piece of work there and i changed my vote to 4 just to keep the competion going k so dont be mad at me ^_^ (If this comment was disrespectful, please report it.)
I have always looked for a control with these characteristic ones and I already found it congratulations friend. (If this comment was disrespectful, please report it.)
Would have voted, however I had trouble getting it to run. I even compiled and registered the ocx and still got an error when starting up the test project. Looking thru the code I can tell alot of time went into it, just couldn't get it to run! :) (If this comment was disrespectful, please report it.)
There are many open-source projects, that can be found only on PSC, what usually proves that those projects are finished for good as this site relies only on a giant database, web space and bandwidth (unlike sourceforge, codeproject, etc). It is nice that people like to share their vb code here, but there is no team-work here. Best open-source projects come from many people working together, using their free time to beat “industrial quality” non-free software. Well, I hope you get the point and don’t take this as an insult or something.
For an example take www.vbaccelerator.com, the site is full of great code coming from a great brain, but his code is only a starter and/or a component for something bigger and therefore serious projects. (If this comment was disrespectful, please report it.)
Last, but not least, this grid was never intended to be the primary edit function for the recordset. It is intended to be a very good way to display, drill-down, and select data. I find that 95% of all my editing by users simply requires too much ancillary information, validation, etc. to be simple enough to just let them edit it in a grid. Not nearly idi@t proof enough for most application users.
(If this comment was disrespectful, please report it.)
Wow! There is a lot of work in this and thus alot for me to learn from. Remember Alas>, this site does indeed serve a real purpose (hence the reason for its undeniable popularity). There is not one single resource on the web or otherwise that has taught me, and probably many others as much and as fast. The collaboration sites serve their purposes well. I personally, wish to thank this author and all the others for the profound impact on my career. 5 nuts for you Darryn; well done. (If this comment was disrespectful, please report it.)
This is realy gr8 work (If this comment was disrespectful, please report it.)
5/13/2005 3:07:24 PM:
I'm getting more interested in knowing the functionalities of MSHFLEXGRIDS and the possibility of having backgrounds. Sounds great. Courage and the sky is the limit ! (If this comment was disrespectful, please report it.)
Wonderful Thanks a lot (If this comment was disrespectful, please report it.)
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
By 62 Users
Download code
3/1/2005 2:20:21 PM: 
