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 ...
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?
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!
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.
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?
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?
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.
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?
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.
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.
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
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
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).
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?
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.
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.
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.
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.
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.
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
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.
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).