Search Results - VBForums

Search:

Type: Posts; User: luca90

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    6
    Views
    189

    Re: GET only numeric value for string

    I, but example with my data var?
    Tks.
  2. Replies
    6
    Views
    189

    GET only numeric value for string

    i can have in MyVar (As String):

    576A
    2000B
    45G

    i need to get only the numeric value from string?

    Note:
    1) The letter are always on right of string
  3. Replies
    1
    Views
    103

    loop in dir and read cells in workbook

    I need to loop all .xls files from c:\mydir\

    and open "one to one", get data from column, close it, and open the next always from the same dir.
    How to?
    Or loop all closed xls file without open...
  4. Replies
    3
    Views
    241

    Re: loop value in row with concatenate cells

    OK. tKS
    But i dont see the dim of var firstempty

    i think col is Long...
  5. Replies
    3
    Views
    241

    loop value in row with concatenate cells

    I need to loop value in row 2 until cell in row from G1 is blank... in my case AA1 is blank
  6. Replies
    1
    Views
    114

    WHERE with year birtday conditio

    i need to use a Where clausole, in a Select query, where numbers years is <= 20 and >=90 based of birthday day

    my filed name is NASCITA with date property.

    My test sql:

    ...WHERE...
  7. Loop all elements in userform and enabled to false

    I need to iterate all object in userform and set Enabled to false..
    possible?
  8. Re: Getr value of color font in listview item

    perfect!
    exactlly wath i need!!!!!!!!!!!!!!!!!

    sorry for my dab english, but i think u undesrtand me.

    tkx.
  9. [RESOLVED] Getr value of color font in listview item

    I loop all items in a listview column.
    each item have a different color font.
    is possible to retrive the value of single color font of items?
  10. Replies
    1
    Views
    150

    SHELL execute via code

    i need to assign to click botton this code line, and execute it:

    "C:\Program Files\Microsoft Office\Office14\MSAccess.exe" "\\rom\workarea$\FSR\Ge\DATABASE\T1.MDB" /compact

    how to?
    Tks.
  11. Replies
    1
    Views
    287

    Listview and graph chart

    Instaed to use data in column sheet, possible to arrange code to use the data in a column Listview.


    The reference title column and data are exactlly wath i have in column of my listview.

    Tks.
  12. Replies
    6
    Views
    360

    Re: check if file exists in dos batch

    ... can you show an example of the command line for running a query
    simple update query, but with 2.000.000 on join to other table with approx 4.000.000 of records


    ... Also, why do you even...
  13. Replies
    6
    Views
    360

    Re: check if file exists in dos batch

    hummm....
    but, after compacing the database, i need to run a query named Query_001, into the same database.
    is possible to insert into the batch file a dos command line for that?
  14. Replies
    6
    Views
    360

    Re: check if file exists in dos batch

    sorry for delay.
    work perfect!
    Tkx
  15. Re: for next and increasing label index

    VBA for excel, sorry me.
  16. Re: for next and increasing label index

    Yes are labels....

    changed Dim lbl As Label in Dim lbl As object and work great!
    Tks. for code.
  17. Re: for next and increasing label index

    >>>>Set lbl = Controls("C" & y) ERROR RUNTIME 13!!!"
  18. Re: for next and increasing label index

    No not have an array of label:-(
  19. [RESOLVED] for next and increasing label index

    i use this for next:

    for y=1 to 3

    'here i need to increasing the index of label C...

    Me.C"here insert the actual value of y).Caption

    next y
  20. Replies
    6
    Views
    360

    check if file exists in dos batch

    this line is in batch file and compact and repair an access database:

    "C:\Program Files\Microsoft Office\Office14\MSAccess.exe" "\\rom\DATABASE\GIA.MDB" /compact

    But is possible to check,...
  21. Replies
    4
    Views
    265

    GROUP by with a split string...

    ...GROUP BY Split(VER.MER, '-')(1)

    is a part of my SQL, in vb6

    but have error!
    I need group by with thw split of field VER.MER, with the 2Th part of the split function..
    for example:
    ...
  22. Replies
    4
    Views
    880

    Re: loop only unique value

    Wath you think about:


    Option Explicit
    Sub ELIMINA_DUPLICATI_IN_ARRAY()

    Dim I As Long, intItems, arrItems, strKey, objDictionary As Object, strItem

    Set objDictionary =...
  23. Replies
    4
    Views
    880

    loop only unique value

    I just have an Array filled from recordset similar:

    Set RS1 = New ADODB.Recordset
    RS1.CursorLocation = adUseClient
    RS1.Open SQL, CONN, adOpenStatic, adLockReadOnly, adCmdText

    ...
  24. Replies
    6
    Views
    298

    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...
  25. Replies
    6
    Views
    298

    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?
  26. 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
    ...
  27. 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...
  28. 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
  29. Replies
    16
    Views
    561

    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...
  30. Replies
    16
    Views
    561

    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?
  31. Replies
    16
    Views
    561

    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...
  32. Replies
    16
    Views
    561

    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?
    ...
  33. 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!
  34. Replies
    4
    Views
    247

    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.
  35. Replies
    4
    Views
    247

    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)
    ...
  36. 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.
  37. 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?
  38. Re: speed up to delete big numbers of records...

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

    ..."should use a transaction", example for Access and ADO?
    Tks.
  40. 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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width