Search results

I have a column of values in a query-generated table that I'd like to aggragate into a comma-delimited list. So the query result looks something like this: ID Data 1 Item1 2 Item2 3 Item3 . . . n Itemn Since they are drawn from a query the ID numbers aren't necessarily an unbroken series...

I've got a multiselect ComboBox and I'd like to manipulate the collection of selected items from within my VBA module. I've learned that I can iterate through the .Value property with a "For Each varVariant in cboComboBox.Value" construct to see the collection of all items selected from the...

I needed to append new records to an existing table and have the primary key integer increment automatically. I couldn't find a single command to do it, so I resorted to this: Set rstTemp = CurrentDb.OpenRecordset("SELECT LAST(ID) FROM tblTable") avarData = rstTemp.GetRows(1)...

I've made a form called Add_Training with a multi-select combo box (not a list box) that is bound to a table called Trainees. The user is supposed to select the names of one or more trainees from the drop-down list. I enabled "Allow Value List Edits" on the combo box properties and made a...