Search Results - VBForums

Search:

Type: Posts; User: luca90

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    7
    Views
    201

    Re: speed to open recordset ado

    OK...
    then:

    RS1.Open SQL, CONN, adOpenForwardOnly, adLockReadOnly

    or not?

    in my case i need only to loop recordset (i use it to fill a listview) and not, update, delete, insert ecc...
  2. Replies
    7
    Views
    201

    Re: speed to open recordset ado

    ... the server

    But i'm on c:\, in local HD and i use Access Databse
  3. Replies
    7
    Views
    201

    speed to open recordset ado

    my conn:

    Set CONN = New ADODB.Connection
    CONN.Provider = "Microsoft Jet 4.0 OLE DB Provider"
    CONN.ConnectionString = "Data Source=C:\DATABASE\STAT.mdb"
    CONN.Open...
  4. Replies
    2
    Views
    172

    Re: lenght of list in combobox

    SORRY for up:o
  5. Replies
    1
    Views
    133

    SUMM in horizontal

    Attached there is the the sheet with a structure of my Access table1.

    I need with a SQL to summ (and with a Where clausole on the first 3 fields), the value from field4 to field8, but in...
  6. Replies
    2
    Views
    172

    lenght of list in combobox

    Why the lenght of list of combobox is out the leght of combobox?
    I see the max character of item in list is only 4!

    During the fill of combobox i Trim all text.

    note:
    the combobox is in a...
  7. Replies
    4
    Views
    165

    Re: ADD field dinamiclly

    TK!

    Now my code is:



    If TFound = False Then
    SQL = "ALTER TABLE " & TBLNAME & " ADD COLUMN " & COD & " LONG"
    CONN.Execute (SQL)
    End If '
  8. Replies
    4
    Views
    165

    ADD field dinamiclly

    I loop a txt file with the tipical free file ecc....

    during the loop of txt i fill a MyVar(As String property) with MyVar=Mid(linestring, 12,4)

    I just have a Ado CONN opened

    In my databse...
  9. Replies
    1
    Views
    151

    insert in row if not exists

    I just have a range B1:Z1 filled with value in cells.

    i have MyVar=AA

    i need to add in the last free cell of range only if AA dont exists in B1:Z1..

    how to in vba?

    Tks
  10. Replies
    6
    Views
    226

    Re: GET only numeric value for string

    I, but example with my data var?
    Tks.
  11. Replies
    6
    Views
    226

    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
  12. Replies
    1
    Views
    153

    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...
  13. Replies
    3
    Views
    279

    Re: loop value in row with concatenate cells

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

    i think col is Long...
  14. Replies
    3
    Views
    279

    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
  15. Replies
    1
    Views
    127

    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...
  16. Loop all elements in userform and enabled to false

    I need to iterate all object in userform and set Enabled to false..
    possible?
  17. 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.
  18. [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?
  19. Replies
    1
    Views
    159

    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.
  20. Replies
    1
    Views
    297

    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.
  21. Replies
    6
    Views
    381

    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...
  22. Replies
    6
    Views
    381

    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?
  23. Replies
    6
    Views
    381

    Re: check if file exists in dos batch

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

    VBA for excel, sorry me.
  25. 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.
  26. Re: for next and increasing label index

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

    No not have an array of label:-(
  28. [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
  29. Replies
    6
    Views
    381

    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,...
  30. Replies
    4
    Views
    280

    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:
    ...
  31. Replies
    4
    Views
    893

    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 =...
  32. Replies
    4
    Views
    893

    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

    ...
  33. Replies
    6
    Views
    306

    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...
  34. Replies
    6
    Views
    306

    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?
  35. 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
    ...
  36. 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...
  37. 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
  38. Replies
    16
    Views
    574

    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...
  39. Replies
    16
    Views
    574

    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?
  40. Replies
    16
    Views
    574

    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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width