Search results

  1. I

    Looking for advice...."Cannot find form..."

    Good morning, I am using Office 2016 and have several databases that I have used an auto-close method if idle based on this post: http://www.utteraccess.com/forum/TimeOut-Forceoff-re-edit-t672964.html When I open these databases, I have a main form and then a Hidden Security form that...
  2. I

    Use a Multi-Select List box as criteria for a combobox

    Hi CJ, Unfortunately, that produced no results. However, I have come up with a solution. It required me to do more research on the IN Clause and I found some info here: https://www.w3schools.com/sql/sql_in.asp So what I did is point the IN Clause to the query that supports the list...
  3. I

    Use a Multi-Select List box as criteria for a combobox

    Unfortunately, I cannot post the database nor a trimmed version. It's a split back-end / front-end and there is confidential employee information in it.
  4. I

    Use a Multi-Select List box as criteria for a combobox

    Hi Arnel, I actually picked up on that already and removed the join and I still get all of the jobs.... my row source now reads: SELECT Jobs.JobID, Jobs.JobName FROM Jobs WHERE ((([Jobs].[AreaID] & " In (" & [Forms]![frmEmplToJob]![HiddenBox] & ")")<>False)) GROUP BY Jobs.JobID...
  5. I

    Use a Multi-Select List box as criteria for a combobox

    No, Arnel, all are unique.
  6. I

    Use a Multi-Select List box as criteria for a combobox

    CJ, thank you for your patience. I have added a line to requery: Me.cboJobID.requery and no change.... still get all the jobs....
  7. I

    Use a Multi-Select List box as criteria for a combobox

    Arnel, Unfortunately by making that change, I only get the jobs specific to the employee. I need to see the jobs specific to the area and only the areas selected in the multi-select list box.
  8. I

    Use a Multi-Select List box as criteria for a combobox

    Dim ListItem As Variant HiddenBox = "" 'hiddentextbox is a hidden control on your form For Each ListItem In lstAltArea.ItemsSelected HiddenBox = HiddenBox & lstAltArea.ItemData(ListItem) & ", " Next If Right(HiddenBox, 2) = "," Then HiddenBox = Left(HiddenBox...
  9. I

    Use a Multi-Select List box as criteria for a combobox

    Hi Arnel, I am getting all of the jobs, instead of just the jobs for the areas I am attempting to filter on. When I remove "<>False" it makes no difference, the combo box is still not filtering the jobs.
  10. I

    Use a Multi-Select List box as criteria for a combobox

    Do you mean this? (rowsource for combobox) SELECT Jobs.JobID, Jobs.JobName FROM Process INNER JOIN EmplToJob ON Jobs.JobID= EmplToJob.JobID WHERE ((([Jobs].[AreaID] & " In (" & [Forms]![frmEmplToJob]![HiddenBox] & ")")<>False)) GROUP BY Jobs.JobID, Jobs.JobName;
  11. I

    Use a Multi-Select List box as criteria for a combobox

    Thank you, CJ, that cleared the error, but the combo box is still showing all jobs (which number over 80) instead of the 15 I want to see for two areas.
  12. I

    Use a Multi-Select List box as criteria for a combobox

    Type mismatch error points to this line of code: If Right(HiddenBox = ", ", 2) Then When I select an item in the list box.... and the combo box is showing all of the Jobs for all areas...
  13. I

    Use a Multi-Select List box as criteria for a combobox

    Thank you, CJ.... where would I place this code? And must the user select the items in the multi-select list box or will it read the values as displayed? Yes, my AreaID is numeric.
  14. I

    Use a Multi-Select List box as criteria for a combobox

    Good day all! I am hoping someone can help me out with the following problem I can't seem to resolve. I am using Access 2016 where I have a form with a combobox that contains all of the jobs in our plant as it's Row source. The table, Jobs, contains the following fields: JobID, JobName and...
  15. I

    Struggling with this one...

    Thanks plog, I will give it a try
  16. I

    Struggling with this one...

    DMin would only return one value....Not exactly what I was looking for and I can use DMin in a query. I want to return either all records if there is at least one quote lower than my selected quote or no records if all quotes are higher than my selected value.
  17. I

    Struggling with this one...

    Hi plog, I don't want the query to return the Quote details from the main report, only all of the other quotes in the table - that is the reason for the HAVING Clause. I took my SQL statement from the SQL view in MS Access. I'm sorry but I am not sure what you want from me with respect to...
  18. I

    Struggling with this one...

    Good afternoon, I am struggling with this one... I am trying to create a query to support a subreport and am drawing a complete blank. All of the data is contained in one table called "CheatSheet"... The table contains purchasing quotes for supplies. We have created a report whereby the main...
  19. I

    Help with a query

    thank you... that gets me closer... SELECT Employee.EmployeeNo, Certified.Job FROM Employee LEFT JOIN Certified ON Employee.EmployeeNo = Certified.EmployeeNo; this produces 4426 records and all 806 employees. However, the second query results are unchanged from the first, so I am missing...
  20. I

    Help with a query

    I have been trying to figure this one out for several days and I am no further ahead. I am look for help in pointing me in the right direction. In Access 2010, I have a table with employee information (employee ID, Name, area) and I have a table with jobs (job ID, job name and area). I have...
Back
Top Bottom