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 !!
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 !!
Hi i have designed a database where the users use a combo box to find a particular code they want..for example dog_brown or dog_grey, on the report which i have produced this code for the type of dog shows up to. I have another table which has a column with the code and also the description...eg dog_brown...brown dog. My users have asked me if on the report which i have produced can the description be shown instead of the code. I dont know if this can be done...any help would be grateful. Thanx
I have 4 tables - one is a master list of codes and the master descriptions. I have 3 other tables (with more coming) that have some of these same codes listed, with different descriptions than the master list.
How can I pull a list of unique master codes, and only one instance of each of the other descriptions?
I want my to detect special characters in my descriptions that are not found on keyboard and display as error. Tried using the following
Description check: IIf([Common Description] Is Null Or [Common Description] Not Like "*[!a-z0-9@=.^_$%!#&'`(){|}*?~[]/-]*" And [Description Local] Is Null Or [Description Local] Not Like "*[!a-z0-9@=.^_$%!#&'`(){|}*?~[]/-]*","<<Error Desc>>","OK")
but when i tested it using some data, it shows all as <<Error Desc>>
some of the special characters i want to check for are βuΩ etc.
So if my description contains characters that are not: a-z OR 0-9 or any of the following ~!@#$%^&*()_+=-`][';/.,<>?:"{}|~
I am looking to create a catalog database. It is to serve as a finished product warehouse, as well as a product development tool. There are a number of fields, most of which are straight-forward.
One large problem I have is that the product descriptions are roughly 700 characters. Is there a way to have this information entered into Access and stored either in this database or elsewhere? Any help would be GREATLY appreciated.
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.
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.
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.
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....
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
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.
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)?
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.
I have spent the last couple of days trying to figure out how to make this work.
I have three tables.
tblIntakeMain [IntakeMainID]
tblIncidentDetails [IncidentdeatailsID]
tblPersonnel [PersonnelID]
On the main form I use subforms to link tblIncidentDetails and tblPersonnel to tblIntakeMain. Both subforms can, and do, have many entries. This all works fine. What is not working is the search form I am using.
I am using Gromits most excellent Search Form. The problem is when I create a query, qSearch, to bring together the three tables I get a multiple records which makes the searches very confusing and near useless. Is there anyway around this? Is there something I am missing? Is there another search method I could use that would work in a similar way as Gromits? Please help before the Prozac runs out and I lose my mind--what little it left.
Hi everyone. Apologies if this has come up before, but the search terms I've tried here and on google keep turning up the wrong information.
At work I manage a large database with many tables. It stores data for participants in a research study. Each table stores the data for a different test, so one participant may have multiple records. Primary keys for these tables are defined by a combination of the participant and date of test fields. (Everything is dependent upon a table that stores the static info for participants, so the database is normalized.)
I want to be able to make a table that lists target participants and dates, and then create a query that looks at this table and pulls all the available data from various tables for those individuals that was recorded within one year of the target dates.
I've successfully made queries that meet these criteria while pulling data from only one table. The problem I'm having is that when I try to pull from multiple tables, each with it's own date field that needs to be used as a criterion, I end up excluding almost all the data, because most of the target participants do not have all the requested data within the target dates.
I've tried being inclusive with my criteria (using ORs), but then I end up with tons of data that I don't want and I need to filter through it, which defeats the purpose of the query.
Any advice on handling this issue, or do I basically just need to create a separate query for each table?
I'm sorry if this is too vague, but it's illegal for me to upload any of my own dataset. I could probably come up with an example if it's helpful, though.
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.
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.
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.
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.
I frequnetly need to export tables for others to use. I export them as .csv files usually and I'd like a way to include what I call metadata in the .csv file.
ideally, it would appear on the top of the file before the comma-delimited data actually starts.
I can't figure out how to include the table field descriptions in a file.
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.
