Search results

Hi, I am trying to construct a questionnaire that asks a series of questions (one at a time) to multiple users who have to answer A or B. The users will be performing the questionnaire at the same time. ___________________ I want the questionnaire to run as follows: 1) People select their name...

I have a form which basically displays all the products sold by a take-away shop contained within a subform (recordset is based on a query called sales). The fields in the subform (query) are Date Code Product Cost Catagory (ie Mains, drinks, side salads, pasta, pizza) The form I've created...

I have a table in which values in a column [item] is duplicated and given a -x extention when updated. The table will look like this [item]____[type]_____[other] 1________black______info for 1 1-b ______black______info for 1 1-c ______black______info for 1 2________white______info for 2...

Thanks, all's well.

IT WORKS!!! Thanks so much, this is the best thing that has happened to me all year so far! (Sad I know) Just one problem :( whenever the info field has an apostrophy the field called influx returns a value #Error. Example: info = we're I think that you might have suggested a solution in...

There can be only one! **RESOLVED** Need an SQL statement (or similar Microsoft Access trick) which queries a table and only produces the first occurence of a field called item and puts info of the next occurance(s) into a new field called info(x) item___info 1_____1111 2_____2222...

I have a bunch of numbers from a read-only odbc connection which are stored in a field which is defined as being text not number. In my form I need to use a mask which converts these to 6 digit numbers. i.e 23 becomes 000023. This works fine when the field is defined as a number, in which case...

Doesn't like me doing that! Does it matter that Field 1 And Field 2 exist in two different tables (linked by a id field). I am using the query grid in access but I don't know what to put down in the table drop down menu.... Should it be blank, or the name of the query that I am working in...

Sum of Two fields **RESOLVED** I am trying to sum two fields in a record. Using the sum function I have only been able to add all the values within the field in question. Field1__Field2__FieldSum1__FieldSum2 1______0_______14______ 0 0______1_______14______ 0 10_____3_______14______ 0...

I have a form in which users select a bunch of products, the form does a running total of costs and it then gets printed as a report The problem being that if the user doesn't press F9 (calculate) after entering the last product, then this products cost doesn't get included in the calculation...

Thankyou.... that will be just fine Q

Situation... Users press tab (or up/down) to move around control elements in a form. When they get to the control button which they require they press enter to run that command. PROBLEM: It is hard to see which control button is in focus QUESTION: Is it possible for the control button to...

I have a Form set up which populates a table and distinguishes records according to Customer Number and Order Number. When I go into the order for all Records are there. How do you restrict a form to show only the customer records and order number that is relevant (i.e. as shown in the...

I have a Form which populates a table [T-Orders] in Mircosoft Access. I want to be able to choose products from a query [Q-Products] using a combo box using a field called [Code] to populate the [T-Orders] table - then fill in the other fields which are unique to [T-Orders] I am finding it...