Recent content by fargos99

Hi I have a small application that uses a form to perform a few calculations and then I need to get a few relevant data items into a report or a word document at the push of a button. Can I do this in design view or do I need code. Any advice appreciated many thanks Stu

Hi I must be missing something but I dont know where. I have a number of fields on a form and I wish to manually add a button which will perform a calculation at the 'on click' event. However every time that I try I just get this annoying message <B>The expression On Click you entered as the...

I have created a simple program that calculates cost and materials for a given suspended ceiling via a form. Next I want to insert all the data from the fields on my form into a report and to carry out further calculations and add further details to the same report. Should I use VBA or Macros...

That would help me a lot cheers stu

Thanks rich for your answer though I am still missing something. The text box on my form called 'frmCeilings' is named 'txtMainTcost' and I want to put in the value held in the field named 'Cost per Metre' from the Query named 'MainTeesQ' I have been trying to do this as per your...

Maybe I'm doing it all wrong but here goes. I want to pull a value from one field on a query that contains only one record, so that I can then use it in a calculation and I dont seem to be able to correctly do it. Can anyone help. Thanks

Please help I am a student doing this project for my HNC and I am completely stuck. I have designed a database with one table and one form, the form has a number of comboboxes which show various items and their prices (though their default value is ‘none’). The comboboxes are based on different...

Hello I want to warn the user by a message box that they must make selections from all the combo boxes on my form, some of which may have a null value. This code does this fine, the problem is that even if appropriate selections are made the message box still warns the user. thanks Stuart...

In your database window click on the macro tab, then click the design button. In the top 'action' box click and select 'open form' Next at the bottom of the window click in the form name box and select the name of your form. Below that in the 'view' box select Form. Go back to the next box in...

I have a form with a number of combo boxes, the selection of the first decides the values in the second. The remaining boxes all have static rowsources.All the Values are chosen and then added together. The problem that I am having is resetting all the combo boxes to '0' in order to perform the...

I have a form in which a number of combo box values are chosen and the added together. The problem that I am having is resetting all the combo boxes to '0' in order to perform the task again cleanly. Help!!!

I have a form that displays some items and their prices in the drop down lists. After selection, I wish to add these values together and diplay the total. The problem I am having is 'referring' to the price field in order to calculate the answer either in code or with the expression builder...