Records Should Be In Tamil Letters (a Language In India) And English When Displyed

Apr 12, 2007

hi this is my problem.
there are three columns should be created in a table.
the first column should be in tamil (a language in india)
the second and third columns should be created in english
can i keyin the tamil words in the 'tamil' column of a table if yes how please?
can i fetch the records from that table (first column in tamil and second column in english)same time.
if yes ,please how?
if any tools needs, tell me what are the all other tools needed and how can be added with ms-access and iam also using vb (as front end)

my aim is , the letters should be in tamil and english when it displayed.

will it be complicated ?

please help

Thanga siva

View Replies


ADVERTISEMENT

Records Should Be In Tamil Letters (a Language In India) And English When Displyed

Apr 15, 2007

hi this is my problem.
there are three columns should be created in a table.
the first column should be in tamil (a language in india)
the second and third columns should be created in English
can i keyin the tamil words in the 'tamil' column of a table if yes how please?
can i fetch the records from that table (first column in tamil and second column in english)same time.
if yes ,please how?
if any tools needs, tell me what are the all other tools needed and how can be added with ms-access and i am also using vb (as front end)

i have both fonts and key bord driver for tamil fonts (freeware)

my aim is , the letters should be in tamil and english when it displayed.

will it be complicated ?

please help

Thanga siva

View 2 Replies View Related

Getting First Letters Of Records

Nov 21, 2005

hello
I have a access DB with several names in a table. I need to get only the first letter of each name, but only one for each A, B, C, etc. For example, if I have 3 names starting with a A and 5 starting with the C, it will give me only 2 records, one with the letter A and other with the letter C. I'm using ASP with access database.

tks for the help.
Sneakky

View 11 Replies View Related

Name Of The Month In English

Jun 23, 2005

My problem: I work on a German machine (i.e. the regional settings are set for Germany) but have created reports in Access where the name of the month needs to appear in English. Is there a way to do this without monkeying with the regional settings?

Thanks in advance...

View 7 Replies View Related

US English Date Problem

Feb 14, 2007

Hi All

I’m fairly new to Access so forgive me if this is a newbie question.

Access 2003 SP2
Excel 2003 SP2
Keyboard English UK

I have a software package that produces an Excel sheet with the date displayed as follows in the Created At column “02/18/2007 @ 03:53pm” the field is in text format. I’m not interested in the time stamp so I have a query in Access to strip out the text I am interested in Query “Date_US: Left([Created At],10) “
This gives me the date but its still in text format, my problem is if I change it to be date it stores the date incorrectly. For example 02/05/2007 is changed to 2nd of May when it’s really the 5th Feb not until the day is above the number of months does it display it correctly. I understand why it is doing this but don’t know how to correct it.

Any help greatly received

Steve

:confused:

View 4 Replies View Related

List Of Access Terms In English?

Apr 13, 2007

Thanks to the the Smart Questions tips, I'm skipping this:

PLEASE HELP ME OMIGOD I'M GONNA DIE! ACCESS IS ALL BUGS! IS MY MUTHABORD CRAKT? PLEASE EVERYBODY COME TO MY HOUSE NOW AND SAVE MY AZZZ!

but proceeding with something worse:


Where is there a table of Access terms defined in English?


I've got a primitive database set up, on potential customers. 2 huge tables, a query, and a form that's worked for inputting background info and contact reports.

Problem: my user interface is in German. I'm trying to educate myself out of trouble fast, which I need to do in my native English. Abfrage = Query seems intuitive enough, but even that hurt.



I don't even have the vocabulary for searching halfway intelligently in English.

One key thing I'm trying to figure out is how to get data entered from the form as checked boxes (each referring back to one of ca 25 yes/no columns in a table) to spit out on a printed page as words separated by commas, like

End markets: gravymakers, applecart drivers, psychiatrists

To find where this is already addressed, I have to figure out what it's all called. Searching in German almost split my skull. I've already written the content in German, I've been screamed at in German, and when the co. refuses to pay for work they sabotaged, I'm going to have a long court process in German. 'nuff whining though ...

