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.
14 2668
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 -
SELECT CASE frmOption1
-
-
CASE 1
-
' do what you want here.
-
CASE 2
-
' etc.
-
END SELECT
-
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.
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.
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?
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.
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?
NeoPa 32,556
Expert Mod 16PB Instructions for attaching a JPEG image to a post.- Create your post.
- Go back and edit your post (I believe you have a 1 hour window nowadays before that expires).
- Manage attachments allows you to link in files with various restrictions depending on the type.
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.
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.
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.
Thank you. It is much appreciated.
NeoPa 32,556
Expert Mod 16PB
Give the thread a bump if you see nothing from me by Thursday morning.
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 - Field; Type; IndexInfo
-
StudentID; Autonumber; PK
-
Family; String; FK
-
Name; String
-
University; String; FK
-
Mark; Numeric
-
LastAttendance; Date/Time
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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 =...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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
|
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...
| |