Type: Posts; User: luca90
Search took 0.05 seconds.
debug.print Mid("0103-(5.048)-DDD6", 7, InStr("0103-(5.048)-DDD6", ")") - 7)
study and googling... wath u think about
i need, for example, from the first line:
tks, bro...but i'm sorry
i need in a userform of vba for Excel project
Query2 extract a value from table Access and ADO.
First column is month second num of transaction.
How to represent a graph/pie in form where X is the month and Y the number of transaction by...
i use this to know the version of my app:
version= "VER. " & App.Major & "." & App.Minor & "." & App.Revision
but is possible to know the same info from \\landir\dir1\app.exe
I know the way to link Sql Server table to Access Database, but the reverse is possible via vb6 CODE?
In effect i need to link access table to Sql Server Instance of Sql Server Express 2008.
I need to add icon from imalist in items of combobox.
i have used:
Do Until RS1.EOF
OPERATORE = RS1.Fields(0).Value & "-(" &...
I use vb6 and ado and access database.
I have "googoling" and read in variuos location that:
ADO 2.8 not support Replace Function in sql Query, possible?
If yes, how to modifiy this piece of...
Attached image of the popup error when press pf5!
How to fix and how to intercept the dll in error?
i use VB6 with all sp installed
but very very slow, in other case
I need a fast file copy, and ovewrwrite existing file, from \\serverdir\ to c:\test\
the dimension of file approx 254.000 MB
Possible to have a tooltiptext on header name of column in listview in a vba userform?
i use vba for excel.
RS1.Open SQL, CONN, adOpenForwardOnly, adLockReadOnly
in my case i need only to loop recordset (i use it to fill a listview) and not, update, delete, insert ecc...
... the server
But i'm on c:\, in local HD and i use Access Databse
Set CONN = New ADODB.Connection
CONN.Provider = "Microsoft Jet 4.0 OLE DB Provider"
CONN.ConnectionString = "Data Source=C:\DATABASE\STAT.mdb"
Attached there is the the sheet with a structure of my Access table1.
I need with a SQL to summ (and with a Where clausole on the first 3 fields), the value from field4 to field8, but in...
Why the lenght of list of combobox is out the leght of combobox?
I see the max character of item in list is only 4!
During the fill of combobox i Trim all text.
the combobox is in a...
Now my code is:
If TFound = False Then
SQL = "ALTER TABLE " & TBLNAME & " ADD COLUMN " & COD & " LONG"
End If '
I loop a txt file with the tipical free file ecc....
during the loop of txt i fill a MyVar(As String property) with MyVar=Mid(linestring, 12,4)
I just have a Ado CONN opened
In my databse...
I just have a range B1:Z1 filled with value in cells.
i have MyVar=AA
i need to add in the last free cell of range only if AA dont exists in B1:Z1..
how to in vba?
I, but example with my data var?
i can have in MyVar (As String):
i need to get only the numeric value from string?
1) The letter are always on right of string
I need to loop all .xls files from c:\mydir\
and open "one to one", get data from column, close it, and open the next always from the same dir.
Or loop all closed xls file without open...
But i dont see the dim of var firstempty
i think col is Long...
I need to loop value in row 2 until cell in row from G1 is blank... in my case AA1 is blank
i need to use a Where clausole, in a Select query, where numbers years is <= 20 and >=90 based of birthday day
my filed name is NASCITA with date property.
My test sql:
I need to iterate all object in userform and set Enabled to false..
exactlly wath i need!!!!!!!!!!!!!!!!!
sorry for my dab english, but i think u undesrtand me.
I loop all items in a listview column.
each item have a different color font.
is possible to retrive the value of single color font of items?
i need to assign to click botton this code line, and execute it:
"C:\Program Files\Microsoft Office\Office14\MSAccess.exe" "\\rom\workarea$\FSR\Ge\DATABASE\T1.MDB" /compact
Instaed to use data in column sheet, possible to arrange code to use the data in a column Listview.
The reference title column and data are exactlly wath i have in column of my listview.
... can you show an example of the command line for running a query
simple update query, but with 2.000.000 on join to other table with approx 4.000.000 of records
... Also, why do you even...
but, after compacing the database, i need to run a query named Query_001, into the same database.
is possible to insert into the batch file a dos command line for that?
sorry for delay.
Yes are labels....
changed Dim lbl As Label in Dim lbl As object and work great!
Tks. for code.
>>>>Set lbl = Controls("C" & y) ERROR RUNTIME 13!!!"
No not have an array of label:-(
Click Here to Expand Forum to Full Width