Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    value cleared with scroll bar (2000 sr 1)

    But another strong and big...
    My actually prob... simple during the scrollbar if i selct from the useform the button L0785_CDI_50 some value in the column are cleared... (Range column T to X)
    hre the files
    http://www.gssitaly.com/l0785_def_minimum.zip
    http://www.gssitaly.com/prova.zip

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: value cleared with scroll bar (2000 sr 1)

    Sal,
    The XLS file has 5 worksheets, 3 userforms, and 15 modules (most with more than 1 routine).

    Could you post a file with only the relevant "problem" userform and code and not the entire application?

    At the very least could you describe what the symptons of the problem are and walk us thru what to do to "see" the problem after we open the file.

    I have no idea what part of the code is giving the problem or even what macro routine to run.

    Note: this soulnds like a similar problem that you posted in <post#=407904>post 407904</post#>, where you were always clearing textboxes and then updating the records with textbox data. Is that the problem?
    Steve

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: value cleared with scroll bar (2000 sr 1)

    Explain:
    When the wbook is opened is present a yellow button "CERCA".
    If you click on this appear a userform.
    From this userform if you click in the area "SCEGLI DB" and click on L0785_CDI_50 the macro select a sheet L0785_CDI_50 and the table CDI_50 on MDB PROVA. (modify the appropiate path of MDB)
    During the scroling bar with the arrow Down many value in the column range T to X are cleared...
    The sheet L0785_cdi_50 and the table CDI 50 are linked from a routine.
    All code are located in INDIRIZZARIO

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: value cleared with scroll bar (2000 sr 1)

    For Hans and Steve,
    solved this problem "... cleared value during scroll".ecc...
    2 week of strong work...
    Tks always for you...

    I open new post big big big big strong for this project on only for wizard...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •