Search results

  1. J

    Displaying List Boxes as Query Criteria on a Report

    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...
  2. J

    VBA Query Parameters to appear on report

    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...
  3. J

    DB Openrecordset on Query

    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...
  4. J

    Pulling query results into a separate code

    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...
  5. J

    Run Time Error

    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...
  6. J

    VBA Code to show query results

    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...
  7. J

    VBA Emailing subform records

    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...
Back
Top Bottom