Celt.Max

Hi All! I have 3 tables: test1 id name1 1 value1 test2 id name2 1 value2 test3 id name3 3 value3_01 4 value3_02 I want to display all records of table test1 with values of table test2 (test1.id = test2.id) and values of test3 (if test.id match with test1.id) - …

You put a ^ to say something about the user above you,a < to say something about yourself and a V to say something about who will post below you! ok here goes... ^Nobody.... <Feels left out,but hopes people will play! V will you play?

hi to all, I created following table create table book(id integer, author varchar(20)) In this, each book may have 1 or more authors. My question is that, how can insert more value to author column like as follows. id author 1 pooja merry james 2 robert stephen Thanks & regerds, …

Hi every1 I have 1 problem about read text file Hope every1 help i have 1 text file example :list.txt as 12321 123412 123215 123 1235 Now We read file list and print line by line .Print line 1 after 10 s earse line 1 and print line 2 after …

I have a scary query on MSSQL 2005 here... Got a wiew that returns 2110 rows... and a table of cca 1 500 000 rows. Now, when I run this query [CODE] SELECT TS.col1, TS.col2, count(*) AS Number FROM view_scary VS LEFT OUTER JOIN table_scary TS ON VS.IdContact = TS.IdContact …

Is it possible to make a program using VB where you let people visit a site and get their IP address and use their IP address to click the link which is inside the site they visit? Ex. My site location is: [url]http://www.mysite.com[/url] And this site contain one link name …

Hi guys i'm working on some code whereby the user inputs a distance and time they took spent running for days 1 to 6 and it works fine however I can't get it to display a message box if the user inputs letters instead of numbers. I've had a go …

Hello, I am having trouble figuring out the correct syntax for a small portion of my code. I am trying to have my code search through a column and for each entry in that column copy and paste only the rows that have the following characteristics: the first character = …

Call List3.AddItem(txtname & vbTab & txtamount & vbTab & txtqan & _vbTab & Format$(ans, "Currency")) need help need to align the text the keep displaying like this: toy car 1 $3.00 $3.00 card board box1 $0.50 $0.50 remote control car 1 $3.00 $3.00 cart 1 1 $1.00 $1.00 this is …

How can I get the sum of the numbers of only one textbox? For example text1.text= 1367 How to get the sum of this 4 digit number? I appreciate your assistance in advance. Lida

Hello, I would like to know if there is an easy way to transform the following table CarId | PropertyName | PropertyValue 1 | Size | XL 1 | Name | Porsche 1 | Color | Red 2 | Size | XS 2 | Name | Smart 3 | Name …

Hi, I want to generate an unpredictable random integer number but i dont know how. Below is my function to generate between (1 to 8)which keeps returning '6' on first run which is predicted and also, i dont want the numbers to repeat itself. Private Function RandomIt(Hv As long, Lv …

Hi everybody, I have really damned trouble here... On MSSQL 2000 I have something about 140 log tables with three columns in each one. "ID" AS INT, "SomeTextCODE" AS NVARCHAR(20) and "SomeTime" AS DATETIME I made a view (v_SomeView_ALL) in which there are all these tables united. But some SomeTextCODEs …