Search results for query: *

Hello! We want to allow the visitor in our web site sending picture file. Where can i find the applet that offer this service. Thanks Yaakov

Hi you can do it by defining the second form as vbmodal when you load it the code should be: form2.show vbmodal yaakov

Murugesan hi you can limit the number of records by SQL Query for example SELECT TOP 50 COL1,COL2 FROM TABLE1 It will return only first 50 records that answer the query I hope it helps Yaakov

AliBaba hello! If i understand your question the ComboBox gives you the flexibility to add new items into it. All you have to do is ComboBox.AddItem "the item you want to add" You can sort the items by defining the ComboBox sort property to true. Yaakov

TNN Hi! This is the code you should execute, but first change the strCnn to real connection string. Dim cnn2 As ADODB.Connection Dim rstSchema As ADODB.Recordset Dim strCnn As String Set cnn2 = New ADODB.Connection strCnn = "Provider=SQLOLEDB.1;Persist Security...

Hi The sentence: prodRS.ActiveConnection = Con, isn't enough since the ActiveConnection Con isn't open. If you don't want to create connection object, choose one of the options below: 1. Define connection like DSN and use this code prodRS.open sqlString, "DSN=DSN_Name" 2. Use...

Hello! how do you find out what your server name/ path is? we used the following string but it does not work: "driver={SQL Server};Server=(local); uid=sa; pwd=;"_ &"database=orders" what did we do wrong?? thanks, Yaakov from Israel

Hello! I insert into table some records. I wrote it in Hebrew. When i retrieve it i got question marks. I understand that i have to use unicode but how? The INSERT code was INSERT INTO table_name (field1,field2) VALUES ('value1 in Hebrew','value2 in Hebrew') The result to the query...

Help please!!!I need to know how can i get the rgb components from backcolor or forecolor or other given color?Thanks