Search results

Apoligies for this rather frivilous question but IM getting really annoyed with this and I have attempted to serach the forum! I have four fields Outer1, Outer2, Outer 3 and Outer4 and I want to get the total of the four fields in a new field called total outer. However I want the user to be...

Help Sorry about this people but i have another problem. What i want to do is set the visibility of a text box on the value stored in a drop down menu. E.g. I want the system to display a text box when the value in the drop down menu selected is 'idle'. Any help would be much appreciated. Mike

Hi, I have created a Yes/No attribute. Im just wondering if a text boxes visibility can be dependent on the result of this. E.g. If a row is set to yes then the text box will be shown and if it is set to no the text box is made invisible. Thanks for any help

I know the table anmes are not ideal. Im doing a placement for a company where they need the database improving. I will sort this later. The example was extremely useful and ive been able to sort the problem out. Thanks for the advice

Just wondering if anyone can help Im creating two combo boxes where the first one determines the values in the second one. The tables are made up of the following; Line Line number (PK) ..... .... Main Setting Part Number (PK) Press Line (FK) Now ive took the advice of previous threads...

Hi just wondering if anyone can help Im wanting to create a query that uses a drop down menu. E.g. If i have a table of teachers which i must pick one then the system will return a list of school children. Any links to releveant examples would be extremely useful

Tab order Right click on the design of your required form and go to Tab order this should allow you to manipulate which has the set focus when the form is enetered.

Not too sure why you want to create table C which is identical to table A. But the answer to your question is to create a query which will have Table A and Table B as the source table. Then drag and drop the required fields into the panel beneath (QBE) one at a time. To make it really usefulin...

In the table have you predefined hours to accept null values? Another way is to simply insert 0 because that is still a value which would still cause a calculation to be 0 or null.

Query In the field you wish to insert a look up (usually a foreign key) where you create it data type change it to lookup wizard. That should hopefully be able to help you

Sorry Sorry heres the macro

This is quite tricky and my university lecturer took a whole month to explain this one so please bare with me. What you have to do is enter a new macro and go to View -> Conditions. You will know see that a new column has been added. You will now have to enter code similar to the example...

Sum When creating totals you have to have a detail section i.e. in the example shown I have created a report that calculates the following; Cost of Item * Quantity of Item It is then creating a running sum to calculate the total cost of an order. What you have to do is create a section for...

Data entry Not really sure about the first question il have a think about it but the answer to your second one is to create a new form and in the Form properties set the Data Entry to Yes. This will allow you to enter details without previous records being illustrated. I'll have a look through...

Lookup Si is it a query or a basic table that you wish to use?

Just wondering if any one can help. Ive create a table of parts, and each part has a home line. Now the problem is each home line has different characheristics. So im wondering is there a piece of code that will prompt the user to enter a part number (through a query I know!) and then depending...

Im not too sure whether you will be doing it later (good practise!!), but if you use command buttons it will allow users to have a navigation system. It also prohibits them from causing problems (which believe they will!!!). You could create a Switchboard which when the user enters the system...

RunningTotal I havent got a relevant example handy but it sounds as though you are not creating a detail section i.e. a section for each Product/Item you wish to calculate. If you post the database ill try and have a look and ATTEMPT to explain to you!

I dont really see why this is happening. The only suggestion is to say that the form where you enter the data must be different to the form where you are viewing the data. Also the entering data form must have "data entry Yes" and the viewing form must be set to "data entry No". Also is the...

I think that you may have to create a sorting and grouping clause. Im not really sure tho! If you post me the work ill have a look and try and explain it in simple english!!