Exercises


1. 

What is the AutoExec macro, and why should you use it?

image from book

2. 

Describe at least two differences between combo boxes and list boxes.

image from book

3. 

What is the MsgBox function, and how can you use it?

image from book

Answers

1. 

The AutoExec macro is a macro that runs each time a particular database opens. This macro is a good place to add an Open Form command to specify which form should automatically open when the database opens. For example, you may want a switchboard form to open so the user can navigate among the available forms.

2. 

Combo boxes and list boxes both allow you to display data with single or multiple columns. Combo boxes can be programmed to allow a user to select a value from the drop-down list or to type in a new value. List boxes, on the other hand, require a user to select a value from the list. Combo boxes use pattern matching to find the record matching the values as you type one or more letters. List boxes jump to the first item that starts with each value that you type. List boxes allow a user to select multiple items from the list, while combo boxes only allow selection of a single item.

3. 

You can use the MsgBox function to display a message box to the user. Message boxes are useful to inform the user of some error or other event, and also to ask the user questions, such as to confirm a delete action.




Beginning Access 2007 VBA
Beginning Access 2007 VBA
ISBN: 0470046848
EAN: 2147483647
Year: 2004
Pages: 143

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net