View 3 Replies View Related

Access 2000 VB Issues (French To English)

Apr 18, 2008

There is a massive wealth of knowledge here, I just hope that I can understand that reponses you send out.

I've been converting an Access file from French to english and I've com stuck on the following:

fileref = OuvrirUnFichier(Me.Hwnd, "Parcourir", 1)

I don't understand VB 6.0 that well so you'll probably be asking me more questions than I'll be able to answer...

The desired option is:
Operator selects a tab which opens a dialog box to browse for a file to up date a Access table.....

Full code is:
Private Sub Command21_Click()

fileref = filedialog(Me.Hwnd, "Parcourir", 1)

Text19.Value = fileref

On Error Resume Next

If fileref <> "" Then

CurrentDb.TableDefs.Delete "CRM data"
DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel97, "CRM data", fileref, True, "CRM data!"

End If

End Sub

View 1 Replies View Related

Forms :: Data Input In English By Default

Nov 2, 2014

The database was developed on a computer with only English input setup. The user group is a combination of computers with only English input setup and both English and Chinese input setup. For those computers with both English and Chinese input setup, when they use the form to enter the records, the data input is in Chinese input. The users are very annoying to change to English input before data input. It is not the worse case and the most worse case is that when go to next new record, the input is automatically set back to Chinese and the user needs to manually changes to English before continue the data input. Is there any way to set the data input to English by default and if need, the user manually change to Chinese?

View 9 Replies View Related

Export To Excel Coming In Chinese Instead Of English

Mar 20, 2015

But in my access database I have a SQL code in which excel sheet opens automatically with required data. Now problem is one column in the excel sheet since this morning is showing up in Chinese instead of English. I don't know what to do.

View 1 Replies View Related

Language Problems

Jan 4, 2006

Hi Everybody..

Another big problem from me..

My language is set to english.
So when I enter a date it looks like 31-12-05

Other users of my program use german.
So there dates look like 31.12.05

I convert my dates to string.
So its important the dates look like 31-12-05

HELP ME please

View 3 Replies View Related

Language Problem

Jul 5, 2006

Hi all,

I have searched this forum but it's almost impossible to get what I am looking for...

I've designed a database that gets modified and upgraded daily. The problem I have is that the Form I use to enter data should be available in 3 languages. All I want to know is: Is there some or other way I can have 1 Form and still have 3 different languages? EVERYTHING should be changeable into the other language... any ideas?

At the moment I have 1 set of Tables, 1 set of Queries and 3 sets of Forms (for the 3 languages). I'd like to change it to 1 set of Forms, but still have all 3 languages.

Please help!?

Thanks a lot.
I appreciate all input.
kruger101

View 1 Replies View Related

Language Problem

Jul 5, 2006

Hi all,

I have searched this forum but it's almost impossible to get what I am looking for...

I've designed a database that gets modified and upgraded daily. The problem I have is that the Form I use to enter data should be available in 3 languages. All I want to know is: Is there some or other way I can have 1 Form and still have 3 different languages? EVERYTHING should be changeable into the other language... any ideas?

At the moment I have 1 set of Tables, 1 set of Queries and 3 sets of Forms (for the 3 languages). I'd like to change it to 1 set of Forms, but still have all 3 languages.

Please help!?

Thanks a lot.
I appreciate all input.
kruger101

View 1 Replies View Related

Language Problem

Jul 5, 2006

Hi all,

I have searched this forum but it's almost impossible to get what I am looking for...

I've designed a database that gets modified and upgraded daily. The problem I have is that the Form I use to enter data should be available in 3 languages. All I want to know is: Is there some or other way I can have 1 Form and still have 3 different languages? EVERYTHING should be changeable into the other language... any ideas?

At the moment I have 1 set of Tables, 1 set of Queries and 3 sets of Forms (for the 3 languages). I'd like to change it to 1 set of Forms, but still have all 3 languages.

Please help!?

Thanks a lot.
I appreciate all input.
kruger101

View 3 Replies View Related

Multi Language Iem Descriptions

Nov 7, 2005

