Creating event procedure and errors handling
 

Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet FunctionsMaterial  Management | Guestbook  


  Creating an event procedure and errors handling

1.0 Create a command button on the form in Design View

 
2.0 in this example, say you want to open a form on the command button click.
Click on Form Operations, then click on Open Form, Click Next.

 
3.0 select from an existing table called 'Orders'. Click Next.

 
4.0 choose to view all records. Click Next.


5.0 type the text to appear on the command button. Click Next.

 
6.0 give a name to the button that will appear in the event procedure code.

 
7.0 click on the command button, then click on the icon to open its property sheet

 
8.0 select [Event Procedure] from the On Click drop-down list, then click on the ellipsis button on the right

 
9.0 you notice that the on-click event procedure to open the Orders form is automatically created for you, as well as the errors handling statement.