Search results

Yes. That works great. Thanks!

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...

There's definitely some good info in Albert D. Kallal's post. I am exactly what he describes: a novice developer trying to do things the easiest way possible (actually this is my first attempt at creating an Access DB and writing VBA modules). But I'm afraid I still don't quite understand how...

Sure. Attached are three images. The first is the table the form is bound to, with the field in question (Trainees). In the Lookup properties tab you can see that it is a combo box and that "Allow Multiple Values" is set. In the second image you see the actual form, and the control (again...

Yes, it's a combo box. They can be multi-selected in Access 2007 (but not earlier versions). ItemsSelected and Selected do not, however, seem to work. The former is always an empty collection, and the latter are always false, even for items that are clearly selected. .Value is the only thing...

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...

Hallelujah! It works! Thanks so much for the advice. -Marc

Thanks Tim. Your suggestion seems to be working as far as managing the primary key goes, but it generated a new problem: my fourth field is a date, and the validation rule specifies that it must be Like "1/1/*" Or Like "7/1/*" In other words it must be January 1st or July 1st. I set 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...