User Profile
Collapse
-
Thanks for the explanation which has helped me make more sense of it. I can see I still have a lot to learn, but have picked up some really useful tips on this question. I'll now persevere with getting the rest of the dbase functional!... -
-
Ok, this worked perfectly, until I had just one item left if in the List Box. If I try and delete the last item I get run-time error 5 for this line:
which makes sense I think . I've not figured out yet how to get round this but might try putting in an If Then line to deal with this last item. If you have a suggestion that would be great. Thanks...Code:strBuild = Left$(strBuild, Len(strBuild) - 1)
Leave a comment:
-
-
Thanks. The Listbox is populated manually - I'll work on the fundamentals first....Leave a comment:
-
Why not just store all data for all years in one table. Have a field for year, and then run a query that selects only for the year you want to see. This saves duplicating work and would use the database to its best potential.Leave a comment:
-
Remove selected items from List Box in Microsoft Access
I'm using Access 2003.
I have a List Box which I populate by selecting items from a drop down Combo Box. I now want to delete from the List Box only the selected, but not necessarily sequencial items (either one at a time or several).
I found some code at this website:
http://www.599cd.com/tips/access/listbox-additem-2000/
The author suggests creating a Text Box, then first temporarily storing the text...
No activity results to display
Show More
Leave a comment: