By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,715 Members | 1,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,715 IT Pros & Developers. It's quick & easy.

using multiple click boxes to store entries

P: n/a
Hello, I am using ACCESS 2000 and am currently trying to make a
database for a police department and they have several types of
license classes. i.e A,B,C,D,E etc.
What they have asked for is a drop down box with all the types listed
and simple the ability to click on multiple check boxes to show what
class(es) of license the person has. I have read through most of the
articles on multiple list boxes but this is not my need. I dont need
the values stored in a single field, another table is fine but I can't
seem to figure out how to do this neatly.
Also a box labeled All would be helpful as there are many license
classes.
Any help would be appreciated
Thank You
Steve Spencer
Peace Corps Tonga
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I think your needs will be best served by a multi-select listbox.
This may not be exactly the layout that has been requested, but I think your
users will find it most convenient.
It won't be hard to select "all", either, depending on whether you set up a
simple or extended multi-select.

A multiselect listbox is by nature unbound, so you will have to write some
code to get the data from the listbox into the table - and vice versa when
you want to redisplay information which was entered previously.

Are you comfortable writing a few SQL statements?
- Turtle
"steve" <st*************@yahoo.com> wrote in message
news:49*************************@posting.google.co m...
Hello, I am using ACCESS 2000 and am currently trying to make a
database for a police department and they have several types of
license classes. i.e A,B,C,D,E etc.
What they have asked for is a drop down box with all the types listed
and simple the ability to click on multiple check boxes to show what
class(es) of license the person has. I have read through most of the
articles on multiple list boxes but this is not my need. I dont need
the values stored in a single field, another table is fine but I can't
seem to figure out how to do this neatly.
Also a box labeled All would be helpful as there are many license
classes.
Any help would be appreciated
Thank You
Steve Spencer
Peace Corps Tonga

Nov 12 '05 #2

P: n/a
Hello, I solved this problem by using a subform with a combo box.
Isn't perfect but it will do what is needed.
Thanks for any replies. =)
steve

"MacDermott" <ma********@nospam.com> wrote in message news:<TB****************@newsread1.news.atl.earthl ink.net>...
I think your needs will be best served by a multi-select listbox.
This may not be exactly the layout that has been requested, but I think your
users will find it most convenient.
It won't be hard to select "all", either, depending on whether you set up a
simple or extended multi-select.

A multiselect listbox is by nature unbound, so you will have to write some
code to get the data from the listbox into the table - and vice versa when
you want to redisplay information which was entered previously.

Are you comfortable writing a few SQL statements?
- Turtle
"steve" <st*************@yahoo.com> wrote in message
news:49*************************@posting.google.co m...
Hello, I am using ACCESS 2000 and am currently trying to make a
database for a police department and they have several types of
license classes. i.e A,B,C,D,E etc.
What they have asked for is a drop down box with all the types listed
and simple the ability to click on multiple check boxes to show what
class(es) of license the person has. I have read through most of the
articles on multiple list boxes but this is not my need. I dont need
the values stored in a single field, another table is fine but I can't
seem to figure out how to do this neatly.
Also a box labeled All would be helpful as there are many license
classes.
Any help would be appreciated
Thank You
Steve Spencer
Peace Corps Tonga

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.