473,320 Members | 1,902 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.

Using Check Box to select a value

10
Hi

I am trying to use check boxes to select values. When I click on a check box it should select RatingID from my tblSysRating.

The check boxes are on my subform and the RatingID text box is on my main form.
Sep 18 '07 #1
14 2668
MMcCarthy
14,534 Expert Mod 8TB
Hi

I am trying to use check boxes to select values. When I click on a check box it should select RatingID from my tblSysRating.

The check boxes are on my subform and the RatingID text box is on my main form.
Assuming your checkboxes are in an option group you can use a SELECT CASE statement on the option group.

Assumptions:

Option Group Name = frmOption1

Expand|Select|Wrap|Line Numbers
  1. SELECT CASE frmOption1
  2.  
  3. CASE 1
  4.     ' do what you want here.
  5. CASE 2
  6.     ' etc.
  7. END SELECT
  8.  
Sep 18 '07 #2
Esprit
10
Hi

Thanks for the reply.

My check boxes are not in a option group mainly for the reason that I need to select more than one value. I have 36 check boxes on my subform (6 rows across, 6 columns down)

The check boxes indicate rating values (Mission Critical, Business Critical, Less Critical). Eg. 1 check box is ticked to indicate Mission Critical and 2 check boxes indicate Business Critical, the return value to the text box RatingID should be the highest value according to ticked boxes, in this case it would be Mission Critical.

Is there a way to do this as the highest rating will need to be reflected accordint to the check boxes selected?

Would appreciate any help with this.
Sep 19 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
Hi

Thanks for the reply.

My check boxes are not in a option group mainly for the reason that I need to select more than one value. I have 36 check boxes on my subform (6 rows across, 6 columns down)

The check boxes indicate rating values (Mission Critical, Business Critical, Less Critical). Eg. 1 check box is ticked to indicate Mission Critical and 2 check boxes indicate Business Critical, the return value to the text box RatingID should be the highest value according to ticked boxes, in this case it would be Mission Critical.

Is there a way to do this as the highest rating will need to be reflected accordint to the check boxes selected?

Would appreciate any help with this.
Perhaps if you explained more about the RatingID which I assume is a lookup table of some kind.
Sep 19 '07 #4
Esprit
10
Hello again

My tblSysRating has 2 fields, ie. RatingID and Rating.
The RatingID is as follows:
Mission Critical
Business Critical
Less Critical

The Rating is:
0 hours
2-8 hours
> 8 hours

Basically when i click a check box in the subform frmSysRating, I would like to have the highest of the check box values displayed in the mainform frmSysEntry.

There are 36 check boxes are on the subform. The text box where the value, which should ideally be the RatingID, to be displayed is on my mainform. The problem is that I need for the user to be able to select more than one check box in the subform and then for the highest RatingID value to be displayed automatically in the mainform according to the criticality.

Does this explanation help?
Sep 19 '07 #5
NeoPa
32,556 Expert Mod 16PB
I can't help feeling you're missing out some fairly critical info here Esprit. Let me jot down my understanding and you tell me if I'm on the right track or not.
You have a [RatingID] value which is selected by the operator by checking a number of the checkboxes which are laid out in your subform (6 x 6).
Each checkbox represents an hour?

If this is wrong then I don't see any way of getting a value from your checkboxes from any information you've yet posted.

Let us know.
Sep 19 '07 #6
Esprit
10
Hi

Maybe I am not explaining this as well as I should.

The tbl SysRating looks like this:

RatingID Rating
Mission Critical 0 hours
Business Critical 2 - 8 hours
Less Critical > hours

The subfrom has 6 headings across and 6 headings down. In the block where each column and row meets there is a check box. The subform is a rating model. The rows are colored to indicate the criticality of the system. If the row is red and that is where the check mark is, then it will automatically select the RatingID of Mission Critical.

