Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
__________ Code in Mainform's Selection Change - Event Property Sheet _____ ________________________________________________________________ Private Sub Form_SelectionChange() Function AllCompleted() As Boolean AllCompleted = True With Me.[Subtask - Subform - Continous Form (2)].Form.RecordsetClone .MoveFirst Do Until .EOF If VarType(![Actual Complete Date]) <> 7 Then AllCompleted = False Exit Function End If .MoveNext Loop End With End Function ______________________________________________________________________ ___ Code in Mainform's text box for completed date - Before Update Property Sheet ____ _______________________________________________________________________ Private Sub Actual_Complete_Date_BeforeUpdate(Cancel As Integer) If Me.[Actual Complete Date] = "" Or IsNull([Actual Complete Date]) Then Me.Completed = False Exit Sub End If Me.Completed = True If Not AllCompleted Then MsgBox "There are Subtasks that are not completed. All Subtasks must be completed before an Action Item can be completed." Cancel = True Exit Sub End If End Sub
|ms/access subform update with refresh/requery||8||23|
|Export code - file path based on either at Home or Work||5||23|
|Why is my report opening in "MAX" view?||7||9|
|How add a field with sequential numbers to a form||7||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!