WORKING IN VBA WITH UNBOUND FORMS

Potentially, additional coding needs to be done for multiuser programming. Again, it depends on how robust and powerful you want your application to be. What's meant by power in this case is the following:

  • How fast do you want the application to be?

  • How easy to use do you want it to be for users?

  • How complete do you want to make the error handling for multiuser situations?

Caution

This discussion isn't for the faint-hearted when it comes to code. But although these routines are somewhat complicated, most of them need to be created only once and then called from forms thereafter. One thing to remember is that this code is a great place to start; however, not every scenario that arises when using unbound forms can ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.