Search Results - VBForums

Search:

Type: Posts; User: luca90

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Re: get part of string but only number in braket

    debug.print Mid("0103-(5.048)-DDD6", 7, InStr("0103-(5.048)-DDD6", ")") - 7)

    study and googling... wath u think about
  2. get part of string but only number in braket

    0103-(5.048)-DDD6
    0101-(6.155)-BBB
    0146-(9.677)-DD
    0149-(12.039)-FFF
    0143-(12.949)-AAAAA
    0100-(26.867)-AAA9
    0102-(40)-CCCT
    0143-(149)-ZZZ

    i need, for example, from the first line:
  3. Re: REPRESENT graph/PIE in form based result of query

    tks, bro...but i'm sorry
    i need in a userform of vba for Excel project
  4. REPRESENT graph/PIE in form based result of query

    Query2 extract a value from table Access and ADO.
    First column is month second num of transaction.

    How to represent a graph/pie in form where X is the month and Y the number of transaction by...
  5. VERSION of exe application on c:\mydir\app.exe

    i use this to know the version of my app:

    version= "VER. " & App.Major & "." & App.Minor & "." & App.Revision

    but is possible to know the same info from \\landir\dir1\app.exe

    ???

    tks
  6. LINK access table to SQL SERVER Express 2008

    I know the way to link Sql Server table to Access Database, but the reverse is possible via vb6 CODE?
    In effect i need to link access table to Sql Server Instance of Sql Server Express 2008.
    Tks.
  7. Replies
    1
    Views
    141

    add ico in combobox items

    I need to add icon from imalist in items of combobox.
    i have used:



    With COD_OU
    .Clear
    Do Until RS1.EOF
    OPERATORE = RS1.Fields(0).Value & "-(" &...
  8. Replies
    0
    Views
    82

    ADO 2.8 and Replace function

    I use vb6 and ado and access database.

    I have "googoling" and read in variuos location that:

    ADO 2.8 not support Replace Function in sql Query, possible?

    If yes, how to modifiy this piece of...
  9. Replies
    2
    Views
    138

    How to fix "error dll"

    Attached image of the popup error when press pf5!

    How to fix and how to intercept the dll in error?

    note:
    i use VB6 with all sp installed

    tks.
  10. Replies
    10
    Views
    316

    Re: FILE COPY with big file

    tks.

    but very very slow, in other case
  11. Replies
    10
    Views
    316

    FILE COPY with big file

    I need a fast file copy, and ovewrwrite existing file, from \\serverdir\ to c:\test\

    the dimension of file approx 254.000 MB

    tks
  12. Re: tooltiptext on header of column in listview

    no.
    listview, please.
  13. tooltiptext on header of column in listview

    Possible to have a tooltiptext on header name of column in listview in a vba userform?

    i use vba for excel.
  14. Replies
    7
    Views
    248

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

    Re: speed to open recordset ado

    ... the server

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

    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...
  17. Replies
    2
    Views
    247

    Re: lenght of list in combobox

    SORRY for up:o
  18. Replies
    1
    Views
    163

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

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

    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 '
  21. Replies
    4
    Views
    186

    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...
  22. Replies
    1
    Views
    167

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

    Re: GET only numeric value for string

    I, but example with my data var?
    Tks.
  24. Replies
    6
    Views
    251

    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
  25. Replies
    1
    Views
    159

    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...
  26. Replies
    3
    Views
    297

    Re: loop value in row with concatenate cells

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

    i think col is Long...
  27. Replies
    3
    Views
    297

    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
  28. Replies
    1
    Views
    135

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

    I need to iterate all object in userform and set Enabled to false..
    possible?
  30. 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.
  31. [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?
  32. Replies
    1
    Views
    170

    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.
  33. Replies
    1
    Views
    315

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

    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...
  35. Replies
    6
    Views
    405

    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?
  36. Replies
    6
    Views
    405

    Re: check if file exists in dos batch

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

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

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

    No not have an array of label:-(
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width