Recent content by VBABeginner3

  1. V

    Help with Access IF Statement

    OMG. My expression was correct. It was just showing as GROUP BY in design view instead of EXPRESSION. RESOLVED. Thanks everyone for trying to help. DisplayText...
  2. V

    Help with Access IF Statement

    plog, I don't want this in a VBA. I want it as a calculation in the query for a number of reasons because many actions occur after the query runs. Thank you.
  3. V

    Help with Access IF Statement

    This is what I have now. It's not working. The switch didn't work. DisplayText...
  4. V

    Help with Access IF Statement

    JANR, it didn't work. I went back to using IF and it keeps asking me for the age-crd parameter plog, I'm putting this in an Access query.
  5. V

    Select Combo Box to Open Reports

    Ok, thanks pbaldy. The issue was in the report layout. I changed a field so I had to go into the report and add the new field name.
  6. V

    Help with Access IF Statement

    I'm in query design and I entered this function into "Field" but it's not working. Why? Age-CRD is a calculated field. I'm trying to show the result as a range. DisplayText...
  7. V

    Select Combo Box to Open Reports

    pbaldy, I am new to VBA. Does the sub go before If and does end sub go after end if? I assume GroupLevel is the name of the report and frmReportCriteria is the name of the button. Is that correct? Thanks
  8. V

    Select Combo Box to Open Reports

    Minty, It says, "your String Provider Last Name." It's also highlighted on DoCmd.OpenReport "Inventory-Provider Last Name", acViewPreview. On the front it keeps asking me for a field parameter. It shouldn't be doing that. pbaldy, My counterparts would like it automated. :)
  9. V

    Select Combo Box to Open Reports

    I can't get a select combo box to open reports upon the click of a button. Here's what I have. What do you suggest? It's opening the report Inventory only when nothing is clicked but I can't get it to open the other reports. Private Sub Run_Inventory_Report_Macro_Click() Dim strSortBy As...
  10. V

    VBA-Apply Filter to Search Button

    Thank you Markk! This is what I ended up with. I received a response from another forum so I didn't get a chance to try yours. Private Sub cmdSearch_Click() strSearch = "" For Each varItem In Me!GroupList.ItemsSelected strSearch = strSearch & "'" & Me!GroupList.ItemData(varItem) & "',"...
  11. V

    VBA-Apply Filter to Search Button

    I'm having trouble getting this code to work. I have a blank form with a simple multi-select list box (GroupList) and a button underneath it (cmdSearch). I'm trying to put code into the button to pull select names from GroupList and display Group Affiliation names (field: [Group Affiliations]...
See more
Back
Top Bottom