Search Results - VBForums

Search:

Type: Posts; User: luca90

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    9
    Views
    221

    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?
    ...
  2. 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!
  3. Replies
    4
    Views
    181

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

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

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

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

    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
    ...
  11. 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...
  12. 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?
  13. 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.
  14. Replies
    1
    Views
    102

    summ and check total

    I use vb6 and ado.

    have a Access database.

    2 tables.

    tab1 "ANAGRAF_TOTAL"

    FIELD_INDEX_ID FIELD_TOT FIELDTEST
  15. Replies
    4
    Views
    159

    Re: which checkbox was clicked

    ????
  16. Replies
    4
    Views
    159

    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?
  17. Replies
    4
    Views
    240

    Re: Check format date

    HUMMMM....

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

    RESOLVED TKS!
  18. Replies
    4
    Views
    240

    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
  19. 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.
  20. Replies
    2
    Views
    171

    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...
  21. Replies
    1
    Views
    165

    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
    ...
  22. Replies
    3
    Views
    214

    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...
  23. Replies
    3
    Views
    301

    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?
  24. Replies
    3
    Views
    301

    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")

    ...
  25. Replies
    3
    Views
    218

    Re: vba for excel and listview property export

    TKX!!!!
    i'm here:-)
  26. Replies
    3
    Views
    218

    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...
  27. Replies
    21
    Views
    773

    Re: LOGICAL select case

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

    see image.
  28. Replies
    21
    Views
    773

    Re: LOGICAL select case

    should ICO be 1 .... from >=90 and <=100
  29. Replies
    21
    Views
    773

    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...
  30. Replies
    8
    Views
    258

    Re: Convert string in date

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

    but dont work!
  31. Replies
    8
    Views
    258

    Convert string in date

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


    note:
    mystring as String
    mydate as Date
  32. Replies
    25
    Views
    877

    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?
  33. Replies
    25
    Views
    877

    Re: unpaking .exe file in dir

    Shell "C:\Program Files\WinZip\winzip32 -e -o \\DIR1\FS\GO\DATABASE\FILE\sportl.exe \\DIR58\FS\GO\DATABASE\CAB_DBF\", vbHide
  34. Replies
    25
    Views
    877

    Re: unpaking .exe file in dir

    resolved my self.... tks to the all!
  35. Replies
    25
    Views
    877

    Re: unpaking .exe file in dir

    yes, is a self extracting archive file then yes you just need to shell it.


    can you post an example to extract in c:\mydir\
  36. Replies
    25
    Views
    877

    Re: unpaking .exe file in dir

    Changed:
    with vb6 classic in with vb6, are you satisfied:-)
  37. Replies
    25
    Views
    877

    Re: unpaking .exe file in dir

    no...
    it contain a simple compressed files.
    Similar: cdd.dbf, Intsall.bat, myico.ico...
  38. Replies
    25
    Views
    877

    [RESOLVED] unpaking .exe file in dir

    I need to extract all files from c:\mydir\Myexe.exe in c:\mydir1\...
    possible with vb6?
    Tks
  39. Re: save .zip file from Ftpo and save in C:\mydir\

    I'm sorry.
    :wave:
  40. save .zip file from Ftp and save in C:\mydir\

    Based this link:ftp://ftp.bper.it/aggiorna/arksport/archivio.zip

    i need to save the .zip file in C:\MYDIR\archivio.zip

    How to in vb6 classic?

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