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 Replies


ADVERTISEMENT

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

Grouping Similar Terms

Aug 11, 2006

I would like to take information from a table and combine all the like terms. For example, I have a list of items, and some appear multiple times. I would like access to group the items with the same UPC together and give me a running dollar total insted of viewing the same UPC item 3 times. Is this possible?

View 1 Replies View Related

Searching For Multiple Terms In Query.

Feb 1, 2006

OK - I'm kinda new to all this stuff (as you're about to find out from my question).

I've got a page with a search form, where visitors enter a search term. That page uses GET to pass the variable to the results page. The SQL on the results page is pretty simple, it just takes the variable from the URL and filters for records:

WHERE columnname CONTAINS
Request.QueryString("passedvariable")

So that all works fine - except that it does not allow for complex searches. If someone searches for 'fish' then that works fine. If someone searches for 'fish and food' then the search looks for "fish and food" somewhere in the record, rather than looking for both of those terms in a record.

Now, I'm guessing that there's no simple solution for who to get this to work, but I'm hoping that someone can help me out and at least point me in the right direction. I'd be happy to post additional code if you need it - but I don't even know what else to post!

Thanks in advance.

View 2 Replies View Related

Query Criteria To Change With Search Terms

Jan 13, 2007

Hi there,
I have a search form with a text box (unassigned at the moment). The search I want to conduct, filters the product number by the users search string with the use of * as a wildcard option.

I also have a Query with all the product numbers listed, no criteria set. How can I link the the search string in the search form to the query so when the search button is pressed, it will filter the results.

Any help appreciated.

View 2 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

Insert Specific Fields Into Mail Merge To Refine Terms?

Nov 19, 2013

I'm working on a Word mail merge feature that links to an Access Database and would like to know if you can insert specific fields into the mail merge to refine the terms? example below:

<<Customer Name, [field 2]>> - Or something to that effect.

^The mail merge would know where to obtain the customer name from anyway, but will it select information from the field that is being referenced?

View 2 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

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

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 7 Replies View Related

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

MS Access Help In List Box

Feb 15, 2005

Hi , i have some problems with my List Box,
I can't make a multi-selection in my List Box...
whenever i select the Simple or Extended in the properties, my query can't work anymore.
Can anyone help me ?
Thanks

View 5 Replies View Related

Help With Putting A List In Access

Mar 20, 2006

i have started to try putting the concrete records i keep on excel into microsoft acces. for each record, i need to make note of the vehicle registration numbers. what is the best way of doing this? if it is possible

Thanks

View 3 Replies View Related

Drop Down List In Access

Jul 10, 2012

I have a drop down list in a table with name and commission rate. When I choose the name it displays but I want both the name and the commission rate to display in my table. I want to use a data entry form to enter values in the table and I want the same in the form too (when I choose a name I want the corresponding commission rate to show up).

View 3 Replies View Related

Looking For Help With List Boxes In Access 2000

Nov 26, 2007

Hi, I am trying to create a button that upon click it moves the slelected item in list box one to list box 2 but i am not sure how to go about it, cany anyone help?

Dominic

View 1 Replies View Related

Access Query Will Not List Certain Date

Aug 15, 2006

I have a query that reports on records according to date. The criterea line of the date field has [Enter Date]. I have confirmed that there are dates from 8/1/06 through 8/10/06 in the table, but when I enter the date 8/10/06 the query returns no records. But it does return records for all other dates (8/1/06 through 8/9/06 inclusive).
So then I tried to make the date a range:

Between [Enter Start Date] And [Enter End Date].

I entered 8/9/06 and 8/11/06 in these fields and there in the report were the records for 8/10/06. Then I went back to [Enter Date] as criterea and entered 8/10/06 and no records are returned.

View 3 Replies View Related

Access Related List Boxes

Apr 29, 2005

I have a music database created in Access.

I have lookup fields for CD Group and CD Name
Do I need a autolookup Query or Syncronized combo box to perform the following function.
Filter by Form
CD Group
Select from List box
CD Name only Display CD's related to that Group

Mormon Tabernacle Chior Cd Group
Only display CD's related to the Mormon Tabernacle Chior
NOT ALL RECORDS IN THE DATABASE.

