Search Results - VBForums

Search:

Type: Posts; User: luca90

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Re: web page copy - get value from first and second page

    Hi West! tks! the code work perfect!
  2. Re: web page copy - get value from first and second page

    hi West the code work perfect! tks for tath.
    But i need to get also the value with the arrow-
    for test use the value circled in image attached.
    Tks.
  3. Re: web page copy - get value from first and second page

    tks.
    but i dont know the way to put in the three box the related value of:

    Codice ABI (es.: 03002)
    Codice CAB (es.: 05085)
    Conto corrente:01578

    and press: calcola cin e iban
  4. [RESOLVED] web page copy - get value from first and second page

    http://www.mutuissimo.it/iban-x.asp

    Based this url i need to get all value from the second page when i click, on:calcola cin e iban

    to test use:
    Codice ABI (es.: 03002)
    Codice CAB (es.:...
  5. Replies
    5
    Views
    174

    Re: copy file "one to one"

    TKS, but but i need to lop all files in dir1 and copy one to one in dir2...
  6. Replies
    5
    Views
    174

    copy file "one to one"

    I have 2 dir in c:\
    i need to copy all files, "one to one", from c:\dir1\ to c:\dir2\, and overwrite if in c:\dir2\ just exists the files from dir1.

    is possible, plese simple code.
    tks
  7. Replies
    8
    Views
    261

    Re: GET THE threenewest date in filed

    i'm in Access Database:-)
  8. Replies
    8
    Views
    261

    Re: GET THE threenewest date in filed

    SELECT DISTINCT TOP 3 cassa.[DATA CONT]
    FROM cassa group by cassa.[DATA CONT]
    ORDER BY cassa.[DATA CONT] DESC

    result:
    DATA CONT
    30/07/2014
    29/07/2014
    28/07/2014
  9. Replies
    8
    Views
    261

    Re: GET THE threenewest date in filed

    HUMMMMMMM...

    i dont see the reference to table name.
  10. Replies
    8
    Views
    261

    GET THE threenewest date in filed

    I need to get the top three newest date in filed... hot to with sql?

    example:

    FiledDate
    ...
    31/07/2014
    30/06/2014
    30/05/2014
    31/07/2014
  11. Replies
    3
    Views
    120

    Re: showall in excel sheet

    or just expand any affected rows, but check before if one or more column have an active filter...
  12. Replies
    3
    Views
    120

    showall in excel sheet

    Ho to check if one or more columns have a filter active and if condition is true expand all rows?

    in vba for excel please.
  13. Replies
    6
    Views
    157

    Re: INSERT icon from c:\mydir... in cell

    hummmmmmm....
    i need to loop 8.458 lines, and insert in the existing value of cells the icon on the right.!
  14. Replies
    6
    Views
    157

    Re: INSERT icon from c:\mydir... in cell

    No.
    i have posted a number range but i rially use a string not number....
    But is really possible to insert to right of string in the same cell a icon from path?
    Tks.
  15. Replies
    6
    Views
    157

    INSERT icon from c:\mydir... in cell

    I have a icon (gif) in c:\mydir\icons\ico1.gif

    i need to insert this icon to the right of this value similar:

    ws.Range("AG" & RIGA1).Value = Format(SDO, "#,##0.00")& " "&...
  16. Replies
    3
    Views
    144

    Re: Calculating "Trend" of Agoust 2014

    Simple, have a blank cell in range D2:H2 (E2 and G2 are blank) and D1;H1 (E1 and G1 are blank) this is the formula in J2;=trend($D2:$H2;$D$1:$H$1;$J$1).
    The result in J2 is #VALORE!

    the filled...
  17. Replies
    3
    Views
    144

    Calculating "Trend" of Agoust 2014

    Attached a simple sheet.

    I need to calculate the trend pojection value in column I2 for the Agust 2014 based the month in D1,E1,G1 and values in D2,E2,G2?

    If is possible in vba code, tks.
    ...
  18. Replies
    4
    Views
    168

    Re: run query via batch or shell

    Yes!
  19. Replies
    4
    Views
    168

    run query via batch or shell

    But peraphs stupid question....
    i have a .mdb in c:\mydir\test.mbd
    possible to execute sql query via batch or shell command?
    Tks.
  20. Replies
    3
    Views
    136

    Re: Passing varible from application

    ...variable in a macro
  21. Replies
    3
    Views
    136

    Passing varible from application

    I open a workbook from a click button in a vb6 form with:



    Sub OpenWb(strWorkbook As String)

    On Error Resume Next
    Set WSH = WBK.Worksheets(1)
    On Error GoTo 0
  22. Replies
    4
    Views
    822

    Re: no permit save or save as workbook

    ok work!
    But possoble to show a MSGBOX with a message, to inform the user of limitation?
  23. Replies
    4
    Views
    822

    no permit save or save as workbook

    Ho to vba code to no permit from the user to save or save as workbook?
  24. Thread: synch two table

    by luca90
    Replies
    2
    Views
    358

    Re: synch two table

    relationships???

    how to make that? Have a simple Access just with a relationships, can you attach here? or a link video to use ....?

    tk in other case for suggestion hamza.
  25. Thread: synch two table

    by luca90
    Replies
    2
    Views
    358

    synch two table

    I work with access database, ADO and Vb6 Classic.

    Access database is on C:\mydir\db1.mdb

    On db1 have two identical table.(Table1 and Tabl. Fields name and property fields are the same)
    ...
  26. Replies
    2
    Views
    186

    Re: parameter output

    ????
    Can you modify my code please. Tk.
  27. Replies
    2
    Views
    186

    parameter output

    Dim Myvar as long
    Set CMD = New ADODB.Command
    With CMD
    Set .ActiveConnection = CONN
    .CommandText = "ESTRAI_NUOVO"
    Set PRM =...
  28. Replies
    2
    Views
    142

    COUNT records affected in CDM query

    Set CMD = New ADODB.Command
    With CMD
    Set .ActiveConnection = CN1
    .CommandText = "AGGIORNA_S"
    .CommandType = adCmdStoredProc
    Set RS =...
  29. Re: LISTVIEW FALSE THRUE lost the initial position....

    hummmmmmm....

    setting the listview with Top and Left, after:

    SendMessage Me.ListView1.hWnd, WM_SETREDRAW, True, 0
    ListView1.Visible=True

    but the listview remain out of userform!!!!!!!!!!
  30. LISTVIEW FALSE THRUE lost the initial position....

    To speed up my listview i use:

    ListView1.Visible=False
    SendMessage Me.ListView1.hWnd, WM_SETREDRAW, False, 0

    'code to fill listview

    SendMessage Me.ListView1.hWnd, WM_SETREDRAW,...
  31. Re: i dont see immediately the table copied.... why?

    Finally...i understand
    tKS.
  32. Re: i dont see immediately the table copied.... why?

    OK...
    But via vb6 code is possible to have the same effect of F11 or F5?
  33. Re: i dont see immediately the table copied.... why?

    But i exceute the query code in vb6...
    In effect i have the Access ide in front and vb6 in front, and i dont see the new table, when i exceute the sql!
  34. Re: i dont see immediately the table copied.... why?

    Hi KG.....
    but in my query i dont use RS recordset....(?!)
  35. i dont see immediately the table copied.... why?

    CONN.Execute "SELECT * INTO " & NEW_TABLE & " FROM " & strTableExist & " WHERE 1=0"


    i use this code in vb6 and Ado to copy a table to newtable, all work fine.
    But i dont seel the new table into...
  36. Thread: type field

    by luca90
    Replies
    3
    Views
    151

    Re: type field

    ops.... sorry me, MSAccess!
  37. Thread: type field

    by luca90
    Replies
    3
    Views
    151

    type field

    i need to store a number value with 18 digit, in a field.

    similar:000125479857441117

    wath is the best type of field, txt, integer, long, or?

    note:
    on this field i need also to insert a...
  38. Replies
    3
    Views
    196

    Peraphs stupid qiestion on Email

    Is possible via vb6 code, to intercept an Email before tath go in the Outlook, or other Email programm?

    If Yes, is possible to read all property from the email, similar server sent, id , sender...
  39. Replies
    10
    Views
    289

    Re: set only field with TXT property

    oK ,but for your experince is the best way to use Unicode Compressiono = No or Yes?
    Is really true when use NO the database increase dimension, respet YES?
  40. Replies
    10
    Views
    289

    Re: set only field with TXT property

    tKS, Sam...
    but during you post i have update my question...See, please, about Unicode Compression.
    Sorry me.
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.