Re: Multi Selection List Box
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
I figured it out. I'm an idiot. I was looking at the wrong query when
running the script. Thanks for all your help. IN (2,3) was the right
answer.
-Tony
"Tony" <sheehanam@xxxxxxxxxxx> wrote in message
news:ed4XBTuhHHA.4516@xxxxxxxxxxxxxxxxxxxxxxx
I have a list box that I need to pick anywhere from one to twelve items out
of at any given time (fical periods actually). With the data selected from
this box I need to run a query that filters on the items chosen. I already
have the code that populates a text field called "ListStorage," which looks
something like this after a command button is pressed to run the script:
Like 1 Or Like 2 Or Like 3...
The query will not accept the data from my text box and no data is
displayed when the query is ran.
I searched the Internet and found something that runs a script that
filters the data one click at a time but I need to concatinate those
clicks so I can print a report based on the items selected.
Thank you,
Tony
.
Relevant Pages
- Re: HELP! Need AD Query for Last login
... query the DCs in the USA domain, how would I modify the script? ... I'm new to VB script and making this simple modification is beyond me at ... >> ' Because the lastLogon attribute is not replicated, ... Then, for each Domain Controller, ADO is used to search the ... (microsoft.public.scripting.vbscript) - Re: LDAP query information
... a "Dim" statement. ... script is run. ... Microsoft MVP Scripting and ADSI ... Can you please provide me info on what to do with the below query? ... (microsoft.public.windows.server.scripting) - Re: Multi Selection List Box
... through the DoCmd and it runs the report but doesn't apply the filter. ... this box I need to run a query that filters on the items chosen. ... something like this after a command button is pressed to run the script: ... The query will not accept the data from my text box and no data is ... (microsoft.public.access.queries) - Re: LDAP query information
... execution of the vbscript? ... The error message indicates the line number in the script, ... Dim strBase, strFilter, strAttributes, strQuery, adoRecordset ... ' Construct LDAP syntax query. ... (microsoft.public.windows.server.scripting) - Re: An application, script, or AD Saved query that ...
... It is a multi-step operation as you can't create a query that says give me all users who aren't in a mail enabled group. ... So the most efficient way I can visualize this is that your script will need to find all members of all mailenabled groups. ... This you will enumerate the members and stick them in a hash/dictionary/whatever it is called in the scripting language you use, basically you want an associative array. ... (microsoft.public.windows.server.active_directory) |
|