Recent content by bobjackson

Hi, I want to use the count function to count how many records matching combo7 and Insp_Cat = 1, then calculate 20% of the total records. then using the Update statement update the field Insp_Type to "C" limiting the number of records to 20% of total records previously calculated. This is as...

Hi, Well it looks like I've made some progress, I want to use the count function to count how many records matching combo7 and Insp_Cat = 1, then calculate 20% of the total records. then using the Update statement update the field Insp_Type to "C" limiting the number of records to 20% of total...

To make progress I am now thinking of writing the actual percentage figures into the code instead of taking them from another table, if I can get it to work like this then look at what needs doing to link in the table, So I have now created another field called Insp_Cat in Qry_WO_Selection the...

Hi, Made some progress, copied all required records from qry to Tbl_Inspections with fields WO_ID, PIN, Insp_Score, Insp_Rnd which leaves the percentages. So within Tbl_Inspections there is a field Insp_Score I now need to look at Tbl_Insp_Strategy record 1 and filter all the records in...

Hi, 20% of records refers to the number of records in Qry_WO_Selection that have a [Insp Score] value between the "From" and "To" values of each record in Tbl_Insp_Strategy. The 20% refers to the V value of that record. V,C and D refer to Visual, Close and Detailed. We need to carry out...

I've hit a complete blank on where to start on the following other than the pre-requisites so this is a big ask but any suggestions/help would be gratefully appreciated, even if just a starting point. Due to the complexity I've included a cut down sample version with tables etc. I have a form...

Duane, Thanks, yes when I ran it the second time in query it did give me all the records, don't know what went wrong the first time I ran it. Again thanks for all your help. Regards, Rob

Thank you Duane amd MajP for all your help, kicking myself that I had missed the primary key bit, my excuse is I've not touched access for a few years now and am very rusty. I've now only got one bit of code to sort out which I know is going to be daunting as I normally have an idea on how to...

Duane, Yes, confirmed I get 22 also, but when I click the button in the form selected DD3 on second combo (6) it only puts the first record with PIN 2361 into the Tbl_WO_Contents and not all 22 records. Cheers, Rob

Duane, I've stripped all tables, forms, queries and reports out that are not relevant to this part of the db and reduced number of records and attached if this helps Regards, Rob http://files.engineering.com/getfile.aspx?folder=c314cad4-7a79-4ba4-b265-9fc453ce1676&file=HAI_DB_-_Copy.mdb

Hi, Tried this and only get the one record but if I open Tbl_apparatus and filter [Building ID] = 6 then I get 2434 records. Originally I thought I would have to do an IF, THEN to go through all records in Tbl Apparatus to copy into the new table. Any help would be gratefully appreciated...

Duane, Thanks for the help, it's now functioning but only writing one record into Tbl_WO_Contents, there are 2434 records in Tbl_Apparatus that meet the criteria for Building ID. Cheers Rob

Doh

Duane, Thanks, it still comes up with run-time error '424' object required. Building is now Building ID which is numeric and PIN is also numeric, WO ID and PIN in Tbl_WO_Contents are also numeric. Code now reads:- Private Sub Command47_Click() Dim strSql As String strSql = "INSERT...

the debug highlights line strSql = strSql & ", PIN FROM Tbl_Apparatus WHERE [Tbl_Apparatus].[Building] = " & [Frm_Apparatus_WO]![Combo52] The row source of combo48 is table tbl_work_orders field wo_id which is an autonumber (key) for this table, the record selected has a value of 1 Regards, Rob