Search results

That has been suggested, but since I already have so much data already set up in the tables, I was hoping to keep them. And I’m not necessarily wanting to “override” a lot of things. It’s sometimes there is two options... such as zip code 12345 is for Johnson City which is in County Smith but...

**My original database was built in Access 2007. I am now trying to upgrade and make changes and it is in Access 2019** Im pretty desperate on figuring this out and have been searching the internet and asking questions on whatever forums I can... There seems to be a lot of back and forth on...

Hello again... Turns out I had the answer the whole time in a sample. To continue using query expressions, which I am able to understand easier, I needed to put an expression in the Field box that pointed to my text box (this is the box that multi-set list box is passing the ID values of the...

Thank you everybody!! I apologize for not replying sooner, I've been sick and have not had a chance to look this over. I will try it today or tomorrow and post back my results. Thank you agin, I really appreciate everyone's help :)

I’m not sure I understand all of your references.... I have never used the In Clause or know where to put it exactly. The strWhere in the code I posted is being used to populate the list box to narrow its choices, i posted it for reference. It is not being used to pass the values of the...

I googled some more after posting and I guess I need the Items selected collection or something? I didn’t understand how it could apply to my query parameter...which maybe isn’t possible? Can I pass a criteria to my query from a multi select list box? I have both...a list box and a text box...

I have a selection form to filter criteria and open a query (then export to excel). I thought I had it working properly but it appears not. I have three combo boxes and one list box. The 3rd combo box (cboCompany) limits the choices to only that companies plans in the list box...

You are 100% correct.....making it way to hard. Here is all I have for my button click: Private Sub cmdRunQuery_Click() If Me.ckboxTrustAnnuityInfo = -1 Then DoCmd.OpenQuery "qryListExportTrustInfo", acViewNormal Else: DoCmd.OpenQuery "qryListExport", acViewNormal End If End Sub I just...

I did Not post this anywhere else....I found that in a google search before I asked here, but I do not understand it and/or if it would work for me somehow. And yes, the columns can be deleted in excel...I won't be the one running the query and working with the spreadsheet afterwards though...

I was trying to do it with a checkbox. Is there a way that if the box was checked, I could run the trust query you suggest? Maybe I am trying to make this more complicated than it needs to be. Once exported to excel, they can just delete the columns.... Below is a post from another...

I will try these options tomorrow, but I am trying to avoid list boxes because there are too many choices. Will this work if it is a combo box ? Thank you for all the help so far.

Ok...let me offer more detail. My query is to eventually "on click" in the search form, export directly to excel. The query shows Agents, Clients, Policies. For each policy, there are different fields that are used. One policy, the "trusts", have three fields that only apply to them. Yes...

I have the query. The query works fine until I try to add this visible not visible option. If I export the query As Is to Excel, I would have three columns of empty data, if that type of policy is not included in the search. I am trying to get rid of those columns. I will review the sample...

Yes Gina....how do I do that?

Ultimately, I will be bypassing any display version and exporting directly into excel. Its more for the user who gets to excel and now has a bunch of empty columns. The easier I could make it for them the better. So is it still a "no" cannot be done? A different post referenced using...

I have a multiple table query that is initiated from a Select form. I have four combo boxes, two option buttons as of right now. This is to filter down what is included in the results. My query has fields for what will show up. I have three fields, that are used rarely but do sometimes have...

I now have something very strange going on in my query. Every time I use my form to make selections and run the query, my query it changed. It doesn't show up until I after I close the query and reopen it. Please see picture attached. I am not changing the criteria...it is adding all those...

Thank you, I try to keep these things in my notes so if I need to refer back later I have it. I added your code to my AfterUpdate on cboCompany and it worked great. Is there any way to also include in that list and "all". I have an union query for that box and included it as my RowSource but...

After writing all that out I knew I needed an If statement, but I don't understand all of the code you gave me. What does " WHERE (1=1)" do? I see the If Is Null is false then strWhere continues as my original did...am I reading that correctly? Where exactly is the part that says if it Is...

I really need help with this...Ive been struggling forever and just need to complete this.... I am attempting to make a Form that sets criteria for a query that when it all works correctly well eventually export to Excel. I am mostly getting stuck trying to Add "All" to my dropdown choices...