Hi All,
* PREMISE *
I'm creating an Access form with 150 items subdivided into 20
categories. Multiple categories (and items) can be selected so my
user wants checkboxes. All of the options need to be visible at the
same time so no dropdowns (combo boxes) and no scrolling lists (list
boxes). I will use tabbed sheets with logically grouped categories
(and their respective items).
95% of the records will have 1-2 items selected from 1 category and 0
items selected in the remaining 19 categories.
5% of the records will have 4-5 items selected from 2-3 categories and
0 items selected in the remaining 17-18 categories.
* PROBLEM *
What's the best control or best method to represent these items on an
Access form while being space-conscious on the backend?
Combo/List boxes create one column per control. Checkboxes create one
column per checkbox. That's a lot of extra columns in a table when
95% of the columns will have no selections.
To eliminate blank columns in the database, I've thought of using
unbound checkboxes (I think checkboxes be unbound) which, when
selected (on mouse down), will set a flag or variable in VB which will
then set the value into the corresponding category field-name (or
table) in the database. Rather than have the control set the value
directly, VB would do it.
I'm not sure that's the best method or the simplest method (in
following the KISS theory). Does Access even allow this kind of thing
or can it only be done with VB? I would welcome all suggestions.
Thanks,
Frances 9 3267
it sounds like you have a typical order entry
situation where each order has one or more items.
and each item belongs to a category.
i think i would just use a datasheet type form
where you picked the category first on each
item line followed by the item.
"Frances" <wh******@yahoo .com> wrote in message
news:bc******** *************** **@posting.goog le.com... Hi All,
* PREMISE * I'm creating an Access form with 150 items subdivided into 20 categories. Multiple categories (and items) can be selected so my user wants checkboxes. All of the options need to be visible at the same time so no dropdowns (combo boxes) and no scrolling lists (list boxes). I will use tabbed sheets with logically grouped categories (and their respective items).
95% of the records will have 1-2 items selected from 1 category and 0 items selected in the remaining 19 categories. 5% of the records will have 4-5 items selected from 2-3 categories and 0 items selected in the remaining 17-18 categories.
* PROBLEM * What's the best control or best method to represent these items on an Access form while being space-conscious on the backend?
Combo/List boxes create one column per control. Checkboxes create one column per checkbox. That's a lot of extra columns in a table when 95% of the columns will have no selections.
To eliminate blank columns in the database, I've thought of using unbound checkboxes (I think checkboxes be unbound) which, when selected (on mouse down), will set a flag or variable in VB which will then set the value into the corresponding category field-name (or table) in the database. Rather than have the control set the value directly, VB would do it.
I'm not sure that's the best method or the simplest method (in following the KISS theory). Does Access even allow this kind of thing or can it only be done with VB? I would welcome all suggestions.
Thanks, Frances
> * PREMISE * I'm creating an Access form with 150 items subdivided into 20 categories. Multiple categories (and items) can be selected so my user wants checkboxes. All of the options need to be visible at the same time so no dropdowns (combo boxes) and no scrolling lists (list boxes). I will use tabbed sheets with logically grouped categories (and their respective items).
<SHUDDER>
That's HIDEOUS. about the only way you can do this at least
reasonably flexibly/efficiently is to use comboboxes or listboxes.
Who specified this requirement? Is it real? Glad I won't have to use
it, if you have to do it as described. I hope you won't have to
modify it... it's gonna be ugly. wh******@yahoo. com (Frances) wrote in
news:bc******** *************** **@posting.goog le.com: Hi All,
* PREMISE * I'm creating an Access form with 150 items subdivided into 20 categories. Multiple categories (and items) can be selected so my user wants checkboxes. All of the options need to be visible at the same time so no dropdowns (combo boxes) and no scrolling lists (list boxes). I will use tabbed sheets with logically grouped categories (and their respective items).
95% of the records will have 1-2 items selected from 1 category and 0 items selected in the remaining 19 categories. 5% of the records will have 4-5 items selected from 2-3 categories and 0 items selected in the remaining 17-18 categories.
* PROBLEM * What's the best control or best method to represent these items on an Access form while being space-conscious on the backend?
Combo/List boxes create one column per control. Checkboxes create one column per checkbox. That's a lot of extra columns in a table when 95% of the columns will have no selections.
To eliminate blank columns in the database, I've thought of using unbound checkboxes (I think checkboxes be unbound) which, when selected (on mouse down), will set a flag or variable in VB which will then set the value into the corresponding category field-name (or table) in the database. Rather than have the control set the value directly, VB would do it.
I'm not sure that's the best method or the simplest method (in following the KISS theory). Does Access even allow this kind of thing or can it only be done with VB? I would welcome all suggestions.
Thanks, Frances
Am I correct in thinking that internally JET optimizes True/False fields so
that 8 such fields take up one byte of storage? If I am, (hmmmm ... was it
TC who suggested this?) then the back end would use only 19 bytes per
record for storing your 150 "checks" although the actual table structure
would show 150 fields.
If we are talking bits then assuming the twenty categories have a maximum
of eight items one could use a byte for each category and use bitwise
arithmetic to show and store each item as an on or off bit. This is sort of
the same thing, but here the developer might be more in control. So this
way we could have twenty fields of one byte.
I suppose too, we could have one binary field of length twenty, with each
byte then being used as above.
If we wanted to be bizarre we could use colours I guess. Let's see ... 4
bytes 3 of which are actually used. So 24 of the items could be shown in
one color and we could show the 150 ... well let's make it 168 in a
heptagon with the colors of each of the sides indicating on and off of
related items. Would make one hell of a form, No?
Don't like that? Well then maybe we could use gradient shading as sort of a
Gestalt???
But who would want to be bizarre?
Ok ... going to bed now.
No wait ... maybe Rap music?
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Thanks, Pieter, for your response. pi********@hotm ail.com (Pieter Linden) wrote in message news:<bf******* *************** ****@posting.go ogle.com>... * PREMISE * I'm creating an Access form with 150 items subdivided into 20 categories. Multiple categories (and items) can be selected so my user wants checkboxes. All of the options need to be visible at the same time so no dropdowns (combo boxes) and no scrolling lists (list boxes). I will use tabbed sheets with logically grouped categories (and their respective items).
<SHUDDER> That's HIDEOUS. about the only way you can do this at least reasonably flexibly/efficiently is to use comboboxes or listboxes. Who specified this requirement? Is it real? Glad I won't have to use it, if you have to do it as described. I hope you won't have to modify it... it's gonna be ugly.
I agree, it is HIDEOUS! After spending two weeks trying to figure out
the best way to handle this, I'm seeking the assistance of the
contributors of this newsgroup (who, BTW, are awesome!). I'm hoping
they may have some ideas or even someone who has come across this
before.
I do agree with the user in that checkboxes are preferred to
list/combo boxes. The reasoning is, there will be a group of data
entry clerks and they may "get lazy" and start picking the first item
within a category rather than drop down or scroll through each
potentially relevant category to pick the item that best fits. If
they see everything laid out on the screen, checkbox style, it
eliminates the need to scroll and "hunt" for the item that best fits.
However, I have to take into consideration the limitations of my
development application, in this case, Access.
\Frances
You got some good feedback here.
I would suggest a normalized table design. Continues forms in ms-access are
quite nice.
This means a related table, and a sub-form.
As for continues forms..yes, they are the solution here.
You are probably better off to offer a combo box, and let the user enter one
new value in a sub-form at a time. (don't try and show 150 things at once).
You can use combo boxes in a continues form. Here is some screen shots of
what I mean: http://www.attcanada.net/~kallal.msn/Articles/Grid.htm
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada ka****@msn.com http://www.attcanada.net/~kallal.msn
Although not especially search efficient, I would have all the fields
unbound; and build up a string value based on the choices. This will
allow you to have one field and keep your table managable.
For example, if someone chooses items 1, 2 and 3, the string could
look like:
"item1;item2;it em3"
This wouldn't be too hard to parse, and would make the table structure
friendly. The searching time wouldn't be ideal, but it would be
acceptable in most cases.
As for the control layout; I would use cascading lists. It would be
much cleaner. If you can win the argument do so; if not; give them
the checks they demand.
-Ben wh******@yahoo. com (Frances) wrote in message news:<bc******* *************** ***@posting.goo gle.com>... Hi All,
* PREMISE * I'm creating an Access form with 150 items subdivided into 20 categories. Multiple categories (and items) can be selected so my user wants checkboxes. All of the options need to be visible at the same time so no dropdowns (combo boxes) and no scrolling lists (list boxes). I will use tabbed sheets with logically grouped categories (and their respective items).
95% of the records will have 1-2 items selected from 1 category and 0 items selected in the remaining 19 categories. 5% of the records will have 4-5 items selected from 2-3 categories and 0 items selected in the remaining 17-18 categories.
* PROBLEM * What's the best control or best method to represent these items on an Access form while being space-conscious on the backend?
Combo/List boxes create one column per control. Checkboxes create one column per checkbox. That's a lot of extra columns in a table when 95% of the columns will have no selections.
To eliminate blank columns in the database, I've thought of using unbound checkboxes (I think checkboxes be unbound) which, when selected (on mouse down), will set a flag or variable in VB which will then set the value into the corresponding category field-name (or table) in the database. Rather than have the control set the value directly, VB would do it.
I'm not sure that's the best method or the simplest method (in following the KISS theory). Does Access even allow this kind of thing or can it only be done with VB? I would welcome all suggestions.
Thanks, Frances
> As for the control layout; I would use cascading lists. It would be much cleaner. If you can win the argument do so; if not; give them the checks they demand.
-Ben
LOL... good point, Ben. (Do ya mean you can't just threaten them?
You have to actually *show* them how your design is better?!) you
might want to build a quick demo just so they can play with it and
then let them decide... Just make sure it works, or your argument will
be toast.
On Fri, 3 Oct 2003 22:16:49 +0200, Albert D. Kallal wrote
(in message <ROkfb.11513$6C 4.10808@pd7tw1n o>): http://www.attcanada.net/~kallal.msn/Articles/Grid.htm
Albert, I have a follow-up question about you search form:
Do you Requery the listbox after each keystroke (with the OnChange-Event
of the search TextBox) or after the user is hitting Return (or another
Keystroke)?
I'm asking because I have built a lot of such "clairvoyan ce" search-forms
in a current project and I don't know enough about the performance issues
with such a form in a FE-BE-setting (I assume a 100T network with just
a Switch between clients and the BE-Fileserver and a not too complicated
Query for the listbox, although I have a few ones that do some formatting
of pulled fields ->i.e. concatenation of first/second name).
In other words: Is the lag of requerying the list box big enough to avoid
the OnChange-method and use the AfterUpdate-Event of the SearchField?
(Of course all this depends on the complexity of the db/Queries/tables etc,
but maybe you could write down your experiences with these kind of
search-forms).
Thanks,
Michael pi********@hotm ail.com (Pieter Linden) wrote in message news:<bf******* *************** ****@posting.go ogle.com>... As for the control layout; I would use cascading lists. It would be much cleaner. If you can win the argument do so; if not; give them the checks they demand.
-Ben
LOL... good point, Ben. (Do ya mean you can't just threaten them? You have to actually *show* them how your design is better?!) you might want to build a quick demo just so they can play with it and then let them decide... Just make sure it works, or your argument will be toast.
Thanks for your suggestions!
\Frances This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Phil Stanton |
last post by:
I am trying to produce a program that will output any Access report to an
editable Word document. So far it is working well but slowly with text
boxes, labels, and lines.
I now need to try to output one of Stephen Lebans' RTF2 controls on the
report. He indicates that a copy and paste method will work from a form to
the Word doc and that is fine although I have not done this in VB, rather
used ^C and ^V
I suspect that a similar method...
|
by: theo |
last post by:
Program flow...load file,then extract the xml text tags from the
file,then the number of
Xml tags retrieved from the file determines the number of dropdownlist
controls
instanciated in the placeholder,the user selects the required tags from
the
dropdownlists (if 5 Xml tags,then 5 dropdownlists each containing 5 xml
tags) and now
the btnSave button is selected which extracts the user selection form
the dropdownlists.
|
by: Peter |
last post by:
Hello!
Please, could anyone tell, is it possible to set multiple items to be
selected in list control in the code? For example when the web form is loaded
three items of 5 are selected in list control already? Now I manage to set
only one item to be selected during page load, but there is need to multiple
items could be selected for the user. I appreciate very much your help!
Thanks.
|
by: Airshow |
last post by:
Hi,
I have very simple Page_Load code in some code-behind class in ASP.NET (v.
1.1):
private void Page_Load(object sender, System.EventArgs e)
{
if ( IsPostBack )
DropDownList1.SelectedIndex = 5;
else
|
by: Doug Handler |
last post by:
Hi,
I have a form (Form1) that contains a tab control which one tab has a
customer user control (UserControl1). When the user double-clicks on the
grid hosted there a new user control is created. I have a delegate / event
that passes via EventArgs the appropriate info from the grid to the
UserControl2. This works fine, except for now I'm a little lost on the
final step....I need that once the UserControl2 is "filled out" that it is...
| |
by: Gummy |
last post by:
Hello,
I created a user control that has a ListBox and a RadioButtonList (and other
stuff). The idea is that I put the user control on the ASPX page multiple
times and each user control will load with different data (locations,
departments, etc.).
|
by: MayBoy |
last post by:
Hi There
I am trying to use the Goto method of the Word ActiveX object. I am
trying to open a document and go to a named bookmark. If I use this
code in VB it works, so I'm sure the approach is possible, I just can't
get JavaScript to work with it.
Here is the code I am using, the error I get from IE is Object
Expected:
Hope someone can help! Any help would be much appreciated
|
by: timnels |
last post by:
I have an issue where I have a user control that is launched into a
floating form. At some point later, I allow the user to "unfloat" the
user control by reparenting it on a split container in another form.
Problem is if I wake a tooltip when the window is floated, and then try
the same thing when it is reparented, the app crashes with " Cannot
access a disposed object.Object name: 'Form'.
Presumably, this is a result of the tooltips...
|
by: =?Utf-8?B?UGF1bA==?= |
last post by:
Hallo,
I have a radiobuttonlist control that is added on a custom Web User Control.
This control has a property that exposes the SelectedIndex property of the
embedded radiobuttonlist.
When running this in IE, behaviour is as I would expect it. If I select an
item and do a postback, the page remembers my selection when reloading, and
the SelectedIndex property of my control returns the correct value.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |