Recent content by Gavin59

Good morning Paul I have had a look through various things. I found that by changing the order of the SORT in my qryAllEmployees I have the Dangerous Goods Specialist at the bottom of the report, and the Iif Function now recognises this. So if you now select all persons except the DGS in the...

Good evening Paul Many thanks for your reply. I have tried your solution and it does indeed count the number of Dangerous goods specialist. So that is handy to know but not what I am after. However, What I am after is, If Dangerous Goods Specialist (DGS), is not present in the report, then...

Good morning I'm back again. I have been trying to improve on the database and have managed to sort most things out. However I am stuck again. If I do not select 'Dangerous Goods Specialist' I need to have on the report 'Freight Must not be loaded on this flight', and when I do, then no...

Many thanks for you reply. I see that you have inserted an extra column in qryAllEmployees. That works a treat. I'll finish this project now and then insert the finished thing so that other people may benefit from it. Many thanks again

Sorry Forgot to attach lastest efforts

Good afternoon, I'm back again. I have been looking at what you have given me. Many thanks. I have adjusted some of the criteria in the queries. How ever I am not getting the order in the report that I require. I need to have the report show in this order HLO, Dangerous Goods specialist...

Good morning pbaldy, I have been trying a few things. I can now open the report from any name selected from any list box. However all names appear in the report and not the selected names which is what I need. Here is my code. It looks messy. Private Sub cmdOpenReport_Click() On Error...

Thanks for your reply pbaldy, Understand about building up the string slowly, testing each step. I have inserted my code amendments in blue. I tried using strWhatever but does not recognise statement so changed it back to strWhere. Now saying : Syntax error ( missing Operator) in query...

Many thanks pbaldy, I'm new to this, so all pointers greatly received. I'll try as you suggested. Just to clarify, does this go in the same line as the 'DoCmd.OpenReport'? Many thanks

Many thanks pbaldy for writing back. I can see what you mean but where in my code do I insert this string. Does Field2 refer to another name field heading. ie should I change Field2 to a heading in my table. How do you join strings together? many thanks for any directional help.

I have a form with 7 List boxes linked to 7 Query's which in turn are linked to a table. Each list box if for a particular trade. I am trying to select a person or persons from each List box and then have them sent to a report. I have Code to do one list box, but do not know how to link all...

Sorry for the long wait. Thankyou for your time. I've been trying to figure out a way forward, but Access is still alien to me, but slowly learning bits & pieces. May be I'm trying to run before I can walk! I'll do as you suggest and post a new thread stating List boxes this time and a more...

Many thanks for the quick reply. I'm not sure what a Union Qery is or what it does, but Il'll have a look at a few books and on line to see what I need to do. I'm new to this, so it's a big learning curve. Many thanks for your help.

Uncle Gizmo Thankyou for having a look. You are correct. For some reason I thought the boxes on the form were comboboxes, where actually they are List boxes. I'll resume my search for code that will allow me to add selected values from all List boxes to a report, unless you know of a way to...

New to this forum, so many thanks inadvance. I have a frmOpenReport which has 7 combo boxes linked to 7 Query's. I have found code to add selected values from one combo box from a button 'Open Report' to a report but struggling to find how to select selected values from all comboboxs and add to...