Posted on 2016-08-23
MS Access 2003 sending list of record identifiers to be process in SQL 2008
''===== gather all selected Table_IDs a list box
Dim ptr As Variant
Dim tbl_IDs As Variant
tbl_IDs = "("
For Each ptr In Me.ActiveTimes.ItemsSelected
tbl_IDs = tbl_IDs & Me.ActiveTimes.ItemData(ptr) & ","
tbl_IDs = Left(TimeIDs, Len(TimeIDs) - 1) & ")"
looks like ('139415, 139412' )
Conversion failed when converting the varchar value '139415, 139412' to data type int.
I've tried many ways of formatting the argument but it always throws an error