Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2007

Tip: Looking for answers? Try searching our database.

Flex grid question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rodney - 04 May 2007 07:17 GMT
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 - 04 May 2007 14:54 GMT
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.

>Hi,
>I am using the diary flex grid I downloaded from Peter Hibbs's web site.
[quoted text clipped - 20 lines]
>Thank you in advance
>Rodney
Rodney - 05 May 2007 04:19 GMT
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

> Hi Rodney,
>
[quoted text clipped - 54 lines]
> >Thank you in advance
> >Rodney
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.