Search Results - VBForums

Search:

Type: Posts; User: luca90

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    6
    Views
    240

    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...
  2. Replies
    6
    Views
    240

    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?
  3. Replies
    6
    Views
    240

    Re: check if file exists in dos batch

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

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

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

    No not have an array of label:-(
  8. [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
  9. Replies
    6
    Views
    240

    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,...
  10. Replies
    4
    Views
    193

    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:
    ...
  11. Replies
    4
    Views
    799

    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 =...
  12. Replies
    4
    Views
    799

    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

    ...
  13. Replies
    6
    Views
    270

    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...
  14. Replies
    6
    Views
    270

    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?
  15. 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
    ...
  16. 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...
  17. 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
  18. Replies
    16
    Views
    497

    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...
  19. Replies
    16
    Views
    497

    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?
  20. Replies
    16
    Views
    497

    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...
  21. Replies
    16
    Views
    497

    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?
    ...
  22. 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!
  23. Replies
    4
    Views
    236

    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.
  24. Replies
    4
    Views
    236

    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)
    ...
  25. 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.
  26. 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?
  27. Re: speed up to delete big numbers of records...

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

    ..."should use a transaction", example for Access and ADO?
    Tks.
  29. 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...
  30. Replies
    2
    Views
    225

    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
    ...
  31. 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...
  32. 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?
  33. 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.
  34. Replies
    1
    Views
    123

    summ and check total

    I use vb6 and ado.

    have a Access database.

    2 tables.

    tab1 "ANAGRAF_TOTAL"

    FIELD_INDEX_ID FIELD_TOT FIELDTEST
  35. Replies
    4
    Views
    202

    Re: which checkbox was clicked

    ????
  36. Replies
    4
    Views
    202

    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?
  37. Replies
    4
    Views
    316

    Re: Check format date

    HUMMMM....

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

    RESOLVED TKS!
  38. Replies
    4
    Views
    316

    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
  39. 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.
  40. Replies
    2
    Views
    209

    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...
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.