I've bent my self backwards on this and get no were I know it might help me with some visual basic coading.
The only resources I have is some books on Access
I Live in a Rural Area and there are no computer coarses near me that fit my time.

This following procedure I think would be done for example with any Products Database let's Say like Bakery Items
NAme of Company
Nabisco
NAme of ITems
Crackers
Cookies
Only display products by each item Name
NOT ALL RECORDS IN THE DATABASE WHICH ARE BAKERY ITEMS IN THE LIST
wHEN I FILTER BY FORM

PLease email me at
mikevds@optonline.net
So somebody can get back to me on this
I can even send you some screen shots if you don't get what I am getting at.

View 1 Replies View Related

Numbered List In Access Report

Sep 21, 2004

I have a report listing all individuals within my database by their score. I need to select the top say 40 people from the list, instead of counting down 40 from the top how could I put a number beside each name? Any help would be greatly appreciated.

View 12 Replies View Related

Access & File List Trouble

Oct 29, 2004

Hi,

I wonder if anyone can help me.

I have a form which has a links to a table of student ID's. I also have a project folder where images and documents are loaded into. These can be jpegs, bitmaps, gifs, office files (all types) etc

The files are named by the user and dropped into the folder. The name relates to the student ID. For example student: 3001 can have multiple files: 3001.jpg, 3001.doc, 3001.ppt etc.

When each record (student ID) is displayed on screen I need a list box (or something) to display the files associated with this student ID. Then, if possible, the user can double click on the file(s) to open them in the computers default program.

I'd be really grateful for any help on this one. It's got me baffled. I'm only a starter to VBA.

Thanx.
Chris Coleman

View 7 Replies View Related

Change The Appearance Of A List Box (MS Access VBA)

Feb 29, 2008

I currently have a list Box populated with some table data which has 9 columns and 255 rows.

I want to enhance the appearance of the list box i.e. 1 row of data will be blue, and next row will be white, and the next row blue again etc etc

How can I do this?

Kind Regards
Richard

View 2 Replies View Related

VBA Access - Automatically Populate List

Jul 8, 2007

I wish to automatically fill in a form in datasheet view with records from a table. Currently you need to select each record to fill the list. I think this can be done using VBA, I'm a begininner to programming but think I need the code to do something like this.

Lookup the table or query, DoCmd select the first record, DoCmd select next record, Loop to end of recordset??

Basically it is automatically entering/ filling in each row (record) in the datasheet for every record in that table or query.

Any idea's please.

View 2 Replies View Related

Drop Down List On An MS Access Table

Jan 26, 2008

It is essential that i use MS access to do this, what i need to do is have a drop down list on an ms access table to make sure the data in the field is exact, i could use validation if this is not possible but i would prefer this method also i dont need an answer to this but is there a way to make the key field dependant on whatever is selected on the dropdown menu? sort of use a general input mask but alter something dependant on the drop down menu to have it as specific characters, i have some experience with VB if there is a way to link vb programming with access

View 6 Replies View Related

Modules & VBA :: Database Access List

Jul 16, 2013

So I am using the following code:

Code:
Declare Function WNetGetUser Lib "mpr.dll" _
Alias "WNetGetUserA" (ByVal lpName As String, _
ByVal lpUserName As String, lpnLength As Long) As Long

[code]...

My question is how can I create a table listed with numbers as an access list? Right now only the ######## has access but I'd like to create a table for numbers who will have access.

View 6 Replies View Related

Row Duplication Using Column List MS Access

May 28, 2015

I would like to use Access in order to duplicate the content of a list of values into new rows based on the content of a column.

Here is an example below:

List1
List2

A
1

B
2

C
3

D
4

E
5

F
6

G
7

Duplication

A1
A2
A3
A4
A5
A6
A7

B1
B2
B3
B4
B5
B6
B7
Etc

How can I achieve this in Access?

View 3 Replies View Related

Making Call List In Access

Jul 5, 2012

We have 4 managers and 16 foreman. Each month a manager is tasked with calling 4 foreman for progress reports.

I'd like to create a simple program with Access to have the foreman assigned to the managers differently each month. It would have to remember the past 4 months so the same names aren't assigned to the same managers. It also has to randomly assign the foremen so the managers don't have the same foreman after 4 months (if that makes sense).

View 1 Replies View Related







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