Search results for query: *

I'm defining a new field in a query using the expression below. I would like it to be stored as a memo field. Right now it defaults to a text field with a 255 character limit upon export. OSM-Description: IIf([Links + Coupons.Description] Is Null,"",Replace([Links +...

I figured it out myself in case anyone else is looking for the answer... Private Sub Command49_Click() Dim strVal As String Dim varItem As Variant Dim ctl As Control Set ctl = Me.CategoryList For Each varItem In ctl.ItemsSelected strVal = strVal & ctl.ItemData(varItem) & "~~" Next...

I had the same problem and the following worked for me... Dim i As Integer For i = 0 To ListBoxName.ListCount - 1 ListBoxName.Selected(i) = False Next i

Sorry to intrude on this thread but i'm also having a problem with a multiselect listbox. Instead of using the listbox to add a new record to a table, is there a way to have it update the current record being edited in the form? I've only been able to get it to add a new record or update the...

The code works fine in terms of Multiple Listbox entries. I'm getting the proper string. The problem is that the string always gets written to the first record in the table. I need to write it to the current record being edited.

I've created a form containing a Multiselect Listbox. The selections of the Listbox should be written to a field within the current record being edited or added. The code i'm using updates the proper field but always to the first record in the table. How can I update the field in the current...