Search results

Ahh. The lights went on. I usually don't look at the immediate window, which is why I couldn't figure it out. So yes when I do Debug.Print CalEquipment the Immediate window reads ('177','173','17','75'). This a good representation of what is actually selected in the multiselect list box.

CalEquipment is a string. Debug.Print doesn't mean as much as it should. From what I gathered is it "prints a message to the immediate window in the Visual Basic editor." For the life of me I have no understanding of its use or what it is doing. I tried to read up on it but nothing seemed to...

Ok now I better understand what you meant. I didn't realize we were creating the In() in the For... Each loop. I am just moving from beginner to more advanced stuff so I may be a little slow on the uptake. Here is the changes to the code now. [CODE]For Each oItem In GoingToCal.ItemsSelected...

Let me make sure I get this. So remove the recordset line of code and set up the SQLString that includes the IN() with it? So for example- SQLString = "Select * From CalibratedEquipmentListTable where in(CalEquipment)" So my code all together would look like - If...

I am sorry, I am having some serious issue with getting this to work and some how I feel I have totally missed something. I still have my original code. I need what my original code does plus now update the records of the items in the list. The reason I need the other code is because after this...

Ok so I tried to implement what you said and I don't think I am doing something right as it still says too few parameters. I also tried a more then a few different combinations to get the results I desired. CalEquipment does return a good value, as I used a msgbox to make sure it returned a...

I know I have seen it used when using multiple tables but not when its only one table. I am just pulling a single record out of a table. Usually I just say where "ID = CalEquipment"

I am currently modifying a form on my access database. More specifically the on click event of a button on the form. The form is based on a Table that only has 3 fiels, ID, GoingToCal, and Location. ID is the autonumber. GoingToCal is a multiselect list box on my form. Location is just where the...

Well I kind of took what you said and made it work. Basically I had the DLook up be looped to constantly get the new email address when the ID was sent individually to the query. Here is the code I settled on and got the results I needed. Dim ListItem As Variant Dim AllEmail As String Dim...

I know that the query doesn't itself loop, I just figured when the function AdditionalEmail was called just the final result was returned to the query. So lets say the function runs and gets the result of 3, 15 , 17. That only those results would be returned. Then using what you provided, using...

The way I set up the query was to get all of the ID Numbers from the multiselect list box. With that information I would have just the ID Numbers and Email address of the individuals that are also being emailed. Which if it did that I believe would work in the previous example you showed...

Thank you for your assistance in this and for putting it in code that makes so much sense. I sometimes get lost and don't understand what I need to modify. The problem I am having which may have been an issue all along I am not sure, is that I can't get the query to return what I am looking for...

Maybe I wasn't being that clear as to the issue i am having. What I am trying to do is allow people to email additional people beyond what the email is already set up to do. I am only returning the value of the ID Numbers. I am attempting to query those ID Numbers, in a query that would also...

Have you looked into cross tab queries? I use them to do metrics on quantity of testing performed. The user selects a year which is a combo box. It still comes out looking like a query but is very easy to read and understand.

I am using Access 2010. I have a database that on a form uses a multiselect listbox. That part works just fine. The list box is for selecting additional people to email. Now I have had no luck with returning just the email address that are in a hidden column (the persons actual name is seen and...

I am not horribly new just not well versed with using SQL to design them. My database uses every query type and through some trial and error I usually get the results that I am looking for. This one was however totally escaping me. I think that your idea hit the nail on the head. I looked into...

I am trying to design a query that is based on 6 tables. What I want to achieve with the query is a weekly schedule of tests that go on at this facility. I want the query to show all of the records that match the criteria I have set forth. As it is the query returns most of the records. No wrong...

Thank you for all of your help, it has been very educational to say the least.

That might explain some of my hangups that I run into when loading a form. I actually use two queries because I am looking for some different unrelated information. I want to make sure that I understand what you are saying. After I design the query I am want go to SQL view and copy that, then...

That maybe be entirely possible I don't know as I have only been doing this for a little over a year now. From what I understand that the recordset returns the information of the record you are looking for based on your criteria. I haven't found as much on gathering information on related...