Recent content by Cat129

Ive just had a thought, could it be giving me strange results because 'QA Responsible Person' , 'Completed By' , and 'Approved By' all get their information from the same table? They all get their information from the QA Responsible person table. Does each lookup / combo box need its own table?

I have removed all the combo box criteria and proved that I get the correct results without them in the query. And I have tried adding the combo box's one by one, regardless of which combo box I add in first I get the same results. I'm not sure what you mean by bound coloum in combo box (sorry...

It was ones of thoese things that is so simple you dont think of it. I had to add an entry in the tables that the combo box's got their information from that was blank. admittedly I did feel a bit silly when it worked

I cant see any common factor at all, its all very confusing for me. This is the SQL bit SELECT [All Information].Date_Raised, [All Information].EF_Number, [All Information].[Customer_Name_(Company)], [All Information].[Supplier_Name_(Company)], [All Information].Fault_Raised_By, [All...

Half work means when I use the search form with just the text fields in the query I get the correct information back. When I add the combo box's into the query using the criteria I said earlier, I get the correct results. When I leave the combo box blank and run the query again, I get...

Sorry its so big Failure Analysis, Fault Category, QA Responsible Person, Approved By, Completed By and Who is At Fault, are all combo boxes that get their information from the tables on the left

Hi All Could you help me with my querie please, I have a table with all information on it, that is input via various forms, I then have different queries pulling information from all information to run reports off. These all work fine, my problem is my 'Search Form' - below I have created...

Thanks for the info, but this didn't do what I wanted, I have solved it now, thanks for all your help

Thanks for all the info but I want to just add a blank option in the combo box, is this not possible? This is going to be used by loads of different people so needs to be as simple as possible

The query runs by looking at every field within the record and determining its results by using Like "*" & [Forms etc....] & "*" - This is used on all text fields, When I use this on the combo box it will work, however you can't go back and clear the combo box without refreshing the whole...

Hi, Sorry to sound silly, i'm not very good with VBA in access, only just grasp it in excel lol. Will this clear just the field in question or all fields? Currently my refresh button clears all fields. I want to add in a blank entry. I used * but this didn't pick up blank fields within a...

Hi All I have created a form that searches through one of my tables, via a query, it then automatically creates a report from that query. I want to add an option into the combo box's that is blank. Currently if you wanted to choose by 'fault category' but accidently click on 'failure...

Ok, I am now very very confused. I don't understand all the coding, this bit in particular, If Not IsNull(Me!ReportsTo) Then strSQL = "SELECT [FirstName] & "" "" & [LastName] AS Name FROM " _ & "Employees WHERE [EmployeeID]=" & Nz(Me!ReportsTo) rst.Open strSQL...

Oh, do i need to use the legacy bits, I've been doing things with the 2010 bits. I guess I better change them

Hi CJ London Thanks for the tip, I have checked with IT, and they come through our system fine. Sent a test file with an embedded macro and code and it came through fine. Glad I checked though, would have been heart breaking to do loads of work for it not to get through emails