Category Archives for "Uncategorised"

VBA Beginner – Opening Another Query

Show how to create an “AND” and an “OR” Query in the Query Designer grid. Show how to Create and setup an Option Group Show the values Returned by an Option Group in a Message Box Demonstrate how to Open two Queries with one Button:- Using an If Statement Using a Select Case Statement Emphasize […]

Continue reading

VBA Beginner – Opening a Query

Demonstrate how to use VBA from a Command Button to open a Query. Show some possible Errors. Demonstrate the VBA reset button. Demonstrate how to create a Query in Design View. Show how to add hardcoded Criteria to the Query. Demonstrate how to replace the hardcoded Criteria with Criteria provided by a Text Box on […]

Continue reading