Select All Question - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Select All Question

Timothy Smith

2 years ago

I am having a problem with Select All Code for my button. When I click the button, it only selects the last item in the list box and not all of the items. Pics are coming.

I am using Access Developer 15 to do the code. Is there any suggestions to fix.

	Timothy Smith OP @Reply 2 years ago

	Timothy Smith OP @Reply 2 years ago

	Timothy Smith OP @Reply 2 years ago

	Timothy Smith OP @Reply 2 years ago

	Kevin Robertson @Reply 2 years ago
In your DoSelectAll you are adding 1 to the ListCount. You need to subtract 1 instead.

	Ronald de Boer @Reply 2 years ago
Hi Timothy, Besides what Kevin has stated shouldn't your With C statement say With X Regards Ron

	Kevin Robertson @Reply 2 years ago
No. If you look at the arguments. C As Control (in this case C is the Listbox)

	Kevin Robertson @Reply 2 years ago
You don't actually need two separate Sub Routines for Select All and Unselect All. Using only one will make your code easier to maintain. See screenshot below.

	Kevin Robertson @Reply 2 years ago

	Timothy Smith OP @Reply 2 years ago
Kevin and Ronald, Thank you so much for your help. I feel like a real idiot right now. I had forgotten to set the list boxes to multi select. Thanks gain, It is working now.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View