Search Results - VBForums

Search:

Type: Posts; User: luca90

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    6
    Views
    160

    Re: autofill combox dinAmiclly

    Tks stum,
    but but the year not is fixed.
    you need to calculate based the year in MyVar
    I can have:
    Ott 2001
    Set 2012
    Ecc...
  2. Replies
    6
    Views
    160

    autofill combox dinAmiclly

    I just have MyVar ="ott 2015" (ott iss the month ottober).
    I need to fill a combo with the rest of months until dec 2015.
    naturally MyVar is dinamicly it can aasume set, feb.... and year.
    how to?
  3. USE KLIKE operator and slect item in listview

    Sub CERCA_IN_COLONNA(VALORE)

    Dim itm As ListItem, K As Long

    K = Empty

    Me.VALORI.Caption = ""
    For Each itm In ListView1.ListItems
    If itm.SubItems(1) Like VALORE Then
    ...
  4. Re: ORDERING/SORT items il listview by cliched checbox

    OK!
    During i fill the lv the code insert a 0 and 1 in hiden Column 18 with zero length..
    now i need to assign in a button a code:

    First click ordering items form 1 to 0, if i reclick order...
  5. ORDERING/SORT items il listview by cliched checbox

    I need to assigng on a button click to order/sort listitems in listview1 by the clicked checkbox...
    Possible?

    note:
    the checkbox is in column 0 of listview
  6. Replies
    16
    Views
    432

    Re: read file lineby line from line 457Th

    To understand...

    i loop in all lines of txt with the tipical freefile=file ... dowhile not ecc....
    then when i fuound in the left 4 of line with MyVar="0900", and admint MyVar="0900" is in line...
  7. Replies
    16
    Views
    432

    Re: read file lineby line from line 457Th

    ok... admit i found MyVar="0900" in lines 456.989 how to loop the rest of line to the end of file from this line?
  8. Replies
    16
    Views
    432

    Re: read file lineby line from line 457Th

    Sorry me to the all!
    Really the line to start the loop not is 457 but 457.xxx...
    This depend when MyVar i filled with a value where is in left 4 of line of text ...

    in this case:

    MyVar...
  9. Replies
    16
    Views
    432

    read file lineby line from line 457Th

    I use the tipcal free file and do while eof ecc.... to read a lines line by line ina txt file.
    is possible to start the reading from line 457 to the end of file, and not from the top of txt file?
    ...
  10. Re: Read A Specific Line From Big Text File

    hI Milk ...
    Sorry if i post on old question.
    Admit my line is the number 457, how to loop the rest of txt file to the end, from this line?

    note:
    Tested the code, is a lightning and work perfect!
  11. Replies
    4
    Views
    205

    Re: value not found in listview

    but i need search directly only in column 3 the value"California"... and not in all item of listview.
    can you change my command button code, for that?
    Tks.
  12. Replies
    4
    Views
    205

    value not found in listview

    Why code in Command2, dont find "California" in column 3?????



    Private Sub Command2_Click()
    Dim oItem As ListItem
    Set oItem = Me.ListView1.FindItem("California", lvwSubItem, 3)
    ...
  13. Re: speed up to delete big numbers of records...

    OK, I know the truncate statment.
    I dont use tath because i dont need to delete alls records in table!
    I need to delete a lot of records with a "Where" clausole.
  14. Re: speed up to delete big numbers of records...

    Tks for suggestion.
    In my case, actually i use Access and ADO conn, but the Mode=Share Exclusive, i can use also in ADO conn with SQlServer connection, or not?
  15. Re: speed up to delete big numbers of records...

    ahhhhhhhhhhhh...
    ok, tks!
  16. Re: speed up to delete big numbers of records...

    ..."should use a transaction", example for Access and ADO?
    Tks.
  17. speed up to delete big numbers of records...

    Dim strConnectionString As String
    Dim objConn As ADODB.Connection
    Dim objCommand As ADODB.Command

    strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=e:\My...
  18. Replies
    2
    Views
    195

    HUGE BIG txt file

    Option Explicit
    Private Sub Main()

    Const BUFSIZE As Long = 100000
    Dim T0 As Single
    Dim LfAnsi As String
    Dim F As Integer
    Dim FileBytes As Long
    Dim BytesLeft As Long
    ...
  19. Re: change background color in cell of listview

    Option Explicit

    Public Const NM_CUSTOMDRAW = (-12&)
    Public Const WM_NOTIFY As Long = &H4E&

    Public Const CDDS_PREPAINT As Long = &H1&
    Public Const CDRF_NOTIFYITEMDRAW As Long = &H20&
    Public...
  20. Re: change background color in cell of listview

    tks for explain.

    really my prob is to insert a icon .gif in a listitems cell of listview but without imagelist component.
    And the ico is in a c:\mydir\ico.gif...
    possible?
  21. change background color in cell of listview

    Possible to change the background color, no text color(i know the way), in a single cell of listview, for example in row6 cell 9?

    note:
    the listview is in a userform of excel project.
  22. Replies
    1
    Views
    105

    summ and check total

    I use vb6 and ado.

    have a Access database.

    2 tables.

    tab1 "ANAGRAF_TOTAL"

    FIELD_INDEX_ID FIELD_TOT FIELDTEST
  23. Replies
    4
    Views
    170

    Re: which checkbox was clicked

    ????
  24. Replies
    4
    Views
    170

    which checkbox was clicked

    I have listview with a checkbox in all rows items.
    i need to know which checkbox was clicked or unclicked, and return a index number of row.
    Possible?
  25. Replies
    4
    Views
    269

    Re: Check format date

    HUMMMM....

    I need to use a IF condition to check format date?

    RESOLVED TKS!
  26. Replies
    4
    Views
    269

    Check format date

    I have the var S="NOV 2014" I need to check if S variable is a date in this format "MMM YYYY", possible ?

    note:
    S as string dimensioned
  27. USE range of cells instead db access - autolist during the typing in text box

    This VB project use access database, but i need to use a cloumn range of sheet in workbook, possible to modify?
    Tks.

    In other case if you have another way, is welcome.
  28. Replies
    2
    Views
    181

    format nember in vba for excel

    I need to format a my number in:

    for example:
    Myvar=1 in MyNewvar=1,00
    Myvar=1,5 in MyNewvar=1,50
    ...

    In all case of Myvar use always two decimal after the decimal point, even if the number...
  29. Replies
    1
    Views
    178

    best price il row of listview

    I have a listview with 7 column

    first 2 column are ID, and ARTICLE

    the column 3 to 7 have a price of ID

    i need to check the best price from the cell item and associate the code in
    ...
  30. Replies
    3
    Views
    237

    delete duplicate row

    In excel sheet have:

    col A col B col C
    AAA 1 0
    BBB 1 0
    AAA 1 0
    AAA 1 0
    ... ecc

    possible to check the 3 colum and delete...
  31. Replies
    3
    Views
    351

    Re: blank space in add item listview

    i know...
    but this line not include the icon:
    Set itmX = .ListItems.Add(, , "TEST")

    this include ico:
    Set itmX = .ListItems.Add(, , "TEST", 1)

    or not?
  32. Replies
    3
    Views
    351

    blank space in add item listview

    part of code:
    ...
    With Me.ListView1
    .ListItems.Clear
    .Icons = Me.ImageList2
    .SmallIcons = Me.ImageList2

    Set itmX = .ListItems.Add(, , "TEST")

    ...
  33. Replies
    3
    Views
    247

    Re: vba for excel and listview property export

    TKX!!!!
    i'm here:-)
  34. Replies
    3
    Views
    247

    vba for excel and listview property export

    I have in a userform 4 listview:

    listview1, listiview2....listview4

    i need to export in a text file the complete structure (column name, lenght, left or right align...ecc) for each listview in...
  35. Replies
    21
    Views
    833

    Re: LOGICAL select case

    hummmmm...
    my actual var PERC=88 ICO return 4?????

    see image.
  36. Replies
    21
    Views
    833

    Re: LOGICAL select case

    should ICO be 1 .... from >=90 and <=100
  37. Replies
    21
    Views
    833

    LOGICAL select case

    i need to set this step of value is correct?

    note: the var MYarray is dimensioned As Long

    MYarray >0 and <=50 then ICO=4
    MYarray >=50 and <=75 then ICO=3
    MYarray >=75 and <=90 then ICO=2...
  38. Replies
    8
    Views
    272

    Re: Convert string in date

    Me.LDAL.Caption = Format(mystring, "DD/MM/YYYY")

    but dont work!
  39. Replies
    8
    Views
    272

    Convert string in date

    i have mystring="31102014"
    how to convert in mydate=31/10/2014
    ????


    note:
    mystring as String
    mydate as Date
  40. Replies
    25
    Views
    929

    Re: [RESOLVED] unpaking .exe file in dir

    little prob...
    not all users have the same path where the winzip32.exe is stored....
    i have see in Google is possible to set automaticlly the Zip path with "namespace" but wath is this?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.