By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,301 Members | 1,766 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,301 IT Pros & Developers. It's quick & easy.

Microsoft Flex Grid

P: n/a
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

Mar 12 '06 #1
Share this Question
Share on Google+
9 Replies


P: n/a
"Vincent" <an**********@verizon.net> wrote in
news:11*********************@j33g2000cwa.googlegro ups.com:
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.


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/
Mar 12 '06 #2

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

Mar 12 '06 #3

P: n/a
"Vincent" <an**********@verizon.net> wrote in
news:11**********************@i40g2000cwc.googlegr oups.com:
If this is a 3rd-party control, why is it called the Microsoft
Flex Grid and not the David W. Fenton Flex Grid?


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/
Mar 13 '06 #4

P: n/a
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

Mar 13 '06 #5

P: n/a

"Vincent" <an**********@verizon.net> wrote in message
news:11*********************@e56g2000cwe.googlegro ups.com...
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


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

P: n/a
Per David W. Fenton:
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?


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
Mar 13 '06 #7

P: n/a
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)

Mar 13 '06 #8

P: n/a
Gord,

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

-Vincent

Mar 19 '06 #9

P: n/a
>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).

Mar 20 '06 #10

This discussion thread is closed

Replies have been disabled for this discussion.