MSFlexGrid / HFlex

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Diana Criscione - 17 Mar 2004 23:46 GMT

I want to be able to display records from a Purchase Order table and the related ReceivingLog records in the same subform and have it displayed similar to a subdatasheet. I've used the HFLex in VB apps before but am having trouble in Access. Several questions and issues....

1. I would like to use the HFLex control on my Access form. Can you use this control in 97? (I'm currently developing this app in 2000 because my main development machine is running AccXP -- I will convert to 97, move to another box and fix/finish development in 97 per client requirements

2. How do I specify what data to bind to the control? I tried to add the HFlex control and got an error "trouble communicating with OLE Server" when I tried to "retrieve structure

3. The FlexGrid gives me a license error when I try to use it. I've got Office XP Developer and VS .NET Enterprise Architect on my machine. I read a previous post that said this control ships with VB6. Do I need to install VB6 to get the control working? Will I run into problems with trying to run both versions on my machine

Thanks for the help
Diana

Reply to this Message

Tony Toews - 18 Mar 2004 03:02 GMT

>I want to be able to display records from a Purchase Order table and the related ReceivingLog records in the same subform and have it displayed similar to a subdatasheet. I've used the HFLex in VB apps before but am having trouble in Access. Several questions and issues.....
>
>1. I would like to use the HFLex control on my Access form. Can you use this control in 97? (I'm currently developing this app in 2000 because my main development machine is running AccXP -- I will convert to 97, move to another box and fix/finish development in 97 per client requirements)

>2. How do I specify what data to bind to the control? I tried to add the HFlex control and got an error "trouble communicating with OLE Server" when I tried to "retrieve structure"
>
>3. The FlexGrid gives me a license error when I try to use it. I've got Office XP Developer and VS .NET Enterprise Architect on my machine. I read a previous post that said this control ships with VB6. Do I need to install VB6 to get the control working? Will I run into problems with trying to run both versions on my machine?

1) I have no idea what the HFlex grid control is. If this is also the
MS Flex Grid control then see the following:

There is a link to some sample code for MS Flex Grid at the Access
Compatible Grid Controls page
http://www.granite.ab.ca/access/gridcontrols.htm at my website.

2) Many ActiveX controls do not work inside MS Access unless the
vendor specifically states that they do support Access. In which case
they will likely also have sample code on their website. For more
details see the following Knowledge Base articles at
support.microsoft.com.

ACC97: Custom ActiveX Control Features Supported in MS Access 97
[Q164241]
ACC97: ActiveX Controls List Doesn't Show All ActiveX Controls
[Q174964]
ACC2000: Custom ActiveX Control Features Supported in Access [Q202104]
ACC2000: Supported ActiveX Controls for Microsoft Access 2000
(Q208283)

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Reply to this Message

Diana Criscione - 18 Mar 2004 04:11 GMT

Thanks for the links! I'm not sure I'll be able to do what I want to do in 97 but I only briefly looked at the info so I'll dig deeper tomorrow

The HFLex is the Hierarchical FlexGrid control (mshflxgd.ocx). Like I said, I've used it with VB but it's very possible that it cannot be used in Access, much less version 97

Thanks again for the advice
Diana

Reply to this Message