freeze the Text boxes in the table box......???????

vijay_sr261982
vijay_sr261982 Member Posts: 39
i had desinged a table box , in which an displaying Item Details... is it possible to freeze frist two text boxes ........... I think u can get me...........

Can u give me the tips................

Comments

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    You are referring to the Freeze Panes menu in Excel? This is not possible in Navision. Maybe you can create a matrix-form, if you want to freeze the 2 first columns :-k
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • David_Singleton
    David_Singleton Member Posts: 5,479
    You are referring to the Freeze Panes menu in Excel? This is not possible in Navision. Maybe you can create a matrix-form, if you want to freeze the 2 first columns :-k

    Sure its possible, its standard on the Red List Forms, just set the key and ... um er ohhhh you mean in Windows . #-o well no sorry, that was one of the great features of the DOS version that they removed when they went to Windows.

    (Sorry :whistle: I miss red forms so much :( )
    David Singleton
  • David_Cox
    David_Cox Member Posts: 509
    You cannot freeze the first two coloumns, you can use two table boxes to achive this, but it is not pretty or easy for navigation between the two boxes.
    Analyst Developer with over 17 years Navision, Contract Status - Busy
    Mobile: +44(0)7854 842801
    Email: david.cox@adeptris.com
    Twitter: https://twitter.com/Adeptris
    Website: http://www.adeptris.com
  • kriki
    kriki Member, Moderator Posts: 9,135
    You can use some "dirty" trick:
    In the OnAfterGetCurrentRecord,put
    CurrForm."The Second Field".XPOS := 0;
    CurrForm."The First Field".XPOS := 0;
    

    The user will be able to move the columns, but when the cursor goes to a new record, they will jump back to the first place.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • kine
    kine Member Posts: 12,562
    kriki wrote:
    You can use some "dirty" trick:
    In the OnAfterGetCurrentRecord,put
    CurrForm."The Second Field".XPOS := 0;
    CurrForm."The First Field".XPOS := 0;
    

    The user will be able to move the columns, but when the cursor goes to a new record, they will jump back to the first place.

    I think it is not what vijay_sr261982 wants... 8)

    For me, the solution with two tableboxes is the best one. You just needs to disable focus on them if you do not need to change data there...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    We discussed this a couple of years back. My solution was this :

    http://www.go-live.us/Downloads/Go-Live%20Determine%20Displayed%20Records%2002.zip

    I can't find the original thread though. by the way this solution did not cover the scroll wheel on the mouse.
    David Singleton
  • David_Singleton
    David_Singleton Member Posts: 5,479
    OK, found it, the full thread is here:

    http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=6953
    David Singleton
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Just looking, I found a newer object where I fixed the scroll wheel issue, let me know if you are interested.
    David Singleton
  • vijay_sr261982
    vijay_sr261982 Member Posts: 39
    still i dont get any one ............ is it possible r not .......... [-o< :cry:
  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    @ David: Do you know you can edit your original message if you want to append something later on?
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • kine
    kine Member Posts: 12,562
    still i dont get any one ............ is it possible r not .......... [-o< :cry:

    It is possible, but the way is not straight and without difficulties...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    still i dont get any one ............ is it possible r not .......... [-o< :cry:

    Yes its possible.
    David Singleton
  • David_Singleton
    David_Singleton Member Posts: 5,479
    @ David: Do you know you can edit your original message if you want to append something later on?

    Sure, but I only normally edit, if there is an actual mistake in the post, or a typo. Or if I can add something within 5-10 minutes. If you go back and add information to a post after 2 hours, then someone could have already read the original post, and they don't see the added information.
    David Singleton