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.
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 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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.