Search results

Great! Thank you very much for your help!

mderby!!! After search over and over and over again for weeks, I finally found this post from almost 10 years ago and it worked for me!! Thank you so much!! :D

Hello all, I posted a similar topic question about a week ago and received no response. I've been searching all over and trying to figure this out without any sort of success. I have a form in which there are 4 multi-select list boxes in which the user can select 1 or many items in the list...

Hello all, I have a form with multiple "criteria" on them. Two are date related, the remaining four are list boxes in which the user can select one, multiple or all the items in the list. The user needs to select criteria from each of the 6 parameter fields and when they click on the command...

Hello all, Another issue---I think I've figured out what I need to do, but I will explain....I have a multi-select list box in which employees select departments to send a form as an attachment in an email. The results of this are generated in a Query (EmployeeQuery2). I created another Query...

Yes, jdraw! That did it, thank you so much!

Hello all, I have a form in which I want to draft communication and include an attachment. I have the code up and running, but now I want to be able to reference query results from a multi-select list box as the communication addresses. I have the list box set up as well, but I don't know how...

I moved the Debug.Print Criteria above 'Modify the Query line and the Immediate window returned "7", "14".

I tried and it won't work as I keep getting the Run-Time Error. It states: Run-time error '3075': Syntax error (missing operator) in query expression 'Departments.[Department ID]=In("7")'. In the error message the "7" represents one of my Department ID's that I had chosen in the...

Hello all, I am getting a Run Time Error for some code in which I am trying to Run a Query and use a multi-select list box as criteria for the query. I built the Query, and created a form with an unbound control with the list box and the items I want. I created an "OK" button on the form in...

Awesome!!! It works...thank you, thank you , thank you!!!! You are a life saver!!!

Hello all, I have another issue. I'm still working on my code for over 2 weeks now and I've made great strides, but I have one final hurdle. I am able to list results of my query in a VBA drafted email, however I cannot put any criteria on it to limit the results. I have a form that is...

Does anyone have any ideas about how to write the code to have all records in a subform appear in a VBA drafted email?

Hello all, I'm completely new to the forum and to VBA. I have an Access database that I've built and been using at my company for years, and over these years I've managed to do almost anything to not use VBA because it is a complete foreign language to me. I need some help with a form and...