Search:

Type: Posts; User: sal21; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    3
    Views
    581

    no SQL Manager only code vb6 or vba for excel

    no SQL Manager only code vb6 or vba for excel
  2. Replies
    3
    Views
    581

    I need to export a sql server table in csv, but...

    I need to export a sql server table in csv, but not all filed biut for example:
    filed1,filed5,field9...
    How to?
  3. Replies
    5
    Views
    712

    View Post

    Do you need to copy the table or just the data? ie does the table already exist in the second database?

    - table and the data

    To copy the data you can use two ADO connections.

    Moving through...
  4. Replies
    5
    Views
    712

    How to via vb6 classic or vba for excel... Copy...

    How to via vb6 classic or vba for excel...
    Copy table1 from database1 in sqlserver1 to database2 in sqlserver2?
    note:
    I have user and password trusted in windows login.
  5. Replies
    1
    Views
    441

    Hi use this cod eto have a number of cells in...

    Hi use this cod eto have a number of cells in column.

    dim cella as long
    dim ws4 as worksheet
    Set WS4 = ThisWorkbook.Worksheets("TEST")
    CELLA = WS4.Range("C" & Rows.Count).End(xlUp).Row
    ...
  6. Replies
    5
    Views
    639

    NATURALLY WORK! Tks.

    NATURALLY WORK!
    Tks.
  7. Replies
    5
    Views
    639

    work perfect! sorry but how to calculate...

    work perfect!

    sorry but how to calculate datediff in days between 20100405 and 20100409 ...in this case is 5
    Tks.
  8. Replies
    5
    Views
    639

    I have a var filled with 20100405 is possible to...

    I have a var filled with 20100405 is possible to check if the datae is really a monday?
    Tks.
  9. Thread: find in records

    by sal21
    Replies
    4
    Views
    517

    error: member or method not fiund in line...

    error: member or method not fiund
    in line rs.NoMatch
  10. Thread: find in records

    by sal21
    Replies
    4
    Views
    517

    Correct this part of code to find value in field?...

    Correct this part of code to find value in field?

    .....

    TEST_INDICE = ""
    TEST_INDICE = Trim(Sess0.SCREEN.GetString(P, 22, 3)) & "-" & Trim(Sess0.SCREEN.GetString(6, 46, 9)) & "-" &...
  11. Replies
    2
    Views
    672

    i want to use begintrans,committrans and ...

    i want to use begintrans,committrans and RollbackTrans on access table and ADO.
    But is required rs.update in the code or CommitTrans have the same result of rs.update???

    Private Sub saveclick()...
  12. Replies
    1
    Views
    500

    I get a part of string from a loop in text file...

    I get a part of string from a loop in text file with:
    IMPORTO_OPERAZIONE = Format(Trim(Mid(inString, 88, 24) * 1), "#,##0.000")
    i have dimensioned IMPORTO_OPERAZIONE as double but the code return:...
  13. Replies
    1
    Views
    507

    Have a userform with a cmobobox named Months and...

    Have a userform with a cmobobox named Months and a combobox named Years
    Combobox years is filled with a value: 2010,2011,...2020
    Combobox months is filled with all months
    I need when i select a...
  14. similar: 'Outside your Loop set rst=New...

    similar:

    'Outside your Loop

    set rst=New ADODB.Recordset
    strSQL="SELECT * FROM tblTest "
    rst.Open strSQL,conn, adOpenStatic, adLockReadOnly

    'Then inside your loop after var is set
  15. ok... tks for code. But the var is dinamic.... i...

    ok... tks for code.
    But the var is dinamic.... i fill var from a loop in range in Excel colum.
    If i use your code is required to open and closed recordset each time, or not?
  16. I use in my vb application the tipical ado jet...

    I use in my vb application the tipical ado jet 4.0 conn to Access table.
    Now i have a var filled with "01".
    In the table of my mdb have fields Test and Test1 with a value similar:

    Test Test1
    01...
  17. Replies
    11
    Views
    2,153

    ... but instead to open dialogbox, i know the...

    ... but instead to open dialogbox, i know the name of file, how to set Vfile?
  18. Replies
    2
    Views
    722

    I looping in text file "line by line". During...

    I looping in text file "line by line".
    During the loop i get a part of string line and store it in My_Var (my_var is dimensioned as string).
    Now, i want to save all values of my_var in an array or...
  19. Hi have in c:\my_dir\ many file with .mdb...

    Hi have in c:\my_dir\ many file with .mdb extention file.
    I want to loop in dir c:\my_dir\ and delete the last one file oldest base the actual files are presents in dir.
    How to?

    example:...
  20. Replies
    1
    Views
    702

    I check the file existis in local with a simple...

    I check the file existis in local with a simple script for example if the file is in c:\my_dir\my:file.txt
    But if the file is in \\server_dir\my_file.txt the same code not work, why?
    have a tips.?
  21. Thread: subtract on date

    by sal21
    Replies
    2
    Views
    417

    work! tks.

    work! tks.
  22. Thread: subtract on date

    by sal21
    Replies
    2
    Views
    417

    i have this var DATA_TIPOLOGIA=06/01/2010 how...

    i have this var
    DATA_TIPOLOGIA=06/01/2010
    how to subtract one month and have DATA_TIPOLOGIA=06/12/2009
    note:
    DATA_TIPOLOGIA is dimensioned string
  23. Replies
    11
    Views
    699

    Tks to thr all...!!! Resolaved with one or more...

    Tks to thr all...!!!
    Resolaved with one or more solution in this post.
  24. Replies
    11
    Views
    699

    ... but if i am not wrong, the line code delete...

    ... but if i am not wrong, the line code delete all blank space, or not?
    In effect i want to reduce the number of blank space in one only.
    example:
    if the string contain 4 balnk space reduce the...
  25. Replies
    11
    Views
    699

    I have a variable My_Var dimensioned as strng....

    I have a variable My_Var dimensioned as strng.
    The var can assume value, similar "sal vatore" or "s vatore"....
    I want replace the number of blank space in internal of string with only one...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4