Is anyone experiencing the same issue as I am?
When I create a button to open a form with filter, access creates a macro for that. I don’t like macros and I then convert macro to vba by clicking appropriate button on ribbon. Then the button would not work because during the process access puts & in the wrong place inside [] in where condition of the code. I have to open code window and manually move & to the right place. This is happening all the time. Is it a bug in my ms office?
Also when I create a button to open a form filtered by date shown in a field I get wired results. For example the date is 03/02/2020 and the opening form shows records with the date 02/03/2020. I have to create a text date analog for date for the purpose of filtering.
When I create a button to open a form with filter, access creates a macro for that. I don’t like macros and I then convert macro to vba by clicking appropriate button on ribbon. Then the button would not work because during the process access puts & in the wrong place inside [] in where condition of the code. I have to open code window and manually move & to the right place. This is happening all the time. Is it a bug in my ms office?
Also when I create a button to open a form filtered by date shown in a field I get wired results. For example the date is 03/02/2020 and the opening form shows records with the date 02/03/2020. I have to create a text date analog for date for the purpose of filtering.