I have a table of some 8000 items with a verbose (memo field) description in English. I need to add French and Spanish Item descriptions to some of the items ( but not all of them) and call up the correct description when processing orders and/or invoices. I want the system to automatically supply the english text if the French/Spanish does not exist.

I could go for the easy option of adding a language field to the table, and then simply replicating all 8000 items for french and Spanish and then replace the English text. This would work but probably affect performance.

What I really want is to add foreign descriptions to the table ( as a new item record) as and when they are required, and look for, say, a French Item Description, and if one is there. then use it, else find the fallback English descriptions. Trouble is, I have had no success trying to craft the tables/queries to do this.

I've played with group-by queries to deliver a language code, but run into difficulties with grouping memo fields. Any help or pointers would be much appreciated - I've searched the forum for "multi lingual" and "multi language" with no success, but my apologies if I'm asking an old question.

I'm posting this in tables and queries as I am not sure which forum !!

Thanks for your attention

View 1 Replies View Related

Command Language Problem

Sep 22, 2006

I wish to include expert users for my project interface (access forms) and need help on finding a way of using command language on the buttons for example +e for exit database....

View 1 Replies View Related

Language Support In Access

Sep 4, 2004

Hi,
I have a database which contains fields with information in many different languages. I seem to lose my japanese content from time to time.
I cut and paste the information from a Word document and paste it into an Access field. It seem to work and I get the japanese text pasted. But I have lost it and now I just have all text replaced by small squares. How can I retrieve my japanese text?? What should I be looking for if I want to maintain a database in MS Access using Japanese, Chinese and other foreign language text in it?
Bjorn

View 2 Replies View Related

Multi Language Item Descriptions

Nov 7, 2005

I have a table of some 8000 items with a verbose (memo field) description in English. I need to add French and Spanish Item descriptions to some of the items ( but not all of them) and call up the correct description when processing orders and/or invoices. I want the system to automatically supply the english text if the French/Spanish does not exist.

I could go for the easy option of adding a language field to the table, and then simply replicating all 8000 items for french and Spanish and then replace the English text. This would work but probably affect performance.

What I really want is to add foreign descriptions to the table ( as a new item record) as and when they are required, and look for, say, a French Item Description, and if one is there. then use it, else find the fallback English descriptions. Trouble is, I have had no success trying to craft the tables/queries to do this.

I've played with group-by queries to deliver a language code, but run into difficulties with grouping memo fields. Any help or pointers would be much appreciated - I've searched the forum for "multi lingual" and "multi language" with no success, but my apologies if I'm asking an old question.

I'm posting this in tables and queries as I am not sure which forum !!

Thanks for your attention

View 1 Replies View Related

A Structured Query Language (SQL) Challenge

Jan 9, 2007

All,

I'm working on a bespoke logging feature for a web portal which records user events in a single table (tblUserLog as illustrated below).

idsession_idauth_userapp_nameeventremote_addrhttp_user_agenttimestamp
2331063924932jimApp 1Some event10.203.115.30Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)22-Nov-06
2341063924934joeApp 2some other event10.203.112.40Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)22-Nov-06
2351063924934joeApp 1Some event10.203.112.40Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)22-Nov-06
2361063924934joeApp 1Some event10.203.112.40Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)22-Nov-06
2371063924936jimApp 2some other event10.203.112.40Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)22-Nov-06
2381063924936jimApp 2some other event10.203.112.40Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)22-Nov-06
2391063924936jimApp 2A completely different event10.203.112.40Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)22-Nov-06


To supplement this flat list I'm preparing a number of key stats which will be reported to administrators (e.g. unique user/session count by period, app usage by period etc).

I'm now looking to report the (10?) most active users where most active means those users having the most unique sessions. The desired results are as follows:

User Sessions
joe 23
paul 10
chris 5
jim 2
... ...

Within Access its relatively easy to create/combine a number of queries to acheive this but I need to do this via an ASP script. The challenge is to design a single SQL statement (with nested SQL?) which will return a recordset as above.

Any help on this would be much appreciated.



Thanks in advance,


Rob.

View 2 Replies View Related

