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