Search results for query: *

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.

Hi Skip Thanks for all the help. KR NC.

Hi Joe I had to update a few other fields i have coded as follows. SQL = "UPDATE [WorksOrder] SET costed = True, costeddate = Date(), PeriodEnd = thePeriod, YearEnd = theYear " & "WHERE worksordercompletion = True AND costed = False" Unfortunately I get an error 3061 Two few parameters...

Hi Skip That worked fine. One small problem the date inserted is stored as mm/dd/yyyy. I tried the format command strSql = strSql & "VALUES (" & theYear & ", " & thePeriod & ", #" & Format(theCostingDate, "dd/mm/yyyy") & "#)" but that didn't seem to work either. KR NC.

Hi Skip Values in table for year and period after insert are 2007 and 1. KR NC.

Hi All I also have a further query with regards to reading from tables. I have a table called works order. In it there are 3 fields that need checked and updated. First field is workscompletion (Yes/No). Second field is costed (Yes/No). Third field is costeddate (Date). I want to read...