Microsoft Flex Grid

I am trying to create a function that is called on the Flex Grid's
MouseDown event. However, this event is not listed in the properties
for this object. I tried to manually create the prototype for this
event as:

Private Sub flGrid_MouseDown(Button As Integer, Shift As Integer, X As
Single, Y As Single)
End Sub

This only gives me an error. I read on one posting that you should
always have the IDE create the prototype for you. But I do not see
this event in the Flex Grid's properties! What am I doing wrong?
Thank you for your help.

-Vincent

re: Microsoft Flex Grid

"Vincent" <animedreamer@verizon.net> wrote in
news:1142180427.269611.72370@j33g2000cwa.googlegro ups.com:
[color=blue]
> I am trying to create a function that is called on the Flex Grid's
> MouseDown event. However, this event is not listed in the
> properties for this object.[/color]

Why would you use a 3rd-party control in Access, where the built-in
subforms work so well and are completely integrated into the
product?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

re: Microsoft Flex Grid

If this is a 3rd-party control, why is it called the Microsoft Flex
Grid and not the David W. Fenton Flex Grid?

re: Microsoft Flex Grid

"Vincent" <animedreamer@verizon.net> wrote in
news:1142205335.994202.140760@i40g2000cwc.googlegr oups.com:
[color=blue]
> If this is a 3rd-party control, why is it called the Microsoft
> Flex Grid and not the David W. Fenton Flex Grid?[/color]

It's 3rd-party in the sense that it's non-native to Access. Access
provides its own controls for this purpose that are far easier to
use and more versatile.

If you're not trying to use the grid in Access, then you're posting
in the wrong newsgroup.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

re: Microsoft Flex Grid

I am trying to use this grid in Access. And if there is an easier
control for this purpose, by all means, do not leave me in suspense!
Are there controls in Access that will allow me to:

dynamically alter the number of rows and columns?
change the text color and cell color of individual cells?
allow me to drag and drop between cells?

-Vincent

re: Microsoft Flex Grid

"Vincent" <animedreamer@verizon.net> wrote in message
news:1142214203.830149.65030@e56g2000cwe.googlegro ups.com...[color=blue]
>I am trying to use this grid in Access. And if there is an easier
> control for this purpose, by all means, do not leave me in suspense!
> Are there controls in Access that will allow me to:
>
> dynamically alter the number of rows and columns?
> change the text color and cell color of individual cells?
> allow me to drag and drop between cells?
>
> -Vincent
>[/color]

No. That is to say you can do most of those things
one way or another, but it's not really supported
by Access.

re: Microsoft Flex Grid

Per David W. Fenton:[color=blue]
>Why would you use a 3rd-party control in Access, where the built-in
>subforms work so well and are completely integrated into the
>product?[/color]

I don't like the idea either - but only from a distribution/installation
perspective.

But one reason would be to allow formatting certain rows differently from others
in a continuous form. I've got a glimmer of recollection that some new
event/property in 2003 might facilitate this, but for earlier versions a
third-party control might do things that cannot be done with native Access
controls.
--
PeteCresswell

re: Microsoft Flex Grid

Try opening the Visual Basic Editor ([Alt-F11]), choosing the name of
your FlexGrid control in the left drop-down list, then choose the
MouseDown event in the right drop-down list. That gave me:

Private Sub flGrid_MouseDown(ByVal Button As Integer, ByVal Shift As
Integer, ByVal x As Long, ByVal y As Long)

re: Microsoft Flex Grid

Gord,

Where are you finding this MouseDown event for the Flex Grid? I
see no such thing anywhere in my editor. Thanks.

-Vincent

re: Microsoft Flex Grid

>Where are you finding this MouseDown event for the Flex Grid?

In the Visual Basic Editor, as I described earlier. After adding a
FlexGrid control to a form the MouseDown event does not appear in the
Properties page for the control in the Access form designer, but it
does appear in the Visual Basic Editor (for me, at least).