If I have a table, and I make custom filter such as I want the customer to be shown this week or this month, How can I save it and put it inside a button and the user can use this button? In Excel I can record Macro and then put it inside the button. but in Access I could not do you have any such way to do this?
I know it is hard for me to explain as international student :). for example in Excel I use record macro to record my steps, I filter the table and then I stop the macro recorder, and then if I edit the macro it will show me the steps that I have done. I can take that Macro and embed it with button and this button can be used by users. If I make a query I do not know the exact criteria for example show me this months I do not know how to make it in criteria, is there a such way to show me my steps and then take those steps and then embed it to a button?
One of my TechHelp Members asked a question on how to use basic filtering in a form, so I'm going to record a video about that soon. I'll make the Extended Cut how to set up buttons for making the filter: today, tomorrow, yesterday, this week, next week, next month, etc.