Search results

Nice!! Thank you. That is a practical work-around.

But that is such a common use case, how would somebody in practice count and display the records AFTER they have been filtered?

Hello, I am trying to always show the number of currently displayed records in a label. I have own search and filter subroutines in which I have integrated the count after the Me.Requery. However, I also want to offer the standard filter functionality where this little pop-up window appears and...

So yes, it seems the Form must be open, but the Macro must not necessarily be in the Form. I created a Macro outside of a Form, then let the Macro open the Form in question and change the value of the Combobox. THAT WORKS! Weirdly enough, when I go then into the other form and assign that Macro...

"In Access desktop databases, you can use the SetProperty action in a stand-alone macro only if you precede it with an action that selects the form or report containing the control for which you are setting the property. If the form or report is not open, you can use the OpenForm or OpenReport...

Hello, thanks for the replies. Yes, I know but for VBA you have issues with security policies of the company etc. The Macro Actions work without special rights. @Minty: Yes, judging from how you reference the different objects in Access I have tried all syntax possible. @Uncle Gizmo...

Hello, I am trying to set the Value of a DropDown with a Macro. It does not work, giving me the error: "The control name XXXX is misspelled or refers to a control that doesnt exist". So I simplified it to test changing the control on the same form. If I fill: SetProperty Control Name...

Thanks for the reply. I tested this approach. It works, but it is as slow as in Excel via VLOOKUP. I am looking for an approach that is faster. Shouldn't a database setup be able to help?

Hello, in practice it is a bit more complicated but I simplify the example to get to the core principle of the problem. I am trying to link HR team codes to budget codes. The problem is, the hierarchies are different. For example the HR Code could be IT-F, with multiple sub-teams IT-FA, IT-FB...