Recent content by goldeliz

That works thank you, although I'm not sure why, everything I've read suggests you need to get the selected item i.e. along the lines : If myListbox.Selected(i) Then I will take it. Thanks for the assist.

There is only 1 column, with around 5 items in the listbox, although there could be more. It is not multi select. Only one item can be selected. What I need to do is whichever item is selected needs to be copied to a textbox so I can copy it to the clipboard.

Select an item from the listbox so I can copy it to a textbox

I have a listbox which populates fine and allows me to select an item, but I can not get the text from that item. Code: For i = 0 To myListbox.ListCount - 1 If myListbox.Selected(i) Then 'do something End If Next i Debuging the code it next gets to the...

Thank you. That worked perfectly.

Because their are multiple options to choose from that may contain a keyword. I have no choice to have a flat structure.

No, the data is not across multiple tables, but there are multiple possible fields that can have a keyword I am searching to add to listbox

Private Sub searchresponses_Click() If ifTableExists("password") Then Stop strsql = "select * from terminate where ID=1;" Set rst = CurrentDb.OpenRecordset(strsql, dbOpenDynaset) For i = 1 To rst.Fields.Count - 1 Data2 =...

Table query will not work tried it. It only works, albeit incorrectly, with value list. It is just text, not numbers, that should be displayed. Table query gives run-time error 6014

I'm not sure if this is the correct place to ask this question and if it should go somewhere else I do apologize. What I am doing is adding text from some tables to a listbox. All that is working fine except where the text contains a comma, the text in the textbox cuts off at the comma...

Good afternoon or evening, my name is Liz and I'm a newbie. I'm creating an access app for fun. I'm English living in Idaho USA. I have questions of course and when I find out where to ask them I will.