Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sal0003
  • Order by date
  1. sal0003

    DAO performance speed up query selection

    hI TheAceMan1, tks for suggestion.
  2. sal0003

    DAO performance speed up query selection

    Is this correct to speed up DAO query with vb6 cvlassic?:_ my connection: Public Sub APRI_CONNESSIONE_DAO(MIO_DB) On Error GoTo Err_SomeName Dim strDBName As String strDBName = "C:\REPORT_L\DATABASE\" & MIO_DB & "-L_TEST.mdb" 'strDBName = "E:\REPORT_L\DATABASE\" & MIO_DB &...
  3. sal0003

    ORDER AND LOOP files in dir

    Bob, i cannot rename... the file (all part of my project point on the actuall name of txt file)...
  4. sal0003

    ORDER AND LOOP files in dir

    I have adir c:\miadir\ with this type of files: aa.mdb ff.doc TEST_01-09-2011.TXT TEST_02-09-2011.TXT TEST_02-11-2011.TXT TEST_03-10-2011.TXT TEST_04-10-2011.TXT TEST_05-09-2011.TXT TEST_05-10-2011.TXT TEST_01-09-2011.TXT TEST_02-09-2011.TXT TEST_02-11-2011.TXT TEST_03-10-2011.TXT...
  5. sal0003

    loop all my session and add in listbox

    I need to loop all my sessions and add the related name in a combobox only for the Extra screen session in position of screen 9,21 are the word: ENTER APPLICATION... I hope i'm clear. Naturally in vb 6.0 code. Tkx.
  6. sal0003

    suggest and strategy to read 2.600.000 in a txt file

    I need to loop all lines "line by line" in a text file wath is the best strategy and suggestion to do it? Note: I use VB6 classic
  7. sal0003

    work with 2 sessions

    TKS!!!! Skip.
  8. sal0003

    during the code digit....

    When i use the Extra object in vb code similar sess0. ecc... when, i write sess0 i digit the dot why the ide dont show the possible object disponible from sess0?
  9. sal0003

    work with 2 sessions

    I need to work with 2 session from the same macro code in vba for excel... is possibble? Tks.
  10. sal0003

    FILL ARRAY WITH NO DUPLICATE VALUE

    I need to insert into array a unique value based a date I loop with the for next a value date. All value are date in this format dd/mm/yyyy hh:mm for example: ... 03/02/2001 12.14 01/01/2001 12.23 01/01/2001 05.11 03/02/2001 06.11 01/01/2001 03.10 ... i need to fill array only with the value...
  11. sal0003

    Exctrract only number in string

    Trovati : 9 - Records i have this string in a var MyString I need to extract only the number from ":" and "-" in this case is 9 But the length of number is dinamic, i can have: Trovati : 249 - Records Trovati : 149 - Records Trovati : 145879 - Records How to? Tks.
  12. sal0003

    find cursor position

    How to find the current cursor position in screen?
  13. sal0003

    link and sysncronize two table in different database

    I have a sql server table named TABLESQL. I have access database in c:\mydir\MYACCESSDB.mdb and a table named TABLEACESS I just have active connection with adojet from the two database:sqlconn and accessconn The two table have exactly the same names and numbers of fields. My prob is...
  14. sal0003

    create a linking dinamiclly from two table in access mdb

    I have a data base on sql server (i have permission only to read this database) and a access database on c:\ and a table1 with the same fileds and struccture of sql table. Is possible to make a dinamic link from the two table in this mode,Similar: new recordset added in sql table, add the new...
  15. sal0003

    calling query on access remote server

    I use vb6+ado to interact with access database on \\myserver\mydir\db.mdb In the accees database have saved many querys. Is possible to calling "query1" via vb6+ado directly on the access databse in \\myserver\mydir\ ???????
  16. sal0003

    urgent please! getting complete name of account NT server

    I know the name of Domain on NT platform is, "MY_Domain_name". I know the username, is "OU458778". Is possibile to know the complete name of username???? With vb6, please.
  17. sal0003

    delete a milion of records ado + vb6

    in other case the drop option is reserved for Sql Server or not?
  18. sal0003

    delete a milion of records ado + vb6

    please i'm a new bie.... example code? tks
  19. sal0003

    delete a milion of records ado + vb6

    I use the tipical ado jet con and vb6 code. I have an access table with approx 4.500.000 records in 43 fields. All field are filled with value. I use the delete * from table ecc.... but sure the code is very very slow... Suggestion please to make a fast way to delete. tks.

Part and Inventory Search

Back
Top