Hello everyone. I seem to have put myself in a bind. I amcreating a recipe book DB that is password protected. I am using, (Security Levels 2012b) by Liam Sullivan and arecipe book called (recipes2k). I do not know the creator of the recipe book.The problem I am having is when I click Multiply in the recipe book I amgetting an [Ambiguous name detected (Isloaded)].
If Not IsLoaded("Multiply Dialog") Then
Exit Sub
End If
It appears that this (Isloaded)is used in the code of both the Security Levels 2012b and the recipes2k. I haveresearched this and have not come with a way to fix the problem that I canunderstand. If I have too make changes I would like to make the change to therecipe book code and not the security code. I have included the code from recipe book that itsays is creating the problem. I have also attached a copy of the data bass. I am using Access 2016 32bit. Thanks for your help.
Code:Private Sub Multiply_Click() Dim rst As Recordset Dim dblFactor As Double On Error GoTo Multiply_Err DoCmd.OpenForm "Multiply Dialog", , , , , acDialog If Not IsLoaded("Multiply Dialog") Then Exit Sub End If If IsNull(Forms![Multiply Dialog]![Factor]) Or Forms![Multiply Dialog]![Factor] = 0 Then DoCmd.Close acForm, "Multiply Dialog" Exit Sub End If DoCmd.Hourglass True dblFactor = CDbl(Forms![Multiply Dialog]![Factor]) Set rst = Me![Recipes Subform].Form.RecordsetClone rst.MoveFirst While (Not (rst.EOF)) rst.Edit rst![Quantity] = rst![Quantity] * dblFactor rst.Update rst.MoveNext Wend Me.SetFocus Me![NumberofServings] = Forms![RECIPES]![NumberofServings] * dblFactor rst.Close Multiply_Exit: DoCmd.Close acForm, "Multiply Dialog" DoCmd.Hourglass False Exit Sub Multiply_Err: MsgBox Err.Description Resume Multiply_Exit End Sub