![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
I have option groups on a form for which I use Case Event Code in the after update area to convert the selection from the numbers assigned to text which works fine except for one thing.
When I want to allow data to be edited that was previously entered by opening the form in edit mode the selections made do not show up on the form even though the data is in the table converted correctly. Any way to make the selections visible? -- Brian |
#2
|
|||
|
|||
![]()
Hi Brian,
I can't understand what you're trying to communicate. Please take another cut at describing - in meaningful detail- what you are trying to achieve, how you've gone about it so far and what's actually happening. HTH -- -Larry- -- "bdehning" wrote in message ... I have option groups on a form for which I use Case Event Code in the after update area to convert the selection from the numbers assigned to text which works fine except for one thing. When I want to allow data to be edited that was previously entered by opening the form in edit mode the selections made do not show up on the form even though the data is in the table converted correctly. Any way to make the selections visible? -- Brian |
#3
|
|||
|
|||
![]()
Larry,
Option groups are set up such that when you make a selection from shown items on a form, a value is assigned that the user can determine but must be numerical. Using the example from help they show Speedy, United and Federal. Access assigns numbers to the selection so in the table if Speedy is selected it says 1 and not Speedy. The problem is that I want text and not numbers to appear and like the look of option groups. I created tables for each option group with the available selections. I then place the following for example in the After Update area of the Option Group on my form. When Excellent is selected the table correctly displays Excellent. Private Sub Frame58_AfterUpdate() Select Case Frame58.Value Case 1 Evaluation.Value = "Excellent" Case 2 Evaluation.Value = "Good" Case 3 Evaluation.Value = "Average" Case 4 Evaluation.Value = "Below Average" Case 5 Evaluation.Value = "Poor" End Select The problem is that when I go back to edit these fields on the form or bring up the form in edit mode, the check boxes selection in the option group do not show as all are grayed out. I would like the selections to be visible. Do I need to do something different when I convert the data to text to make this happen?-- Brian "Larry Daugherty" wrote: Hi Brian, I can't understand what you're trying to communicate. Please take another cut at describing - in meaningful detail- what you are trying to achieve, how you've gone about it so far and what's actually happening. HTH -- -Larry- -- "bdehning" wrote in message ... I have option groups on a form for which I use Case Event Code in the after update area to convert the selection from the numbers assigned to text which works fine except for one thing. When I want to allow data to be edited that was previously entered by opening the form in edit mode the selections made do not show up on the form even though the data is in the table converted correctly. Any way to make the selections visible? -- Brian |
#4
|
|||
|
|||
![]()
On Fri, 2 Jul 2004 07:21:05 -0700, bdehning wrote:
Larry, Option groups are set up such that when you make a selection from shown items on a form, a value is assigned that the user can determine but must be numerical. Using the example from help they show Speedy, United and Federal. Access assigns numbers to the selection so in the table if Speedy is selected it says 1 and not Speedy. The problem is that I want text and not numbers to appear and like the look of option groups. I created tables for each option group with the available selections. I then place the following for example in the After Update area of the Option Group on my form. When Excellent is selected the table correctly displays Excellent. Private Sub Frame58_AfterUpdate() Select Case Frame58.Value Case 1 Evaluation.Value = "Excellent" Case 2 Evaluation.Value = "Good" Case 3 Evaluation.Value = "Average" Case 4 Evaluation.Value = "Below Average" Case 5 Evaluation.Value = "Poor" End Select The problem is that when I go back to edit these fields on the form or bring up the form in edit mode, the check boxes selection in the option group do not show as all are grayed out. I would like the selections to be visible. Do I need to do something different when I convert the data to text to make this happen?-- Brian "Larry Daugherty" wrote: Hi Brian, I can't understand what you're trying to communicate. Please take another cut at describing - in meaningful detail- what you are trying to achieve, how you've gone about it so far and what's actually happening. HTH -- -Larry- -- "bdehning" wrote in message ... I have option groups on a form for which I use Case Event Code in the after update area to convert the selection from the numbers assigned to text which works fine except for one thing. When I want to allow data to be edited that was previously entered by opening the form in edit mode the selections made do not show up on the form even though the data is in the table converted correctly. Any way to make the selections visible? -- Brian You are miss-using the Option Group. The value of an Option Group is a Number. A table field, bound to the Option Group must be a Number datatype. If you wish to display an Option Group number's associated text in a form or a report, you can do so, using the same Select Case you are now currently using (or the Choose() function), but the value stored in the table must be a number. There is really no need to store the text equivalent in a table. You'll need to go back and re-convert all your text data into number data in a Number (Integer) datatype field. An Update query could do it for you. Then on the form, use the Option Group to enter or change the value. Then, on the form, if you wish to display the text "Good" instead of the radio buttons, use one unbound text control with it's control source set to: =Choose([FieldName],"Excellent","Good","Average","Below Average","Poor") The Choose function can also be used in a Report. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#5
|
|||
|
|||
![]() -- I am trying the record source =Choose([Evaluation],"Excellent","Good","Average","Below Average","Poor") with having changed the table data type. The text box with the above record source on the form says error. Brian "fredg" wrote: On Fri, 2 Jul 2004 07:21:05 -0700, bdehning wrote: Larry, Option groups are set up such that when you make a selection from shown items on a form, a value is assigned that the user can determine but must be numerical. Using the example from help they show Speedy, United and Federal. Access assigns numbers to the selection so in the table if Speedy is selected it says 1 and not Speedy. The problem is that I want text and not numbers to appear and like the look of option groups. I created tables for each option group with the available selections. I then place the following for example in the After Update area of the Option Group on my form. When Excellent is selected the table correctly displays Excellent. Private Sub Frame58_AfterUpdate() Select Case Frame58.Value Case 1 Evaluation.Value = "Excellent" Case 2 Evaluation.Value = "Good" Case 3 Evaluation.Value = "Average" Case 4 Evaluation.Value = "Below Average" Case 5 Evaluation.Value = "Poor" End Select The problem is that when I go back to edit these fields on the form or bring up the form in edit mode, the check boxes selection in the option group do not show as all are grayed out. I would like the selections to be visible. Do I need to do something different when I convert the data to text to make this happen?-- Brian "Larry Daugherty" wrote: Hi Brian, I can't understand what you're trying to communicate. Please take another cut at describing - in meaningful detail- what you are trying to achieve, how you've gone about it so far and what's actually happening. HTH -- -Larry- -- "bdehning" wrote in message ... I have option groups on a form for which I use Case Event Code in the after update area to convert the selection from the numbers assigned to text which works fine except for one thing. When I want to allow data to be edited that was previously entered by opening the form in edit mode the selections made do not show up on the form even though the data is in the table converted correctly. Any way to make the selections visible? -- Brian You are miss-using the Option Group. The value of an Option Group is a Number. A table field, bound to the Option Group must be a Number datatype. If you wish to display an Option Group number's associated text in a form or a report, you can do so, using the same Select Case you are now currently using (or the Choose() function), but the value stored in the table must be a number. There is really no need to store the text equivalent in a table. You'll need to go back and re-convert all your text data into number data in a Number (Integer) datatype field. An Update query could do it for you. Then on the form, use the Option Group to enter or change the value. Then, on the form, if you wish to display the text "Good" instead of the radio buttons, use one unbound text control with it's control source set to: =Choose([FieldName],"Excellent","Good","Average","Below Average","Poor") The Choose function can also be used in a Report. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#6
|
|||
|
|||
![]()
On Fri, 2 Jul 2004 15:58:01 -0700, bdehning wrote:
-- I am trying the record source =Choose([Evaluation],"Excellent","Good","Average","Below Average","Poor") with having changed the table data type. The text box with the above record source on the form says error. Brian "fredg" wrote: On Fri, 2 Jul 2004 07:21:05 -0700, bdehning wrote: Larry, Option groups are set up such that when you make a selection from shown items on a form, a value is assigned that the user can determine but must be numerical. Using the example from help they show Speedy, United and Federal. Access assigns numbers to the selection so in the table if Speedy is selected it says 1 and not Speedy. The problem is that I want text and not numbers to appear and like the look of option groups. I created tables for each option group with the available selections. I then place the following for example in the After Update area of the Option Group on my form. When Excellent is selected the table correctly displays Excellent. Private Sub Frame58_AfterUpdate() Select Case Frame58.Value Case 1 Evaluation.Value = "Excellent" Case 2 Evaluation.Value = "Good" Case 3 Evaluation.Value = "Average" Case 4 Evaluation.Value = "Below Average" Case 5 Evaluation.Value = "Poor" End Select The problem is that when I go back to edit these fields on the form or bring up the form in edit mode, the check boxes selection in the option group do not show as all are grayed out. I would like the selections to be visible. Do I need to do something different when I convert the data to text to make this happen?-- Brian "Larry Daugherty" wrote: Hi Brian, I can't understand what you're trying to communicate. Please take another cut at describing - in meaningful detail- what you are trying to achieve, how you've gone about it so far and what's actually happening. HTH -- -Larry- -- "bdehning" wrote in message ... I have option groups on a form for which I use Case Event Code in the after update area to convert the selection from the numbers assigned to text which works fine except for one thing. When I want to allow data to be edited that was previously entered by opening the form in edit mode the selections made do not show up on the form even though the data is in the table converted correctly. Any way to make the selections visible? -- Brian You are miss-using the Option Group. The value of an Option Group is a Number. A table field, bound to the Option Group must be a Number datatype. If you wish to display an Option Group number's associated text in a form or a report, you can do so, using the same Select Case you are now currently using (or the Choose() function), but the value stored in the table must be a number. There is really no need to store the text equivalent in a table. You'll need to go back and re-convert all your text data into number data in a Number (Integer) datatype field. An Update query could do it for you. Then on the form, use the Option Group to enter or change the value. Then, on the form, if you wish to display the text "Good" instead of the radio buttons, use one unbound text control with it's control source set to: =Choose([FieldName],"Excellent","Good","Average","Below Average","Poor") The Choose function can also be used in a Report. -- Fred Please only reply to this newsgroup. I do not reply to personal email. The Field [Evaluation], in the Table, is now a number datatype, with values of 1,2,3,4,5. The Choose function is placed in an UNBOUND Control's Control Source (not a Record Source). 1) If the Name of the Control is "Evaluation" you will get an error. change the Control's Name to something else. 2) Perhaps you are getting a record that is not yet filled in. Change the control source to: =IIf([Evaluation] 0, Choose([Evaluation], "Excellent", "Good","Average","Below Average","Poor"),"N/A") -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#7
|
|||
|
|||
![]()
Thanks Fred. Changing the name did the trick.
Why won't Microsoft develop option groups to display text in tables rather than numbers like other databases? -- Brian "fredg" wrote: On Fri, 2 Jul 2004 15:58:01 -0700, bdehning wrote: -- I am trying the record source =Choose([Evaluation],"Excellent","Good","Average","Below Average","Poor") with having changed the table data type. The text box with the above record source on the form says error. Brian "fredg" wrote: On Fri, 2 Jul 2004 07:21:05 -0700, bdehning wrote: Larry, Option groups are set up such that when you make a selection from shown items on a form, a value is assigned that the user can determine but must be numerical. Using the example from help they show Speedy, United and Federal. Access assigns numbers to the selection so in the table if Speedy is selected it says 1 and not Speedy. The problem is that I want text and not numbers to appear and like the look of option groups. I created tables for each option group with the available selections. I then place the following for example in the After Update area of the Option Group on my form. When Excellent is selected the table correctly displays Excellent. Private Sub Frame58_AfterUpdate() Select Case Frame58.Value Case 1 Evaluation.Value = "Excellent" Case 2 Evaluation.Value = "Good" Case 3 Evaluation.Value = "Average" Case 4 Evaluation.Value = "Below Average" Case 5 Evaluation.Value = "Poor" End Select The problem is that when I go back to edit these fields on the form or bring up the form in edit mode, the check boxes selection in the option group do not show as all are grayed out. I would like the selections to be visible. Do I need to do something different when I convert the data to text to make this happen?-- Brian "Larry Daugherty" wrote: Hi Brian, I can't understand what you're trying to communicate. Please take another cut at describing - in meaningful detail- what you are trying to achieve, how you've gone about it so far and what's actually happening. HTH -- -Larry- -- "bdehning" wrote in message ... I have option groups on a form for which I use Case Event Code in the after update area to convert the selection from the numbers assigned to text which works fine except for one thing. When I want to allow data to be edited that was previously entered by opening the form in edit mode the selections made do not show up on the form even though the data is in the table converted correctly. Any way to make the selections visible? -- Brian You are miss-using the Option Group. The value of an Option Group is a Number. A table field, bound to the Option Group must be a Number datatype. If you wish to display an Option Group number's associated text in a form or a report, you can do so, using the same Select Case you are now currently using (or the Choose() function), but the value stored in the table must be a number. There is really no need to store the text equivalent in a table. You'll need to go back and re-convert all your text data into number data in a Number (Integer) datatype field. An Update query could do it for you. Then on the form, use the Option Group to enter or change the value. Then, on the form, if you wish to display the text "Good" instead of the radio buttons, use one unbound text control with it's control source set to: =Choose([FieldName],"Excellent","Good","Average","Below Average","Poor") The Choose function can also be used in a Report. -- Fred Please only reply to this newsgroup. I do not reply to personal email. The Field [Evaluation], in the Table, is now a number datatype, with values of 1,2,3,4,5. The Choose function is placed in an UNBOUND Control's Control Source (not a Record Source). 1) If the Name of the Control is "Evaluation" you will get an error. change the Control's Name to something else. 2) Perhaps you are getting a record that is not yet filled in. Change the control source to: =IIf([Evaluation] 0, Choose([Evaluation], "Excellent", "Good","Average","Below Average","Poor"),"N/A") -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#8
|
|||
|
|||
![]()
Hi Brian,
If you were provided the Solutions database with your Access/Office materials I commend you to it. I'm pretty sure that everyone is given a copy of the Northwinds database in their version. In the case of Solutions you get directed examples of techniques (maybe that's just the developer tools). In Northwind there are lots of examples but you have to go into design mode and chase and analyze the code yourself. In addition, there are books about getting going with Access. One good beginning level book is "Microsoft Access [yourversion] Step by Step" from Microsoft Press. You may be well beyond that level and are aware that there are books that are useful at just about any level of expertise. I suggest that, before you go looking for help in getting something in Access to work in some way inconsistent with the tools given, you first try to achieve your objectives by following working examples and only then modify the working models in the direction you're trying to go. If things break during that process you'll quickly understand what you did, and soon thereafter, why it broke. As to the feature list in Access, everyone has something that they'd like to see done better (or differently). You might do a google search of the Access groups on "Wish List" and find a contact point in Microsoft to send your suggestion. They don't promise response nor action but don't despair. As other developers have developed solutions to the things that Microsoft couldn't be bothered with, Lo and Behold! MS managed to incorporate their solutions into later versions. -- -Larry- -- "bdehning" wrote in message ... Thanks Fred. Changing the name did the trick. Why won't Microsoft develop option groups to display text in tables rather than numbers like other databases? -- Brian "fredg" wrote: On Fri, 2 Jul 2004 15:58:01 -0700, bdehning wrote: -- I am trying the record source =Choose([Evaluation],"Excellent","Good","Average","Below Average","Poor") with having changed the table data type. The text box with the above record source on the form says error. Brian "fredg" wrote: On Fri, 2 Jul 2004 07:21:05 -0700, bdehning wrote: Larry, Option groups are set up such that when you make a selection from shown items on a form, a value is assigned that the user can determine but must be numerical. Using the example from help they show Speedy, United and Federal. Access assigns numbers to the selection so in the table if Speedy is selected it says 1 and not Speedy. The problem is that I want text and not numbers to appear and like the look of option groups. I created tables for each option group with the available selections. I then place the following for example in the After Update area of the Option Group on my form. When Excellent is selected the table correctly displays Excellent. Private Sub Frame58_AfterUpdate() Select Case Frame58.Value Case 1 Evaluation.Value = "Excellent" Case 2 Evaluation.Value = "Good" Case 3 Evaluation.Value = "Average" Case 4 Evaluation.Value = "Below Average" Case 5 Evaluation.Value = "Poor" End Select The problem is that when I go back to edit these fields on the form or bring up the form in edit mode, the check boxes selection in the option group do not show as all are grayed out. I would like the selections to be visible. Do I need to do something different when I convert the data to text to make this happen?-- Brian "Larry Daugherty" wrote: Hi Brian, I can't understand what you're trying to communicate. Please take another cut at describing - in meaningful detail- what you are trying to achieve, how you've gone about it so far and what's actually happening. HTH -- -Larry- -- "bdehning" wrote in message ... I have option groups on a form for which I use Case Event Code in the after update area to convert the selection from the numbers assigned to text which works fine except for one thing. When I want to allow data to be edited that was previously entered by opening the form in edit mode the selections made do not show up on the form even though the data is in the table converted correctly. Any way to make the selections visible? -- Brian You are miss-using the Option Group. The value of an Option Group is a Number. A table field, bound to the Option Group must be a Number datatype. If you wish to display an Option Group number's associated text in a form or a report, you can do so, using the same Select Case you are now currently using (or the Choose() function), but the value stored in the table must be a number. There is really no need to store the text equivalent in a table. You'll need to go back and re-convert all your text data into number data in a Number (Integer) datatype field. An Update query could do it for you. Then on the form, use the Option Group to enter or change the value. Then, on the form, if you wish to display the text "Good" instead of the radio buttons, use one unbound text control with it's control source set to: =Choose([FieldName],"Excellent","Good","Average","Below Average","Poor") The Choose function can also be used in a Report. -- Fred Please only reply to this newsgroup. I do not reply to personal email. The Field [Evaluation], in the Table, is now a number datatype, with values of 1,2,3,4,5. The Choose function is placed in an UNBOUND Control's Control Source (not a Record Source). 1) If the Name of the Control is "Evaluation" you will get an error. change the Control's Name to something else. 2) Perhaps you are getting a record that is not yet filled in. Change the control source to: =IIf([Evaluation] 0, Choose([Evaluation], "Excellent", "Good","Average","Below Average","Poor"),"N/A") -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#9
|
|||
|
|||
![]()
Thanks Larry
I will take your suggestion and run with it. -- Brian "Larry Daugherty" wrote: Hi Brian, If you were provided the Solutions database with your Access/Office materials I commend you to it. I'm pretty sure that everyone is given a copy of the Northwinds database in their version. In the case of Solutions you get directed examples of techniques (maybe that's just the developer tools). In Northwind there are lots of examples but you have to go into design mode and chase and analyze the code yourself. In addition, there are books about getting going with Access. One good beginning level book is "Microsoft Access [yourversion] Step by Step" from Microsoft Press. You may be well beyond that level and are aware that there are books that are useful at just about any level of expertise. I suggest that, before you go looking for help in getting something in Access to work in some way inconsistent with the tools given, you first try to achieve your objectives by following working examples and only then modify the working models in the direction you're trying to go. If things break during that process you'll quickly understand what you did, and soon thereafter, why it broke. As to the feature list in Access, everyone has something that they'd like to see done better (or differently). You might do a google search of the Access groups on "Wish List" and find a contact point in Microsoft to send your suggestion. They don't promise response nor action but don't despair. As other developers have developed solutions to the things that Microsoft couldn't be bothered with, Lo and Behold! MS managed to incorporate their solutions into later versions. -- -Larry- -- "bdehning" wrote in message ... Thanks Fred. Changing the name did the trick. Why won't Microsoft develop option groups to display text in tables rather than numbers like other databases? -- Brian "fredg" wrote: On Fri, 2 Jul 2004 15:58:01 -0700, bdehning wrote: -- I am trying the record source =Choose([Evaluation],"Excellent","Good","Average","Below Average","Poor") with having changed the table data type. The text box with the above record source on the form says error. Brian "fredg" wrote: On Fri, 2 Jul 2004 07:21:05 -0700, bdehning wrote: Larry, Option groups are set up such that when you make a selection from shown items on a form, a value is assigned that the user can determine but must be numerical. Using the example from help they show Speedy, United and Federal. Access assigns numbers to the selection so in the table if Speedy is selected it says 1 and not Speedy. The problem is that I want text and not numbers to appear and like the look of option groups. I created tables for each option group with the available selections. I then place the following for example in the After Update area of the Option Group on my form. When Excellent is selected the table correctly displays Excellent. Private Sub Frame58_AfterUpdate() Select Case Frame58.Value Case 1 Evaluation.Value = "Excellent" Case 2 Evaluation.Value = "Good" Case 3 Evaluation.Value = "Average" Case 4 Evaluation.Value = "Below Average" Case 5 Evaluation.Value = "Poor" End Select The problem is that when I go back to edit these fields on the form or bring up the form in edit mode, the check boxes selection in the option group do not show as all are grayed out. I would like the selections to be visible. Do I need to do something different when I convert the data to text to make this happen?-- Brian "Larry Daugherty" wrote: Hi Brian, I can't understand what you're trying to communicate. Please take another cut at describing - in meaningful detail- what you are trying to achieve, how you've gone about it so far and what's actually happening. HTH -- -Larry- -- "bdehning" wrote in message ... I have option groups on a form for which I use Case Event Code in the after update area to convert the selection from the numbers assigned to text which works fine except for one thing. When I want to allow data to be edited that was previously entered by opening the form in edit mode the selections made do not show up on the form even though the data is in the table converted correctly. Any way to make the selections visible? -- Brian You are miss-using the Option Group. The value of an Option Group is a Number. A table field, bound to the Option Group must be a Number datatype. If you wish to display an Option Group number's associated text in a form or a report, you can do so, using the same Select Case you are now currently using (or the Choose() function), but the value stored in the table must be a number. There is really no need to store the text equivalent in a table. You'll need to go back and re-convert all your text data into number data in a Number (Integer) datatype field. An Update query could do it for you. Then on the form, use the Option Group to enter or change the value. Then, on the form, if you wish to display the text "Good" instead of the radio buttons, use one unbound text control with it's control source set to: =Choose([FieldName],"Excellent","Good","Average","Below Average","Poor") The Choose function can also be used in a Report. -- Fred Please only reply to this newsgroup. I do not reply to personal email. The Field [Evaluation], in the Table, is now a number datatype, with values of 1,2,3,4,5. The Choose function is placed in an UNBOUND Control's Control Source (not a Record Source). 1) If the Name of the Control is "Evaluation" you will get an error. change the Control's Name to something else. 2) Perhaps you are getting a record that is not yet filled in. Change the control source to: =IIf([Evaluation] 0, Choose([Evaluation], "Excellent", "Good","Average","Below Average","Poor"),"N/A") -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
making option groups visible/invisible based on another option group selection | Emma | Using Forms | 3 | June 24th, 2004 05:29 AM |
Combo Box selection disappearing on new record and change of option selection | EmmA | Using Forms | 2 | June 17th, 2004 02:21 AM |
Cancel Change In Option Group | Corrine | New Users | 1 | June 8th, 2004 12:07 PM |
Option group selection as query criteria | Tara | Running & Setting Up Queries | 1 | May 28th, 2004 04:18 PM |
Option Group values converted to Text String values in reports | Fons Ponsioen | Setting Up & Running Reports | 1 | May 18th, 2004 10:50 PM |