Hi guys,
I am trying to run a query that will only display data which dates are within the month and year selected by a text box on the main screen. I am having so many issues with this.
I have tried google but no joy so far. The textbox is on a form called MainMenu and the textbox is called monthtext.
Can anyone help me?
I have set up on the main menu with visual basic so the textbox displays the month and I have two command buttons which change the month back or forward months. Do I need any coding to run the query each time I change the month to update the query?
I am trying to run a query that will only display data which dates are within the month and year selected by a text box on the main screen. I am having so many issues with this.
I have tried google but no joy so far. The textbox is on a form called MainMenu and the textbox is called monthtext.
Can anyone help me?
I have set up on the main menu with visual basic so the textbox displays the month and I have two command buttons which change the month back or forward months. Do I need any coding to run the query each time I change the month to update the query?