Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
Function concatBehav(sightID As Integer) As String Dim rs As DAO.Recordset, strBehav As String Dim sql As String sightID = Forms!behavLandSight.Form.landSightingID.Value sql = "SELECT landBehaviour.landSightingID, landBehaviour.behaviourID, Behaviour.Behaviour " & _ "FROM Behaviour INNER JOIN landBehaviour ON Behaviour.BehaviourID = landBehaviour.behaviourID " & _ "Where landBehaviour.landSightingID = " & sightID & "" Set rs = CurrentDb.OpenRecordset(sql) rs.MoveFirst Do Until rs.EOF strBehav = strBehav & rs("Behaviour.Behaviour") & ", " rs.MoveNext Loop rs.Close concatBehav = strBehav MsgBox concatBehav End Function
|Sql: Too Few Parameters expected 1||8||26|
|Stopping execution of code while print previewing reports access 2010||24||24|
|Access Migration to Sql Server||2||18|
|how to direct IT to set up virtual machines on Windows Server 2012R2 for thin clients to run Microsoft Access application?||11||5|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!