Builtin Functions

VBA comes with many built-in functions that can be looked up in the Visual Basic online help. To access an alphabetical listing of all VBA functions, choose Help | Microsoft Visual Basic Help in the Visual Basic Editor window. On the Contents tab, open the Visual Basic Language Reference folder, then click Functions.

One of the features of a good program is its interaction with the user. When you work with Microsoft Access, you interact with the application by using various dialog boxes such as message boxes and input boxes. When you write your own procedures, you can use the MsgBox function to inform the users about an unexpected error or the result of a specific calculation. So far you have seen a simple implementation of this function. In the next section, you will find out how to control the appearance of your message. Then you will learn how to get information from the user with the InputBox function.

0 0

Post a comment