Changing Language In A Date Field

Jul 27, 2005

I am working on a french version of Access but in my english forms, I need the current date field to be written in english - is there a way/expression to change the language of the date field on a form (from french to english)?

View 1 Replies View Related

How Do I Move The Language Cache For The Package Wizard?

Jan 10, 2007

the language cache for the package wizard is currently stored at "C:Documents and Settings<user>Application DataMicrosoftAccessADE11Cache1033".
this is, therefore, in my roaming profile, which is a very bad thing since it's 35MB.
is there any way to put it somewhere else?
many thanks,
e.

View 1 Replies View Related

MS Access Form And Multi Language Support

Aug 17, 2007

Does anybody know whether the forms created in MS Access can support multiple languages? Like... captions can be loaded from a resource file.

If it does can you please share me how it can be achieved.

View 1 Replies View Related

General :: Foreign Language Day / Date Format

Jun 30, 2012

I am using the following in a Query expression to give the day of the week e.g. Monday, Tuesday etc.

Format([Arrival],'dddd',1), where [Arrival] is a date field with a standard Date/Time data type

Is there a simple way that I can modify this so that the result is Lundi, Mardi etc?

View 1 Replies View Related

Why Does Access Randomly Display Data In A Foreign Language

Jun 10, 2014

I noticed that when I made a few changes to one of my queries, the results in my data sheet view were in some sort of Asian looking language. See below. Why is it doing this? I've only been using English with this program and have not changed any of my settings so I'm very confused. Also the other fields are in English. This one field is the only one I'm having issues with.

椋

椌

æ¤

æ¤

è„ž

踖

è¼™

è¼¥

[code]...

View 8 Replies View Related

Forms :: Toggling Combo Box Language (value List) Using A Command Button

Dec 21, 2014

Now I have "tbl_organs" with three columns "organNameLatin" and "organNameArabic" as body organs names in latin and its arabic translation,and "bodySystem" which contains body sestems "digestive, respiratory..." in Latin only, and "frm_visit" as a form for recording visit data, I added unbound combo box "cbo_organ" with raw source "tbl_organs", I addedd two command buttons "cmd_En" and "cmd_Ar" to convert the combo box value from english to arabic, I mean cmd_En for showing combo box with two columns "organNameLatin" and "bodySystem",for cmd_Ar will show "bodySystem" and "organNameArabic" , the value of "cbo_organ" then used with another field for populating a txt box, i used this code for onClick event for "cmd_En" :

Me. cbo_Organ = "select distinct bodySystem, organLatinName" & _
"from tbl_organs " & _
" order by bodySystem;"

And for cmd_Ar :

Me. cbo_Organ = "select distinct bodySystem, organArabicName" & _
"from tbl_organs " & _
" order by bodySystem;"

By pressing cmd_En nothing changes and combo box still showing three columns, also the final result is populating bodySystem in final txt box instead of organ name, I dont know if properties of combo box "cbo_organs" like column count and row source have effect on this or not, and if I should determine row source of combo box from the beginning or not ? NB: bodySystem is in one language only which is Latin, the form is unbound, combo and final txt box are unbound.

View 6 Replies View Related

Queries :: Unable To Convert Text Into Date With Different System Language Settings In MS Access

Jun 6, 2013

I have a table in access database which contains a text field 'EDate' that stores Date value in format (12-Apr-2013). Now I want to run a sql query on that field. User will give an input date. The sql query needs to fetch me all the records from access database whose Edate is less than or equal to the user input date.

I am using DateValue function to convert my text filed Edate into date. My query is something like this:

select * from table_name where DateValue(EDate)<='user_input_date'

I am able to perform above task if the system language settings are 'English'. But if system language settings are different say Turkish, then the query fails.

I searched a lot on web and found that DateTime function compares test data with the system date time format and gives the result. Thus it fails with different language settings.

View 3 Replies View Related

Letters

Aug 13, 2007

Hi

I am just wondering if there is any way that you can use access to input information into a letter

i.e. you could just click a command button and it would print a standard leter with the details from an address on access e.g. name etc

Thanks

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved