• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Running a Sub Procedure

After writing a Sub procedure, you may want to test it. You can run a Sub procedure from within the Visual Basic Editor, but you might have to return to Access to view the results. If the Sub procedure is a long one, you can also click buttons to pause it or to stop it altogether.

Run a Sub Procedure

Click the Save button on the Database toolbar to save changes to the VBA project.

Enter a name for your module if requested.

Click anywhere within the Sub procedure that you want to run.

Click the Run Sub/User Form button on the Database toolbar.

If the Macros dialog box appears, select the macro you want to run, and then click Run.

Return to Access, if necessary, to view the results of your Sub procedure.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint