Microsoft Access 2010 Bible

Chapter 21: Building Multiuser Applications 773 because one of the two users is set to optimistic locking. If the user with opti ...

Part III: More-Advanced Access Techniques 774 LISTING 21.5 (continued) ‘Call ErrorRoutine, passing ‘in the number of retries: Se ...

Chapter 21: Building Multiuser Applications 775 Tip To keep this error from occurring altogether, try to keep users from startin ...

Part III: More-Advanced Access Techniques 776 FIGURE 21.8 The Access error message for Error 3197 By default, Access gives the u ...

Chapter 21: Building Multiuser Applications 777 Dim sSQL As String Dim lngReturn As Long On Error GoTo HandleError Set db = Curr ...

Part III: More-Advanced Access Techniques 778 ErrorRoutine = 3 Case vbNo ErrorRoutine = 4 End Select A function to handle lock e ...

Chapter 21: Building Multiuser Applications 779 Next lngCounter ErrorRoutine = 3 Else Call ParseError(Err, Error) ErrorRoutine = ...

Part III: More-Advanced Access Techniques 780 Notice that ErrorRoutine() contains the error-handling segments for each of the er ...

Chapter 21: Building Multiuser Applications 781 l (^) You can’t use continuous forms when no recordset is attached to the form. ...

Part III: More-Advanced Access Techniques 782 Opening the form The first event you must respond to is the Open event of the form ...

Chapter 21: Building Multiuser Applications 783 For example, you shouldn’t create routines that require a recordset named Employ ...

Part III: More-Advanced Access Techniques 784 Function UnboundMoveFirst( - frm As Form, _ frmRS As DAO.Recordset) As Integer Dim ...

Chapter 21: Building Multiuser Applications 785 Dim lngReturn As Long On Error GoTo MoveNext_Err ‘Move to the next employee reco ...

Part III: More-Advanced Access Techniques 786 Editing data The last action you need to provide for in your unbound form is editi ...

Chapter 21: Building Multiuser Applications 787 If ctl.Tag = “Key” Then ‘Ignore key field ‘Do nothing... Else frmRS.Fields(ctlNa ...

Part III: More-Advanced Access Techniques 788 l (^) If you open the form and check the Tag property of the control EmployeeID, y ...

789 CHAPTER Integrating Access with Other Applications IN THIS CHAPTER Using Automation to integrate with other applications Usi ...

Part III: More-Advanced Access Techniques 790 Using Automation in Access The Microsoft Office applications all support Automatio ...

Chapter 22: Integrating Access with Other Applications ............................................................. 791 though, ...

Part III: More-Advanced Access Techniques 792 FIGURE 22.1 Early binding by setting references is the most efficient way to perfo ...