Next Previous Quit
I saw this excellent code by June7 for controlling a Previous/Next set of buttons.
https://www.access-programmers.co.uk/forums/threads/database-problems.312570/#post-1705270
A nice feature to add to your Form. I noticed that the code might lend itself to being packaged into to what I call a Drop-In Component. This means I provide the VBA Code in a format suitable to DROP-IN, straight into your Microsoft Access Database. In this case, all you need to do is add the Previous/Next Buttons to your Form, (you can use the same buttons on every single Form) The buttons use the code “the drop-in component” which in this case is a module.
This method of Coding has another advantage, it’s easy to add functionality without changing your Forms, you just change the code within the module, all of your Forms carry on working as normal. You can add the enhancements, the new functionality provided by the Code update to any or all of your Forms as and when you see fit.
Next Previous Quit - Skip
Next Previous Quit - Skip
Video 1 (4:51)
Video 1 (4:51)
… …
Install - Next/Previous/Quit/Skip
Install - Next/Previous/Quit/Skip
Video 2 (3:00)
The Video instructions “Video (2)” demonstrate how to set up the “Next/Previous/Quit – Skip” drop-in Component in your own MS Access database.
All you need is this module — basNextPreviousQuit —
And 3 Command Buttons. Add the following Buttons to your Form and give them the Captions:-
Next Previous Quit.
Place the following Code in the onClick Event of each Command Button:-
— Call fNextPreviousQuit(Me) —
Please Note:-
You cannot have any other Command Buttons with with the same Caption, otherwise the Code will misbehave.
And that’s it! You have everything you need to use a Previous Next and a Quit button on your Form…
And the beauty of it is you can add the three buttons… (Just copy and paste) into all of your Forms. You can have the same functionality without any dilly-dallying about within your forms code…
If you don’t have the Module — basNextPreviousQuit — then you need to create it yourself from the code provided by June7, and the code you can see within my Video (1) above.
Video 2 (3:00)
… …
