Search results

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

Thank you, I will try and work through this and get back once I've figured it all out

Hiya, If I did this, can I get access to create the word document with information in it from a table, and when the word document is returned import the data into access?

I have one main table that holds all information, then smaller tables containing info for my combo box's. There are then lots of queries that run for different things, and various forms that input data into the main table. I'm not sure how I would do what you have suggested with my set up...

Hi CJ London Sorry it took me a while to get back to you, I've just created a query that pulls information from the table that relevant form is inputting data into, when I tried the to use Create Email, it came back to me with You cannot collect data for action queries, SQL-specific...

Hiya, I'm using 2010 Go into the external data tab, on the far right there is a section called data collection, within this is a button called 'Create- E-Mail'. This is access' automated system. However this doesn't work for me as is and im not clever enough to change the code.