Would it be possible to send you a screen shot of my form/subform so that you can get an idea of what it looks like?
Sep 20 '07 #7
NeoPa
32,556 Expert Mod 16PB
Instructions for attaching a JPEG image to a post.
  1. Create your post.
  2. Go back and edit your post (I believe you have a 1 hour window nowadays before that expires).
  3. Manage attachments allows you to link in files with various restrictions depending on the type.
Sep 20 '07 #8
Esprit
10
Hi

Here is a screenshot of what my subform looks like.

[IMG]C:\Documents and Settings\moodlesp\My Documents\ratingmodel.jpg[/IMG]

For the moment, I am using a combo box to allow users to select the criticality rating.

Thanks again. Hope we can find a solution.
Sep 21 '07 #9
NeoPa
32,556 Expert Mod 16PB
Esprit (P Moodles),

I don't think you've understood my instructions very well :(
A simple link to a file on your local PC is not going to work on a web site. You need to upload the file onto the web site before I can see it (See instructions in my earlier post). Uploading it elsewhere would enable you to post a link - but it must exist somewhere which is accessible to the public for me to be able to view it I'm afraid.
Sep 21 '07 #10
Esprit
10
Hi

I am terrible sorry for the misunderstanding.

You will be able to view the screenshot here:
http://mark.alwayspages.com/file/ratingmodel.JPG

Kind regards
Esprit
Sep 25 '07 #11
NeoPa
32,556 Expert Mod 16PB
If a picture paints a thousand words...
I won't comment on your explanation but the picture adds a lot more information.
I'm afraid I have no time to look at this now but with that link I'm sure I can work out what we're dealing with and we can make progress.
It may be Thursday before I have any proper time available but I'll fit in what I can when I can OK.
Sep 25 '07 #12
Esprit
10
Thank you. It is much appreciated.
Sep 25 '07 #13
NeoPa
32,556 Expert Mod 16PB
Give the thread a bump if you see nothing from me by Thursday morning.
Sep 25 '07 #14
NeoPa
32,556 Expert Mod 16PB
I'm able to start looking at this again today.
Can you post the MetaData for [tblSysRating] please. Here is an example of how to post table MetaData :
Table Name=tblStudent
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; Autonumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
Sep 27 '07 #15

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Mohammed Mazid | last post by:
Hi folks! Can anyone please help me with this? I am developing a Quiz program but I am stuck with "multiple answers". Basically I need some sort of code that would select multiple answers...
2
by: phpuser32423 | last post by:
Hi everyone Is it by any chance possible to use mysql and php to auto create the content for drop-down lists on forms by retrieving the values from a database? The reason i ask is that on a site...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
1
by: Daveyk0 | last post by:
Hello there, I have a front end database that I have recently made very many changes to to allow off-line use. I keep copies of the databases on my hard drive and link to them rather than the...
6
by: ransoma22 | last post by:
I developing an application that receive SMS from a connected GSM handphone, e.g Siemens M55, Nokia 6230,etc through the data cable. The application(VB.NET) will receive the SMS automatically,...
2
by: shivendravikramsingh | last post by:
hi friends, i m using a ajax function for retrieving some values from a database table,and display the values in required field,my prob is that the ajax function i m using is working f9 once,but if...
4
by: TechnoAtif | last post by:
Hi ALL I have entered some array values using checkboxes into mysql database through a form. Next iam creating a searchpage where all those cateogories inserted through checkboxes has to be...
1
by: Manil | last post by:
I usually have no problem with Firefox, but here is a rare instance of IE displaying a table with image slices correctly and Firefox adding space where I seemingly have none. Is there anything I can...
5
by: satyabhaskar | last post by:
hi all, In my web page i have created radio buttons dynamically on to the page .....following is my code string Course, Semester, Section; int rowsCount; string con =...
2
by: qwedster | last post by:
Folk! How to programattically check if null value exists in database table (using stored procedure)? I know it's possble in the Query Analyzer (see last SQL query batch statements)? But how...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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...
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...
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
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.