![]() ![]() Note: Many Microsoft Office programs use the term "macro" to refer to VBA code. ![]() For a simple operation, such as opening a report, you can use the Command Button Wizard to do all the work, or you can turn off the wizard and do the programming yourself. Programming, in this case, is the process of creating a macro or VBA procedure and then setting the command button's OnClick event property so that clicking the command button runs the macro or procedure. For example, suppose that you have created a form and a report, and you want to add a command button to the form that, when clicked, opens the report. In Access, programming is the process of adding functionality to your database by using Access macros or Visual Basic for Applications (VBA) code. Use the Command Button Wizard to perform common programming tasks Should I use macros or should I use VBA code? This article helps orient you to the programming tools in Access. Eventually, you reach a point where you have to add some programming to automate certain processes and tie your database objects together. When you create a new database, you typically begin by creating several database objects such as tables, forms, and reports. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |