473,320 Members | 1,746 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Capturing alot of check off data

I hope the following describe what I'm trying to do:

I have created a tool to be used by product analysts when studying different
cell phone designs. Part of the tool is a set of 11 forms on a tab
structure with fields for various features a phone might have; there are
almost 100 of these features to choose from. Rather than a simple check
box, I used a combo box with the a value list of "Y, N, N/A, and ?"; I even
simplified entry by having a Y entered when the field was double clicked.
So, as the analyst researches the product, they go through the forms at
least entering "Y" where appropriate (I hope they will not leave any fields
blank, but change comes slowly). But that's not all; for almost every one
of the simple Y/N/NA/? answers, there is a note field where the analyst can
include add'l info about a certain feature.

Now, I may have been foolish due to lack of experience, but I have created
tables for each of these forms, with each combo box bound to a field in the
table. I then used some code to extract all fields that contained "Y",
translated it to the feature name, and concatenated these into one string
per table of features, so the resulting string looks like "featureA;
featureC; featureH". This goes into 11 tables (one table per form of data)
each with just a single text field to hold this resulting string. This
works; but my problem is when I build a query to bring all the strings
together into one line, if one of the 11 results tables is empty, nothing
shows up in the query. I've tried Nz() and using IIf( field="","-",
fieldvalue).

Any guidance and advice will be appreciated.
Nov 13 '05 #1
2 1564
Chris Windsor wrote:
I hope the following describe what I'm trying to do:

I have created a tool to be used by product analysts when studying different
cell phone designs. Part of the tool is a set of 11 forms on a tab
structure with fields for various features a phone might have; there are
almost 100 of these features to choose from. Rather than a simple check
box, I used a combo box with the a value list of "Y, N, N/A, and ?"; I even
simplified entry by having a Y entered when the field was double clicked.
So, as the analyst researches the product, they go through the forms at
least entering "Y" where appropriate (I hope they will not leave any fields
blank, but change comes slowly). But that's not all; for almost every one
of the simple Y/N/NA/? answers, there is a note field where the analyst can
include add'l info about a certain feature.

Now, I may have been foolish due to lack of experience, but I have created
tables for each of these forms, with each combo box bound to a field in the
table. I then used some code to extract all fields that contained "Y",
translated it to the feature name, and concatenated these into one string
per table of features, so the resulting string looks like "featureA;
featureC; featureH". This goes into 11 tables (one table per form of data)
each with just a single text field to hold this resulting string. This
works; but my problem is when I build a query to bring all the strings
together into one line, if one of the 11 results tables is empty, nothing
shows up in the query. I've tried Nz() and using IIf( field="","-",
fieldvalue).

Any guidance and advice will be appreciated.

I admit I do not fully comprehend your problem. Ex:
I then used some code to extract all fields that contained "Y",
translated it to the feature name,
I don't know what translated to a feature name.

So I'll toss out something that may be totally irrelevent.

I might create another table. It would be a lookup table. It would
consist of an autonumber, a text field to hold the name of the text file
name on the form, and a feature description.

I would then create another table. This would be a summary table. It
would have a field to store the product (cell phone id), a field to hold
the text field name of the form, and whatever other fields you require.

When the record is saved, you scan all controls on your form. You could
enter something in the Tag property to define those fields to be stored
in the summary table. Highlight all of the fields that are y/n then
open up the property sheet, click Other tab, and in the Tag property
enter USETHIS.

Now you can scan all controls and if the tag is USETHIS check and see if
the value is Yes. If so, see if it exists in the summary table. If
not, add the field name and whatever else. If the value is not Y, see
if it exists in the summary table and delete it.

Then when you want a summary, you search for the cell phone and present
the features in the summary table. You can link that to the lookup
table based on the field name for descriptions.

This is pretty generic, but I think you get the idea where I'm coming from.

For what it's worth, since you have 11 tabs in your form, I might
consider using frames with checkboxes or radio buttons for selection. I
think 100 combo boxes would make working with the app a bit of a chore.

For example, on the left hand side of the form I might have 20-30
features down the side with the option group to the right of the
feature. You could stack up quite a few . Then on the right hand side
of the form, you could have a generic list of fields and the memo. As
you get focus to the feature, the fields and memo on the right hand side
get filled in for entries made for that feature. Just a thought in case
you are running out of space. I know if I were working as a user on
your app, I would prefer clicking on a checkbox/radio button vs pressing
on the drop down button and selecting the option from the combo. That
would slow me down as a user.
Nov 13 '05 #2
Thanks Salad. You obviously gave this some serious thought and I really
appreciate it. I think you have grasped the concept of what I'm trying to
do, and I'll try out what you have suggested.
"Salad" <oi*@vinegar.com> wrote in message
news:fP******************@newsread1.news.pas.earth link.net...
Chris Windsor wrote:
I hope the following describe what I'm trying to do:

