Flex grid question

[Rodney]

Hi,
I am using the diary flex grid I downloaded from Peter Hibbs's web site.

I am not using it as a diary I am using it as a roster so I am only using
the week and month options.

To enter data I have it setup so when the user clicks on the flex grib it
opens a data entry form, which all works fine but the flex grid only updates
when the data entry from is closed.
Is there a way I can have the flex grid update without closing the entry
form eg: by having it update when you click a new record command button or a
refresh command button.
I would like it to update because as a roster the user may be creating a
roster for a week or more and easyer if you can see how you are already using
in that week.

Also I am trying to change the font size and the only setting I can find is
the flex grid object properties where the font is set to 8.25 but it will not
let me change it, when I change the size and apply and then close the
properties it reverts back to 8.25.
I would appreciate so help with these issues.

Thank you in advance
Rodney

 

[Peter Hibbs]

Hi Rodney,

I assume you are copying the data to the Flex Grid control in the
Form_Activate event as I have in the demo program. If so then you need
to re-trigger that event from your Data Entry form.

The method I use is to hide the Data Entry form briefly which will
move the focus back to the Flex Grid form (assuming that this is the
only other form open) which will trigger the Form_Activate event which
will refresh the Flex Grid data. If you have a 'refresh' button or
some other suitable event on your Data Entry form the code would be
something like this.

Private Sub cmdRefresh_Click()
Save your new data to the tables (if not already done)
DoCmd.OpenForm "frmDataEntry", , , , , acHidden
DoEvents
DoCmd.OpenForm "frmDataEntry"
End Sub

The screen flickers a bit as the form disappears and then re-appears
but I think it is acceptable.

Regarding the font size, I have tried this and it works OK. How are
you changing the font size, with code or using the Custom property of
the Flex Grid control. I suggest you try changing the font size in my
demo program for one of the forms and see if that works. If it does
then it may be a problem with your own database, if it doesn't then it
may be some problem with the Flex Grid control or Windows.

HTH

Peter Hibbs.

 

[Rodney]

Peter
Thank you very much it's working perfect (hope I haven't spoken to soon) at
present.
I still cann't change the font though but I not concerned about that.

Thank you again much appreciated.

Rodney