Recent content by ncopeland

Hi I need to add a command button to a tabular subform. Item No. Part Description Cost Command Button When the user clicks on the command button it will open a form that is linked based on the item no. This will then display item information. Is this possible and if so any ideas how to...

Thanks all sorted.

Hi Thanks for the help on this. Don't do a lot of coding and this is the last part of the puzzle. Not quite sure how to access this. The query runs on the report which calculates the total field. It is this total field that ~I want to calculate VAT or sales tax on the variables based on the...

Hi I have this formula in a text field at the bottom of the report. Is there a way to debug the statement to see what each field equals. Thanks for the help. =IIf([Which-Company-Name]="Test1" And...

Thanks Andy for tweaking the thought in my head the Customer was defined wrong in the table. Thanks again.

Hi I get a data type mismatch in criteria expression. Thanks. Neil.

Hi I have 2 forms a main form and a subform. I want to check a table for a unit cost based on the item no and customer no retrieved from the 2 forms. Here is the code that dosent work. Me![UnitCost] = DLookup("[Price]", "[Item-Price-File]", "[ItemUnique-No] =...

Hi The two tables in question are a route header table and route detail table. The route detail table relates to a part and has all the instructions required to create the part. Basically everything in this table that relates to a part needs to be duplicated to a part number which the user...

Hi I have a header table and a detail table. In the header table there is a part number this is linked to a part number field in the detail table. There a number of detail records per header record. The user wants the ability to enter a part number and create a new record in the header table...

Thanks dhookom Me being stupid. All sorted. KR NC.

Hi Yes I want to display the 65.00 in the customer footer. KR NC.

Hi Dhookom example report wo part qty unit value Customer header 1 1234 10 1.50 15.00 2 3456 50 1.00 50.00 Footer 60 65.00 I want get values for detail ie wo 1,2 which I can get to work. But as...

Hi Still not sure. I have a report that is grouped by customer. I have a number of detail lines per customer. I have a text box in the detail line that is =[unitCost] * [SoldQty] This gives me the correct total in the detail line. In the footer for each customer I want to get a total...

Hi How do you create a total field for the following scenario. I am creating a costing sheet based on qty_sold * unit_cost giving value. If none are sold then the value will be 0. I thought about suming the unit costs and on the total line multiplying them by the quantity sold. This only...

Hi Anybody know how to get rid of the annoying append warning when you run a sql insert statement from a code module. KR Nc.