I have created a tool to be used by product analysts when studying different cell phone designs. Part of the tool is a set of 11 forms on a tab
structure with fields for various features a phone might have; there are
almost 100 of these features to choose from. Rather than a simple check
box, I used a combo box with the a value list of "Y, N, N/A, and ?"; I even simplified entry by having a Y entered when the field was double clicked. So, as the analyst researches the product, they go through the forms at
least entering "Y" where appropriate (I hope they will not leave any fields blank, but change comes slowly). But that's not all; for almost every one of the simple Y/N/NA/? answers, there is a note field where the analyst can include add'l info about a certain feature.

Now, I may have been foolish due to lack of experience, but I have created tables for each of these forms, with each combo box bound to a field in the table. I then used some code to extract all fields that contained "Y",
translated it to the feature name, and concatenated these into one string per table of features, so the resulting string looks like "featureA;
featureC; featureH". This goes into 11 tables (one table per form of data) each with just a single text field to hold this resulting string. This
works; but my problem is when I build a query to bring all the strings
together into one line, if one of the 11 results tables is empty, nothing shows up in the query. I've tried Nz() and using IIf( field="","-",
fieldvalue).

Any guidance and advice will be appreciated.

I admit I do not fully comprehend your problem. Ex:
I then used some code to extract all fields that contained "Y",
translated it to the feature name,
I don't know what translated to a feature name.

So I'll toss out something that may be totally irrelevent.

I might create another table. It would be a lookup table. It would
consist of an autonumber, a text field to hold the name of the text file
name on the form, and a feature description.

I would then create another table. This would be a summary table. It
would have a field to store the product (cell phone id), a field to hold
the text field name of the form, and whatever other fields you require.

When the record is saved, you scan all controls on your form. You could
enter something in the Tag property to define those fields to be stored
in the summary table. Highlight all of the fields that are y/n then
open up the property sheet, click Other tab, and in the Tag property
enter USETHIS.

Now you can scan all controls and if the tag is USETHIS check and see if
the value is Yes. If so, see if it exists in the summary table. If
not, add the field name and whatever else. If the value is not Y, see
if it exists in the summary table and delete it.

Then when you want a summary, you search for the cell phone and present
the features in the summary table. You can link that to the lookup
table based on the field name for descriptions.

This is pretty generic, but I think you get the idea where I'm coming

from.
For what it's worth, since you have 11 tabs in your form, I might
consider using frames with checkboxes or radio buttons for selection. I
think 100 combo boxes would make working with the app a bit of a chore.

For example, on the left hand side of the form I might have 20-30
features down the side with the option group to the right of the
feature. You could stack up quite a few . Then on the right hand side
of the form, you could have a generic list of fields and the memo. As
you get focus to the feature, the fields and memo on the right hand side
get filled in for entries made for that feature. Just a thought in case
you are running out of space. I know if I were working as a user on
your app, I would prefer clicking on a checkbox/radio button vs pressing
on the drop down button and selecting the option from the combo. That
would slow me down as a user.

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

33
by: Joerg Schuster | last post by:
Hello, Python regular expressions must not have more than 100 capturing groups. The source code responsible for this reads as follows: # XXX: <fl> get rid of this limitation! if...
0
by: Johann Blake | last post by:
Hi, I want to capture a signal from the sound card (via microphone or line input) using the DirectX.Sound.CaptureBuffer class. One of the properties that can be setup prior to capturing is...
1
by: khawar | last post by:
my application is in asp.net using C# hi guys having a complicated problem i am using payflowlink to process CC payments I have to send a httppost to their servers. The problem is how do i do a...
8
by: Raj Thakkar | last post by:
Hi, I am currenty working on a site for intranet. I have a user control in the header of every page that will be displayed only if people with certain username are surfing the site. These lists...
10
by: Andrew | last post by:
Hi, I have a messagebox that pops up due to an event. I did it in javascript. ie. alert("Time's up. Assessment Ended"); I want to capture the OK and Cancel events of this alert messagebox. My...
6
by: Ed Leafe | last post by:
I've been approached by a local business that has been advised that they need to start capturing and archiving their instant messaging in order to comply with Sarbanes-Oxley. The company is largely...
3
by: rajibnsu | last post by:
While searching for capturing video with a webcam I god the following code.It gives two errors.Says:The type or namespace name 'WebcamEventArgs' does not exit in the namespace 'WebCam_Capture' (are...
2
by: GS | last post by:
How can one avoid capturing leading empty or blank lines? the data I deal with look like this "will be paid on the dates you specified. xyz supplier amount: $100.52 when: September 07,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.