Search Results - VBForums

Search:

Type: Posts; User: luca90

Page 1 of 13 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    3
    Views
    79

    Re: showall in excel sheet

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

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

    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.!
  4. Replies
    6
    Views
    124

    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.
  5. Replies
    6
    Views
    124

    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")& " "&...
  6. Replies
    3
    Views
    114

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

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

    Re: run query via batch or shell

    Yes!
  9. Replies
    4
    Views
    150

    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.
  10. Replies
    3
    Views
    128

    Re: Passing varible from application

    ...variable in a macro
  11. Replies
    3
    Views
    128

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

    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?
  13. Replies
    4
    Views
    704

    no permit save or save as workbook

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

    by luca90
    Replies
    2
    Views
    345

    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.
  15. Thread: synch two table

    by luca90
    Replies
    2
    Views
    345

    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)
    ...
  16. Replies
    2
    Views
    173

    Re: parameter output

    ????
    Can you modify my code please. Tk.
  17. Replies
    2
    Views
    173

    parameter output

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

    COUNT records affected in CDM query

    Set CMD = New ADODB.Command
    With CMD
    Set .ActiveConnection = CN1
    .CommandText = "AGGIORNA_S"
    .CommandType = adCmdStoredProc
    Set RS =...
  19. 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!!!!!!!!!!
  20. 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,...
  21. Re: i dont see immediately the table copied.... why?

    Finally...i understand
    tKS.
  22. 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?
  23. 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!
  24. Re: i dont see immediately the table copied.... why?

    Hi KG.....
    but in my query i dont use RS recordset....(?!)
  25. 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...
  26. Thread: type field

    by luca90
    Replies
    3
    Views
    143

    Re: type field

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

    by luca90
    Replies
    3
    Views
    143

    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...
  28. Replies
    3
    Views
    166

    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...
  29. Replies
    10
    Views
    262

    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?
  30. Replies
    10
    Views
    262

    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.
  31. Replies
    10
    Views
    262

    Re: set only field with TXT property

    Tks. Sam!

    But really i need to set Unicode Compression=Yes for each fileds in loop, where the type is Txt, possible?
  32. Replies
    10
    Views
    262

    set only field with TXT property

    I have this loop:



    ...
    Set dbs = CurrentDb
    Set tdf = dbs.TableDefs("tab1")

    ' List fields
    For Each fld In tdf.Fields
  33. Replies
    0
    Views
    123

    change UNICODE COMPRESSION in field

    I just have a filed named TEST(txt property) and UNICODE COMPRESSION is setting to Yes.

    I need to change this property in No.

    For test i have this sql:

    SQL = "ALTER TABLE [tab1] ALTER...
  34. Re: ADOX OR ADO... COPY TABLE wiith strucrure and property

    no...
    i need to copy only structure of TAB1 in TAB2, but with all property of fileds(index, lenght, ecc)
  35. Re: ADOX OR ADO... COPY TABLE wiith strucrure and property

    TK FOR REPLY...
    really i work with msAccess.
  36. ADOX OR ADO... COPY TABLE wiith strucrure and property

    I use ADO and vb6 in my project.
    I need to replicate the TAB1 with new table named TAB2.

    i know only this method:
    CONN.Execute "SELECT * INTO " & NEW_TABLE & " FROM " & strTableExist & " WHERE...
  37. Replies
    0
    Views
    128

    COMMANDCOM and recordcount

    ...
    Set CMD = New ADODB.Command
    With CMD
    Set .ActiveConnection = CN1
    .CommandText = "QUERY0"
    .CommandType = adCmdStoredProc
    .Prepared = True
    Set RS...
  38. Replies
    2
    Views
    168

    SIMPLE join and update

    I use a simple sql join (only join tab1,fied1 to tab2.field2) to update a tab1.field3 with value of tab1,fied1...

    Is possible into the same sql string to insert in field3 the value "9999" if the...
  39. Replies
    10
    Views
    270

    Re: insert var date in sql string

    ok! tks for explain.

    But how to complete the sql string with your suggestion?

    correct this for Date1 = 31/12/2014, or not?:
    Dim Date1 As Date
    Date1 = #31/12/2014#

    ......= ' & Date1 &'"
  40. Replies
    10
    Views
    270

    insert var date in sql string

    this is a part of sql string:

    sql" select ecc......= Convert(DATETIME,'01/01/1900',103)"

    now i need to insert in sql string, instead the fixed vlue of date '01/01/1900' a value of date var,...
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.