Flex Grid question for Peter Hibbs

[Rodney]

Peter,
I have seen in previous posts you talk about the flex grid and I have been
to your site (which is Excellent, very helpful) and downloaded the sample
database. I would like to use the diary but use it for a roster for when
staff are working.
I can get it working how I would like in your database but when I import the
table, form & module into my database and I open the form I get the following
error

Compile error
Variable not defined

and the highlighted code is

flexAlignCenterCenter

Please help


Thank you
Rodney

 

[Douglas J. Steele]

While in the VB Editor with Peter's sample database open, select Tools |
References from the menu bar. Take a look at the references he has selected:
one of them will doubtlessly relate to the flex grid control.

Open your database, go into the VB Editor, select Tools | References from
the menu bar, and scroll through the list of available references until you
find the one Peter added. Select it (by checking the box to the left of it),
and click on OK.

 

[Peter Hibbs]

Hi Rodney,

As Douglas said, you need the Reference ticked. It is called Microsoft
FlexGrid Control 6.0. You also need the Microsoft DAO 3.6 Object
Library ticked (but I guess you have already done that).

Glad you liked the demo.

Peter Hibbs.

 

[Rodney]

Thank you both for your response.
I don't seem to have Microsoft FlexGrid Control 6.0. in my list to select,
and Microsoft DAO 3.6 Object Library is selected.

Can you please tell me where I can get Microsoft FlexGrid Control 6.0. from.

Many Thanks

Rodney

 

[Rodney]

I must have it here somewhere for the sample database to work, I better have
another look.

Rodney

 

[Rodney]

Peter & Douglas,
I found it, added it and selected it and it works great.

Thank you both for your help much appreciated

Rodney