Search Results - VBForums

Search:

Type: Posts; User: luca90

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    4
    Views
    111

    Re: run query via batch or shell

    Yes!
  2. Replies
    4
    Views
    111

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

    Re: Passing varible from application

    ...variable in a macro
  4. Replies
    3
    Views
    113

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

    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?
  6. Replies
    4
    Views
    492

    no permit save or save as workbook

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

    by luca90
    Replies
    2
    Views
    320

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

    by luca90
    Replies
    2
    Views
    320

    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)
    ...
  9. Replies
    2
    Views
    156

    Re: parameter output

    ????
    Can you modify my code please. Tk.
  10. Replies
    2
    Views
    156

    parameter output

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

    COUNT records affected in CDM query

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

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

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

    by luca90
    Replies
    3
    Views
    128

    Re: type field

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

    by luca90
    Replies
    3
    Views
    128

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

    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...
  22. Replies
    10
    Views
    232

    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?
  23. Replies
    10
    Views
    232

    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.
  24. Replies
    10
    Views
    232

    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?
  25. Replies
    10
    Views
    232

    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
  26. Replies
    0
    Views
    117

    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...
  27. 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)
  28. Re: ADOX OR ADO... COPY TABLE wiith strucrure and property

    TK FOR REPLY...
    really i work with msAccess.
  29. 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...
  30. Replies
    0
    Views
    115

    COMMANDCOM and recordcount

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

    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...
  32. Replies
    10
    Views
    250

    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 &'"
  33. Replies
    10
    Views
    250

    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,...
  34. Replies
    0
    Views
    142

    teradata passowrd expired

    I use this string to connect Teradata database:




    UserName = "USER1"
    userpwd = "N2013"

    Set CONN = New ADODB.Connection
    With CONN
  35. Replies
    2
    Views
    163

    Re: Error when open recordset postgresql

    NO!
    Sure the table exist!
  36. Replies
    2
    Views
    163

    Error when open recordset postgresql

    Ops...
    first experiment with Postgresql, error here:

    RS.Open "Select COD from CODICI", CN, adOpenDynamic, adLockReadOnly, adCmdText

    code:


    Sub TEST_CONN()
  37. Replies
    0
    Views
    124

    Create dsn programmaticlly

    I need to create via VB6 classic an Access DSN based a database in \\mylan\dir1\mymdb.mdb, but check before to create the new DSN if just exists the same access database from the same dir......
  38. SUGGEST to get min max date from txt string

    I use the tipical free file eof .... to read line by line a txt file.

    During the loop a get in a mid postion of string a date form each lines and store the date value it in mYDate var.

    How to...
  39. Replies
    8
    Views
    566

    Re: CURSOR lock!!!!! WHEN READ TXT

    exactlly the same prob, cursor lock on Line Input #File, TextOfLine...

    after 8 mins on lock cursor line have this error:

    error run time 14
    "space of string is out"

    perpah the lines in txt...
  40. Replies
    8
    Views
    566

    Re: CURSOR lock!!!!! WHEN READ TXT

    If this is VBA for Excel...
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.