Type: Posts; User: luca90
Search took 0.03 seconds.
I have in a listview, column 6 the surname and name in column 7...
possible to order the column 6 or column 7 but maintain the join of surename and name?
not possible concatenete the...
TKS! Work perfect for me also with a very big txt file.
But possible to know wath is the last line number of txt file and return a similar result:
...sLastLineOfFile = sLine & in position: linenr...
But really i can share without problem to 10 users in the same time?
only for reading recordset....
Wath you think about?:
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
I need to share access databse to 10 user on the same lan dir.
I use ADO and Vb6.
the vb6 application permit only to show a records in a listview.
No modify, no update, no delete records ...
I have a sstab1 with 4 tabs.
i need to know wath is the tab index clicked.
Function DoesFieldExist(COD As String, TBLNAME As String) As Boolean
Set RST = CONN.OpenSchema(adSchemaColumns, Array(Empty, Empty, TBLNAME, COD))
If RST.BOF And RST.EOF Then
Possible to intercept the string comand send to server when a button is pressed in a web page?
in the web page are many combobox, and i think when the bottun is pressed the...
why i dont see my label in TAB1!!!!
In effect i dont see the label caption text in tab strip
a free tool to convert vb6 to> vb 2010 express.
i loop a txt file line by line.
i need to check position of string in string line...
for example is use to check "AAABBB" in line string:
if instr(myline,"AAABBB")>0 then
I just have 2 connection in ADO:
conn (for access database)
conn1 (for MYsql with connector MySQL ODBC 3.51 Driver)
Access database have variuos Table(in my case 5)
I need to create the...
i use this code to copy file from server dir to local c:\
With New FileSystemObject
.CopyFile "\\server1\team\Vere.csv", "C:\TABULATI\CSV\Vere.csv", True
Ho to connect with Big Data Google free connection?
i have combo1 in form
and a field named test with:
I need to run an .HTA (vbs script) file via vb6....
no userform have in exe, but a simple Main procedure in a bas module!
In cell of listview have: 67,78
is possible to colorize with a color gradient the cell based the percentage of value?
>50 go to the gradient green color
<50 go to the gradient red color
I have create a simple vb6 project.
I compile it via vb6 ide and return the exe.
I call the exe app at 6.0 a.m. each days in scheduling of my windows XP.
How to terminate the exe app, with the End...
i canot understand you suggestion, can you post a simple project?
I'm very interesting on it!
but i need to check also chr$(10) into the same A string...
This is my little code to check a chr(12) in string
Private Sub CERCA(A)
Dim I As Long
For I = 1 To Len(A)
I need to no permit copy or cut and copy from dir to other dir, how to?
Perticular if the the user copy in Pendrive!
i have this in PERIODO table in field PERIODO:
1 QUAD 2015
1 SEM 2012
1 SEM 2013
1 SEM 2014
1 SEM 2015
1 TRIM 2012
1 TRIM 2013
not completlly understand...
can you modify my code or access param, tks
my test code:
Private Sub PERIODI()
Dim CMD As ADODB.Command, PERIODO As String, PRM As ADODB.Parameter, RS As ADODB.Recordset
PERIODO = "1SEM 2016"
i have this Myvar="12345558889999aaaccc"
i need to replace all cahatcter "a" in string and replace with a blank space.
Dim sFile As StringstrArray
Dim v As Variant, i As Long
sFile = "C:\TABULATI\TABULATI_1.TXT"
Open sFile For Input As #1
sWhole = Input$(LOF(1), 1)
I use this to find value in column:
Set Found_INDEX = WS1.Columns("A:A").Find(What:=TEST, LookIn:=xlValues, LookAt:= _
have 2 combobox
I need to select from field DATA (property date short DD/MM/YYYY) with goup by or with distinct only month and year in this format MM/YYYY and order the result of recordset by desc to have:
... but for a good performance in ADO i use:
but if i use the param with numeric value, similar:
Have the same...
But i'm with listview not listbox...
my actual code:
Dim Z As Integer, I As Integer
Dim NMIN As String, NMAX As String
Dim MYARR() As String
If Me.LVERS.ListItems.Count >= 1 Then
Is possible to run from left to right a progressbar in form untill sub running, and stop wehn done?
i need to insert a clickable link in email body between 2 already string of text:
my code to send email:
Set objApp =...
But to understand, wath is the tips to align txt var to the left or to the right?
tks for suggestion, but not for me.
I have 4 var.
var1, var2, var3, var4.
all var are dimensioned As String.
I need to print in a txt file the value of vars, in this mode:
|val of var1 |val of var2 ...
Click Here to Expand Forum to Full Width
Survey posted by VBForums.