MSFlexgrid Scrolling - Followup
in [Visual Basic]
|
From: David on 13 Apr 2010 19:37 !) OK found what was causing the loop: The parameter of RowIsVisible is supposed to be a column I mistakenly put in a Row. This now leaves with some other issues: 1) If I use the Date Column (GRIDC_Date) and select a row that contains the date, I can scroll OK -------- EXCEPT -------- scrolling the active edit row will NOT go above or below the visible bounds of MSFlexGrid. Is this by design? 2) If I use the Date Column (GRIDC_Date) , and select a row where there is NO date in that column everything gets #$%^& up. My guess is somehow the MSFlexGrid is obtaining a pointer to the date value in order to check the cell location and if blank can't handle it? Know anything about this? "David" <NoWhere(a)earthlink.net> wrote in message news:OvUl$912KHA.3652(a)TK2MSFTNGP02.phx.gbl... > Mr. Hunt: > > Thanks for responding. > You'll need to enlighten me a little further. > > The _Click event does Not trigger when Scrolling. > I use the _Click to obtain the row of interest when I go into "EDIT or > "ADD" mode. > However as indicated --- with my scroll code -- the scroll event for some > reason goes into a loop. > > All SetEditControls does is Position the various controls (it does use > .Row with .TextMatrix however) and toggles the visibility of the various > controls. Hence the select case in the scroll event. I'm using > >>> If .RowsIsVisible(miSaveRow) Then > > to check whether the row being "Edited" is on or off the screen to know > whether the controls needed to positioned while scrolling. > > > > > "Phil Hunt" <aaa(a)aaa.com> wrote in message > news:OToS4F02KHA.4752(a)TK2MSFTNGP02.phx.gbl... >> what you show is not enough. maybe your setEditControls mug around with >> the row or column index which will trigger scroll event again. BTW, >> RowsIsVisible is not very reliable. I have the same program running on >> different PC, one work one does not. >> Didi you try using the click event, it gives you the row / column index >> to work with. >> >> "David" <NoWhere(a)earthlink.net> wrote in message >> news:OBrmoEz2KHA.1624(a)TK2MSFTNGP06.phx.gbl... >>>I use both a textbox and several combos on my MSFlexgrid for >>> Adding or Editing the grid. When I'm in "Add or Edit" mode >>> and scroll the grid the position of the textbox and combos does NOT stay >>> with the row being edited or added. I've tried the following, but when >>> "Add or Edit" mode is entered the Scroll bar event seems to >>> get in an infinite loop. Any idea how to trap the Scroll event (this >>> triggers for both horizontal and vertical scroll) to allow the textbox >>> and combos to either track the row of interest or shut them off so they >>> are >>> not visible if the row is not visible??? >>> >>> Private Sub MSFlexGrid1_Scroll() >>> >>> Select Case miEditMode >>> >>> Case EDIT_EDIT, EDIT_ADD >>> With MSFlexGrid1 >>> If .RowsVisible(miSaveRow) Then >>> ' '= False Then .TopRow = .Row >>> Call SetEditControls(True) >>> Else >>> Call SetEditControls(False) >>> End If >>> End With >>> Case Else >>> >>> End Select >>> >>> >>> End Sub >>> >> >> > >
From: Helmut Meukel on 14 Apr 2010 11:24 "David" <NoWhere(a)earthlink.net> schrieb im Newsbeitrag news:eq5LBJ22KHA.1016(a)TK2MSFTNGP02.phx.gbl... > !) OK found what was causing the loop: > The parameter of RowIsVisible is supposed to be a column I mistakenly put in a > Row. > > This now leaves with some other issues: > > 1) If I use the Date Column (GRIDC_Date) and select a row that contains the > date, I can scroll OK -------- EXCEPT -------- > scrolling the active edit row will NOT go above or below the visible bounds of > MSFlexGrid. > > Is this by design? > > 2) If I use the Date Column (GRIDC_Date) , and select a row where > there is NO date in that column everything gets #$%^& up. > > My guess is somehow the MSFlexGrid is obtaining a pointer to the date value in > order to check the cell location and if blank can't handle it? > > Know anything about this? > David, which Version of Flexgrid are you using? (AFAIK, there are some differences between Version 5.0 and 6.0) Helmut.
From: Helmut Meukel on 15 Apr 2010 15:17 David, without knowing which version of MSFLXGRD.OCX you are using it's hard to answer your questions. I just checked on one of my multi-boot systems and found these versions: (some with same version number but different dates) Version Size 5.0.37.14 197 KB 5.1.43.19 223 KB 6.0.81.69 239 KB 6.0.84.18 239 KB 6.1.97.82 255 KB So the VB5 version was at least updated once, the VB6 version was at least updated twice. I say 'at least' because I can't guarantee I have all version on the machine I seached :-) . Please check what version you are using and if it's an older one then update! If the problem still persists or you are already using the latest VB6 version, then come back to us. Kind regards Helmut. "Helmut Meukel" <NoSpam(a)NoProvider.de> schrieb im Newsbeitrag news:%23Obvka%232KHA.1452(a)TK2MSFTNGP06.phx.gbl... > "David" <NoWhere(a)earthlink.net> schrieb im Newsbeitrag > news:eq5LBJ22KHA.1016(a)TK2MSFTNGP02.phx.gbl... >> !) OK found what was causing the loop: >> The parameter of RowIsVisible is supposed to be a column I mistakenly put in >> a Row. >> >> This now leaves with some other issues: >> >> 1) If I use the Date Column (GRIDC_Date) and select a row that contains the >> date, I can scroll OK -------- EXCEPT -------- >> scrolling the active edit row will NOT go above or below the visible bounds >> of MSFlexGrid. >> >> Is this by design? >> >> 2) If I use the Date Column (GRIDC_Date) , and select a row where >> there is NO date in that column everything gets #$%^& up. >> >> My guess is somehow the MSFlexGrid is obtaining a pointer to the date value >> in order to check the cell location and if blank can't handle it? >> >> Know anything about this? >> > > > David, > > which Version of Flexgrid are you using? (AFAIK, there are some differences > between Version 5.0 and 6.0) > > Helmut.
From: David on 15 Apr 2010 19:25 Thanks Mr. Meukel: ReWorked my code and hopefully (??) have it resolved. FWIW : I'm referring to MSFlexgrid Control 6.0 (SP6). Not sure where you're getting the size and version # unless directly from the registered dll as does not show in Components / References in VB IDE. I'm also using this with VB5. As I recall, MS had something (quite a few years back) that allowed you to use upgraded VB6 controls with VB5. (Will have to dig for this one on my system if of interest to you). Also unknown whether upgrading to XP, and multiple Service Packs made any upgrades / changes Use to try and keep close track of my system, but will all the service packs / automatic updates etc. etc. hard --or impossible -- to know what M$ is changing. Gave up on this as would need to hire a full time staff just for this David "Helmut Meukel" <NoSpam(a)NoProvider.de> wrote in message news:%23w2aMBN3KHA.3844(a)TK2MSFTNGP05.phx.gbl... > David, > > without knowing which version of MSFLXGRD.OCX you are using it's hard > to answer your questions. > I just checked on one of my multi-boot systems and found these versions: > (some with same version number but different dates) > > Version Size > 5.0.37.14 197 KB > 5.1.43.19 223 KB > 6.0.81.69 239 KB > 6.0.84.18 239 KB > 6.1.97.82 255 KB > > So the VB5 version was at least updated once, the VB6 version was at > least updated twice. I say 'at least' because I can't guarantee I have > all version on the machine I seached :-) . > > Please check what version you are using and if it's an older one then > update! > If the problem still persists or you are already using the latest VB6 > version, > then come back to us. > > Kind regards > > Helmut. > > "Helmut Meukel" <NoSpam(a)NoProvider.de> schrieb im Newsbeitrag > news:%23Obvka%232KHA.1452(a)TK2MSFTNGP06.phx.gbl... >> "David" <NoWhere(a)earthlink.net> schrieb im Newsbeitrag >> news:eq5LBJ22KHA.1016(a)TK2MSFTNGP02.phx.gbl... >>> !) OK found what was causing the loop: >>> The parameter of RowIsVisible is supposed to be a column I mistakenly >>> put in a Row. >>> >>> This now leaves with some other issues: >>> >>> 1) If I use the Date Column (GRIDC_Date) and select a row that >>> contains the date, I can scroll OK -------- EXCEPT -------- >>> scrolling the active edit row will NOT go above or below the visible >>> bounds of MSFlexGrid. >>> >>> Is this by design? >>> >>> 2) If I use the Date Column (GRIDC_Date) , and select a row where >>> there is NO date in that column everything gets #$%^& up. >>> >>> My guess is somehow the MSFlexGrid is obtaining a pointer to the date >>> value in order to check the cell location and if blank can't handle it? >>> >>> Know anything about this? >>> >> >> >> David, >> >> which Version of Flexgrid are you using? (AFAIK, there are some >> differences >> between Version 5.0 and 6.0) >> >> Helmut. > >
From: Helmut Meukel on 15 Apr 2010 20:02
I started a search for MSFLXGRD.OCX in Windows Explorer and got the list. Then right-clicked on each item in the list, selected Properties, looked up the version # and wrote size and version # on a piece of paper. Old-fashioned, isn't it? <vbg> Helmut. "David" <NoWhere(a)earthlink.net> schrieb im Newsbeitrag news:uRGGwLP3KHA.556(a)TK2MSFTNGP04.phx.gbl... > Thanks Mr. Meukel: > > ReWorked my code and hopefully (??) have it resolved. > > FWIW : > > I'm referring to MSFlexgrid Control 6.0 (SP6). > Not sure where you're getting the size and version # unless directly from > the registered dll as does not show in Components / References in VB IDE. > > I'm also using this with VB5. As I recall, MS had something (quite a few > years back) that allowed you to use upgraded VB6 controls with VB5. (Will have > to dig for this one on my system if of interest to you). Also unknown whether > upgrading to XP, and multiple Service Packs made any upgrades / changes > > Use to try and keep close track of my system, but will all the service packs > / automatic updates etc. etc. hard --or impossible -- to know what M$ is > changing. Gave up on this as would need to hire a full time staff just for > this > > David > > > "Helmut Meukel" <NoSpam(a)NoProvider.de> wrote in message > news:%23w2aMBN3KHA.3844(a)TK2MSFTNGP05.phx.gbl... >> David, >> >> without knowing which version of MSFLXGRD.OCX you are using it's hard >> to answer your questions. >> I just checked on one of my multi-boot systems and found these versions: >> (some with same version number but different dates) >> >> Version Size >> 5.0.37.14 197 KB >> 5.1.43.19 223 KB >> 6.0.81.69 239 KB >> 6.0.84.18 239 KB >> 6.1.97.82 255 KB >> >> So the VB5 version was at least updated once, the VB6 version was at >> least updated twice. I say 'at least' because I can't guarantee I have >> all version on the machine I seached :-) . >> >> Please check what version you are using and if it's an older one then update! >> If the problem still persists or you are already using the latest VB6 >> version, >> then come back to us. >> >> Kind regards >> >> Helmut. >> >> "Helmut Meukel" <NoSpam(a)NoProvider.de> schrieb im Newsbeitrag >> news:%23Obvka%232KHA.1452(a)TK2MSFTNGP06.phx.gbl... >>> "David" <NoWhere(a)earthlink.net> schrieb im Newsbeitrag >>> news:eq5LBJ22KHA.1016(a)TK2MSFTNGP02.phx.gbl... >>>> !) OK found what was causing the loop: >>>> The parameter of RowIsVisible is supposed to be a column I mistakenly put >>>> in a Row. >>>> >>>> This now leaves with some other issues: >>>> >>>> 1) If I use the Date Column (GRIDC_Date) and select a row that contains >>>> the date, I can scroll OK -------- EXCEPT -------- >>>> scrolling the active edit row will NOT go above or below the visible bounds >>>> of MSFlexGrid. >>>> >>>> Is this by design? >>>> >>>> 2) If I use the Date Column (GRIDC_Date) , and select a row where >>>> there is NO date in that column everything gets #$%^& up. >>>> >>>> My guess is somehow the MSFlexGrid is obtaining a pointer to the date value >>>> in order to check the cell location and if blank can't handle it? >>>> >>>> Know anything about this? >>>> >>> >>> >>> David, >>> >>> which Version of Flexgrid are you using? (AFAIK, there are some differences >>> between Version 5.0 and 6.0) >>> >>> Helmut. >> >> > > |