Search results

Sweet - thank you

A patch for 64bit would be needed - already read article in mention but thx for input

I did not write these functions but it has very easy code implementation and I have have used is numerously over the years (it is very old but still working in Excel and Access 2016) - I hope someone else can benefit from it as I have Example code usage Private Sub cmdButton_Click() On...

Does not work, no error, nothing - in fact the combo box still displays drop down values properly but no impact on results, nothing. As if code were rem'd out Dang

Thanks again for responding That appears to be what I am looking for - I am out of the office at current and will give it a test tomorrow. My fingers are crossed

Hello and thanks for responding and yes there will be duplicates. Example - cboBathTypes (fixed data) would Tub, Shower, Tub & Shower. Customer - Joe Smith main bath [BathType1], has a tub, master bath [BathType2] has a shower. Search form has cboBathTypes whereas I am searching all customers...

Thank you for responding. This is of course example situation. The object hear was to change code filter data from a singular combo box not create 3 individual combo boxes but thanks anyway. As for normalizing the tables, I agree but believe but even so I would still end up at the same moot...

The combo boxes work perfectly and has already combined the data - that is not the problem. The problem is that the code does not know if the value selected from the combo box is coming from [BathType1],[BathType2],[BathType3]. If the data from the combo box happens to be from field...

Thank you both for responding Combo boxes are working fine it is in the VB filtering I am having the issue Three different bath types due that one customer may have three different baths / type (main = bath (master = shower)) etc and they are in the same table. If I were not use a union how...

I have a search form with multiple cascading combo boxes. Most combo boxes record sources are linked to a singular table field whereas I am using this code to filter results Please Use Code Tags Function SearchCriteria() Dim CustomerType As String Dim Task As String Dim...

Hello everyone - first time back working with Access for over 20 years. A lot has changed and oh am I rusty - lol