Search results for query: *

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 &...

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...

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.

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

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?

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

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...

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.

How to find the current cursor position in screen?

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...

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...

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\ ???????

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.

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.

I need suggestion to find value in recorset.... wath is the best: - seek - .find - SQL1 = "SELECT filed FROM table WHERE filed='" & abc & "'" Set RS3 = CN1.Execute(SQL1) If Not RS3.EOF Then ... end if tks. note: i use tipical ado conn and access mdb in c:\....