As an example:
I have an Access database with the following VBA code:
DoCmd.RunMacro "Print Sales", 2
How do I prompt the repeat part of the code so the user enters 2 or 3, then the macro runs that many times. ??
As an example:
I have an Access database with the following VBA code:
DoCmd.RunMacro "Print Sales", 2
How do I prompt the repeat part of the code so the user enters 2 or 3, then the macro runs that many times. ??
vNum = inputbox("Enter repeat count","Repeat")
DoCmd.RunMacro "Print Sales", vNum
You're amazing!!! Thank you!!