when clic, it should show the equvelant english to the tamil(a language india) wrd

[thangasiva]

I need your help .
i have to develop my knowledge
in‘English words’.
I try to byheart the new words from books, and I am unable to keep
in mind and often forgetting. So I decided to develop a package for
my won use.
It should be like a simple exercise tool.
so that I should practice it
and it should make the words familiar every day
what I have read from books.
for this I have a plan to create a tamizh(my mother tongue, in india) to English dictionary like
program.(not english to thamizh)
This program should perform the following.
1.first it should show a tamizh word in a text box from a limited set
of words (1500).
2. then it should show the equaling word in English in another text
box , only when I click the button . ( In this way I can verify my guessing(by hearted) English word with the
displayed correct word in the text box) .
3. tamil Words should be showed in tamil text box one after one randomly (should not be in sequence, but shuffled)
4. It should repeat the step1 and 2 and endlessly
so that, I can practice the words using the tool and get strong in my
memory through this exercise regularly.
Will this concept be complicated to develop? (For my simple use)
If not yes, please tell me the detail about to create.(both the
logics of the program and required softwares)
I am not able to image how to combine both tamizh and English database)
Or is there any freeware to download to fill these aspects?
Please send me your reply to solve this problem, so that your guide I
can start develop the program.

thanks for reading and thinking

Thanga Siva

[aparnesh]

Your program is not really complicated, but I don't think it ill serve any useful purpose. First, how to do the program

Use any database (Access, Oracle, whatever) you are comfortable with. Create a table (say WORD_TABLE) with 3 columns, "ID" "Tamil_Word" and "English_Word". Each row in the table will contain a Tamil word and the corresponding English translation. Each ID will be Numeric Number and Primary key.

Write a VB program to access the database. From the table, randomly select a Tamil word (You can use the Rand() function to generate a random sequence) whose Id matches the randomly generated number. To see the English equivalent, simply use a SQL like "SELECT English_Word FROM WORD_TABLE WHERE ID = " & <<randomly generated ID >>.

Of course the Tamil words have to be written in English alphabet letters like "Vanakkam", etc. ( I do not know Tamil, just a couple of words)

But considering your ultimate purpose is to be more fluent in English, simply memorising words will be of little or no use. You also have to know in what context such words are used, the correct grammer, sentence structure etc. To learn English, try reading English newspapers and books written in simple language. Some authors like R.K.Narayan use very simple language and such books will be both instructive and simple to understand. If you don't understand any particular word, you can look it up in a Tamil-To-English dictionary.

All the best

[thangasiva]

Very very thanks for giving solutions and advises for my problem.

by the by my main aim is , to acquire and familiarise the action words(verbs) a lot.

but, i have a doubt
can i key in the tamil word in the tamil colum as it is in tamil(letters) if yes how can i add tamil fonts and create colum in a table.
letters should be in tamil when it displayd(not in english letters like v a n a k k a m )
should i add fonts with both vb, and acesss)
sorry i think i am not confusing you.
please help

[aparnesh]

Storing & displaying words using Tamil fonts in a VB program will require a lot of quite high level programming. I don't work in related field so don't really have much knowledge or experience to provide any useful information.

It is possible that there are tools or 3rd party software to help in this problem, but I have no knowledge of any such utility.

[thangasiva]

thank you aparnesh

i have tamil fonts , key board driver(with source code,a freeware)
you can tell any other info about this(any other discussions,sites) as possible
thank you

thanga siva

[thangasiva]

language problem solved by your guidence.
i got free ware from 'Azhagi' it is a tamil unicode tool and it act as a switch between english and tamil, it supports to all windows based applications like word ,excel etc.. before that i set the language settings as you told.
i think i reached half of the problem.
can you give me the script (syntax) and place to written it in a form in ms access 2003.
1. Text box1 should be displayed the value of field1 from table randomly, when I click the command button1.
2. Text box2 should be displayed the value of field 2 of the same record, when I click the command button 2.

thanga siva

[aparnesh]

Do You want to do the program and coding in MS Access 2003 ? Then sorry, I cannot be of any help. MS Access uses VBA (Visual Basic For Applications) for programming and I do not know VBA.

[thangasiva]

ok , no problem if you give me the script and procedure i can it do in vb. please go ahead

thank you

thangasiva

[aparnesh]

Sorry to say, I won't. The purpose of this forum is to HELP a fellow programmer WHEN he is stuck with a problem, NOT to provide coding. You should try writing the program yourself. Of course, I or other users will definitely help you if you are facing any technical problem.
I can provide you with a guideline. Assume you have a table with 3 columns (ID, TAMIL_WORD, ENGLISH_WORD). To randomly select a word, first get the total number of records in the table. You can do that by finding the maximum ID number. Generate a Random number using the Rand function and pass the maximum ID as parameter so that the Random number is generated between 1 and the Max ID.

To obtain the Tamil word for the randomly generated ID, use a SQL statement like
"SELECT Tamil_WORD FROM TableName WHERE ID = " & Random_ID
To get the corresponding English word, use
"SELECT English_WORD FROM TableName WHERE ID = " & Random_ID

Hope you find this useful. Try the program, if necessary look up the help files for syntax etc. If you are still stuck, let us know. Best wishes

[thangasiva]

Sorry to say, I won't. The purpose of this forum is to HELP a fellow programmer WHEN he is stuck with a problem, NOT to provide coding. You should try writing the program yourself. Of course, I or other users will definitely help you if you are facing any technical problem.
I can provide you with a guideline. Assume you have a table with 3 columns (ID, TAMIL_WORD, ENGLISH_WORD). To randomly select a word, first get the total number of records in the table. You can do that by finding the maximum ID number. Generate a Random number using the Rand function and pass the maximum ID as parameter so that the Random number is generated between 1 and the Max ID.

To obtain the Tamil word for the randomly generated ID, use a SQL statement like
"SELECT Tamil_WORD FROM TableName WHERE ID = " & Random_ID
To get the corresponding English word, use
"SELECT English_WORD FROM TableName WHERE ID = " & Random_ID

Hope you find this useful. Try the program, if necessary look up the help files for syntax etc. If you are still stuck, let us know. Best wishes

thank you
but i am really sorry i tried the things in vb(i know that i am not anyl level of programmer...).
i am unable to go ahead after my form. so please... bush me to other steps, closely. where to write it to retrive the data
and to display it.
so..rr..yy

thank you

thangasiva

[aparnesh]

I am sorry, I don't get you. Do you know VB programming ? How to connect to a database and retrieve records etc ? If not, it would be better if you read up on that first.