Recent content by lj2830

Thanks Ridders. I have pasted the code from the link as you suggested, however, sorry I must be doing something wrong. the results are still the same as the value of the listbox is always null with select distinct multi select. for example in the table there is user1 with entitlement 1 and...

Thanks Ridders. I have looked at the code on the link you provided, however I cant see that it will do what I require, sorry still learning Access. Can you explain how the code checks the items selected and knows to select more than one record from the table? Could you point out the code...

Hi All, I'm after some advice as a newbie as I cant figure out how to achieve the below. I have a DB which using a listbox on a form to lookup entitlements from a table and filter a report based on the listbox selection. The report returns the same user ID which have the entitlements...

Thank you, I've been able to get it working using that method.

Hi All, I've been searching this site and Google for an answer to a list box question, I'm a little stuck and wondered if you can offer some advice regarding my issue? To explain my DB: I have a table called ApplicationACL1 which contains users and entitlements, some users will hold the same...

Thanks Minty. It now works :)

Thanks Minty for replying, please see code below. Cheers Lee Dim strWhere As String Dim ctl As Control Dim varItem As Variant 'make sure a selection has been made If Me.Entitlements.ItemsSelected.Count = 0 Then MsgBox "You must choose at least 1 entitlement" Exit Sub End If 'add...

Hi All, I've been searching this site and Google for an answer to what seems simple in my head but I cant figure out how to do it in Access. Please can you offer some help? To explain how my DB works: Table: I enter data into the table, the data is application name, user ID and...