Hey Guys,
I hopefully have an easy question for you guys. I haven't done VBA in a while and don't know how to solve my problem.
I have my main data table with each record being a movie. The fields consist of movie name, genre, rating, runtime, etc. My question is on my runtime field which is a date/time format. Currently if a movie is 1.5 hours long the field of that record says 1:30. By default it would have said 1:30PM, but I changed the format to the "short time" option.
So with that explanation out of the way....I have a search form with multiple buttons (ie. Search movie name, rating, runtime, etc.) again, runtime is what I'm looking at here. When the user clicks on the search movie runtime button a small pop up window comes on screen with two text box's, each text box having their own "run search" button. The first text box has a title that says "movies greater then", the second text box has a title that says "movies less then". The user then selects a text box and types in a value (ie. 1:45) and clicks the corresponding run search button. I already have a form made (called "Fsearch_runtime_results") to display the results, but don't know how to write the code.
I know I have 2 run search buttons so that means I need 2 separate statements. One which searches greater then and one for less then. I noticed that you can use the filter option when viewing the main data table. I just need to know how to apply it to a form with VBA.
Thanks for the help!
I hopefully have an easy question for you guys. I haven't done VBA in a while and don't know how to solve my problem.
I have my main data table with each record being a movie. The fields consist of movie name, genre, rating, runtime, etc. My question is on my runtime field which is a date/time format. Currently if a movie is 1.5 hours long the field of that record says 1:30. By default it would have said 1:30PM, but I changed the format to the "short time" option.
So with that explanation out of the way....I have a search form with multiple buttons (ie. Search movie name, rating, runtime, etc.) again, runtime is what I'm looking at here. When the user clicks on the search movie runtime button a small pop up window comes on screen with two text box's, each text box having their own "run search" button. The first text box has a title that says "movies greater then", the second text box has a title that says "movies less then". The user then selects a text box and types in a value (ie. 1:45) and clicks the corresponding run search button. I already have a form made (called "Fsearch_runtime_results") to display the results, but don't know how to write the code.
I know I have 2 run search buttons so that means I need 2 separate statements. One which searches greater then and one for less then. I noticed that you can use the filter option when viewing the main data table. I just need to know how to apply it to a form with VBA.
Thanks for the help!
