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.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Search Seminar.
