Alternative to MSFlexGrid active X control using in MS Access 2010.

We want to get alternative to MSFlexGrid active x control  for using in MS Access 2010 on forms.
alihassansandhuAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Most people simply use a datasheet or continuous view form to do such things, but there are a few 3rd party controls:

10TEC: http://10tec.com/articles/ms-access-grid-control.aspx
TList: http://www.bennet-tec.com/btProducts/TList/TList.htm
DBI-Tech: http://www.dbi-tech.com/ProductPage_StudioControlsCOM.aspx

I've demoed all of them, and each has their strengths and weaknesses.

Also, if you're going to deploy this to others, you must be sure to deploy the grid's redistributables when doing so.

All in all, if you can do this with continuous view Subform or Datasheet, you'll be much, much better off.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
alihassansandhuAuthor Commented:
Thanks for you reply.

I have existing project that is build in VB6 with the MSFelixGird Active X in MS Access.
Now we want to change the MS Felix Grid to the alternate of MSFelixGrid.
 
Also we need all the custom properties, methods and events just like MSFilexGrid to do this.

Thanks..
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you using Visual Basic 6.0 as your programming environment, and then using an Access database as your datastore? If so, then you could use any VB6-compliant grid (and there are hundreds of those).

Or - are you using Microsoft Access as your programming environment (i.e. creating Forms/Reports, etc)? If so, then you are VERY limited as to what you can do, and the grids I listed above are about the only ones available (at least the only ones I've ever found/used).

I can't tell you if any of those grids have the same properties/methods as MSFlexGrid, but you could review the product pages to determine if they would suit your needs.
Active Protection takes the fight to cryptojacking

While there were several headline-grabbing ransomware attacks during in 2017, another big threat started appearing at the same time that didn’t get the same coverage – illicit cryptomining.

Jeffrey CoachmanMIS LiasonCommented:
<No Points wanted>

But remember what Scott said first.
You can typically substitute a standard Access datasheet (sub)form (or even a listbox, ...if you don't need to make edits), for a FlexGrid.
I once worked on an app developd by a VB6 programmer, and he was more familiar with VB6, so he used a FlexGrid.
When I opened the App, I thought it was a standard subform, (it looked and functioned the same), then I discovered that it was a VB6 control.
I substituted a standard subform inplace of the flexgrid, then I could delete all the associated Flexgrid code.
Worked exactly the same, with no overhead, and I did not have to load any external libraries.

To be fair, you can still use the Flexgrid if it offers some additional functionality/flexibility, or you are just more familiar with it.
Its just that it carries a lot of overhead if all you need to do is dislay a listing of records.

Again, ...just an FYI.

I am sure Scott can get you sorted in any event.

JeffCoachman
PatHartmanCommented:
The question you need to ask yourself is "what do I need the grid to do that a subform or listbox will not do"?  Using a subform or listbox lets you work WITH Access instead of around it or against it.  The native controls are bound and you don't need code to manage filling and updating.  But, the native Access controls lack "prettiness".  They are difficult to colorize and they have trouble displaying graphic objects.
alihassansandhuAuthor Commented:
Thanks for the reply.

We are using Microsoft Access and now the we are implemented "iGrid" active x control.


Thanks to all for your Guidelines.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.