Type: Posts; User: luca90
I need to group by a field values in field1 from table1 and insert result into an existing table2 same name of field, how to?
i just use ado and vb6 classic.
TKS! WORK PERFECT.
i need to transform a negative number in normal numnber, how to update?
I have in table field AMONT and field SIGN
in AMONT i can have:
But now if i wauld to use a ">" operator i need a particular set of variable, or i can use a simple expression:
if t2>t1 the stop
i not completlly understand, sorry.
dim t1 as date, t2 as date
dim Hour_Diff as date
i need to have a diff in hours and minutes from this two time and store result in var Hour_Diff .... how to?
example diff time from 00.12 and 14.45
return the result in HH.MM format
I have tested your link, and work perfect...
but i need to get, via vb6 code, the value in the box: Distance by Land Transport :
in effect i put, via vb6 code, in the...
Peraphs solved with the link:
this site calculate the distance from 2 Zip code(CAP in Italy), in Route Km and Direct line on air.
First tkx to the all!
But all my requet are only for Italy zip code and city. I dont need other country.;-)
but the lDistance result is in miles, meters, km... or?
Sorry Tyson... is for Rhinobull:-)
I need to calculate distance in Km from zip code to zip code...?
Suggest me a method iin vb6.
I need to loop all items in sub folder SERVIZIO and delete items where the revived date is oldest based the current month date...
...recived date: 25/10/2013<delete
...recived date: 05/11/2013...
I use Vb6 classic and ADO.
I need to insert via sql a null value in filed, wath is the correct mode?
Peraphs for rs.field("TEST").value:
But that tips (absolute position) return the rs value?
If yes, how to assign to MyVar?
I group by a dates in field DATA1 from TABLE1 in Access database.
Now i would to get, directlly the fourth value from the filtered dates.
Actually i use:
Do Wile not rs.eof
I have in filed DATA! this values:
in chunks (whatever size suits)?????
Code example please?
I have tested a various code to store the file in array and then loop it from bottom to the top and read line with a for next -1, or tested a lbound to unbound ...
But all codee tested...
... from bottom to top?
adding new notice, the file is arround 156 mb.
READ backward A very, very BIG FILE TXT (approx 6.000.xxx of lines) , how to?
Wath is wrong in my code to count only
a *.txt files?
Dim filesys As Object, DataFolder As Object, DataFiles As Object, NumberOfFiles As Long
Set filesys =...
last used cell in a closed workbook... no ADO please, only vba code
I use vb6 classic and ADO.
I just have a conn MyConn opened.
I use Access 2003.
I need to check if MyTable exists and then delete it.
I have an active workbook with sheet named "TEMPLATE".
in this workbook have a useform named "FORM1".
i need to save as workbook the sheet "TEMPLATE" in c:\mydir\, but with the useform named...
... just a NO for the filed VERS_L0785.TIP = "P7" if the WHERE clausole dont "match"
sorry but not for me:-)
UPDATE VERS_L0785 INNER JOIN TOT_ASSEGNI ON (VERS_L0785.CHIAVE = TOT_ASSEGNI.OPERAZIONE) AND (VERS_L0785.SPORT_OP = TOT_ASSEGNI.AGENZIA_OP) AND...
...TIP = "P7"...
this is the field updated in a UPDATE query.
Is possible to insert instead "P7" the value "NO" if the matched condition in the UPDATE not is true?
I need to loop the column O (untill null value in column A) and if in the column O is present the value "new" colorize the font in cells range A:O in red and make it bold.
How to in vba for exel?
but the for next is just in a sub.
i need to reloop only the for next
Dim i As Long
Dim i As Long
For i = 0 To 10
'here the code to reloop the for next when i>10 or the for next is finished
I use a Jet JRO code to compact and reapair Access database located in C:\MYDIR\MYDB.MDB.
Naturally if the database is just opened in edit mode the code go in error..."database is just opened from...
I need to calculate the simple MEDIA only for value in column D if in column B ="c", put the rseult in cell H30....
actually in cell H30 is a simple MEDIA without to consider "c"...
I just use vb6 classic and ADO jet 4 to open a connection with access database in \\server\mydir\test.mdb
i need a sugestion to open table1 to use rs.addnew and rs.update with the max speed to...
in c:\mydir\ have approx 12 13 .txt file...
i need to join all .txt from c:\mydir\ in one big .txt file named BIG.txt in the same dir...
sorry for up:wave:
with ADOX, please...
i have Mytable with this fields:
i need to move the filed F3 in first position of fileds list, i need this result:
I just have a table1 with a fileds.
exists a method to create, via vb6 code, a primary key with auto number in table1?
i use vb6 classic and ADO jet 4