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
|
|||
|
|||
Toggle help
I'm stuck. Trying to create a toggle button on a form that will enter a
specific value into a field on a table when clicked. Example: Field on table is automobile makers. I want a click on the toggle button (captioned as FORD) on the form to record Ford. I s there a way to set the value so a the onclick enters this data in the table? Any help is greatly appreciated. Thanks! |
#2
|
|||
|
|||
Toggle help
Yes, but ... why?
If you have a form that has one button for each auto maker, then won't you have to modify that form (and any underlying queries, reports, etc.) when you have a new auto maker (or an old one declares bankruptcy)? Another approach would be to use a combobox that lists all available automakers (from a tlkpAutoMaker table), then bind the control to a field that captures the AutoMaker. This way, when you need to change/add an auto maker, you just do it on the tlkpAutoMaker table. Regards Jeff Boyce Microsoft Office/Access MVP "Superfuzz" u43125@uwe wrote in message news:831e6385bb0b7@uwe... I'm stuck. Trying to create a toggle button on a form that will enter a specific value into a field on a table when clicked. Example: Field on table is automobile makers. I want a click on the toggle button (captioned as FORD) on the form to record Ford. I s there a way to set the value so a the onclick enters this data in the table? Any help is greatly appreciated. Thanks! |
#3
|
|||
|
|||
Toggle help
Thanks for your feedback.
Yes I could a ComboBox and the problem would be solved. However I'm trying to make the form 100% visual and without text. My toggle button has a photo of a Ford car. Best regards, SF Jeff Boyce wrote: Yes, but ... why? If you have a form that has one button for each auto maker, then won't you have to modify that form (and any underlying queries, reports, etc.) when you have a new auto maker (or an old one declares bankruptcy)? Another approach would be to use a combobox that lists all available automakers (from a tlkpAutoMaker table), then bind the control to a field that captures the AutoMaker. This way, when you need to change/add an auto maker, you just do it on the tlkpAutoMaker table. Regards Jeff Boyce Microsoft Office/Access MVP I'm stuck. Trying to create a toggle button on a form that will enter a specific value into a field on a table when clicked. [quoted text clipped - 7 lines] Any help is greatly appreciated. Thanks! |
#4
|
|||
|
|||
Toggle help
Assuming your user is into cars and recognizes a Ford from a Dodge. If
they are getting the information off of a form that is printed you will have better results having them in a very simplistic sense matching letters then trying to match letters with a picture of an auto that in a while will be out or date or not match exactly with the model of the car. If you are bound and determined to use a picture then use the Ford logo rather than a particular model. It will make your training easier. Ron |
#5
|
|||
|
|||
Toggle help
Thanks all for explaining several reasons why I probably shouldn't do this.
However unsound my request may seem I still would like to know how I could accomplish this. If anyone has a solution to how I could make the toggles i'm discribing for my 100% visual form I'd be very appreciative. I've already spent a lot of time try to make it work myself and I'm getting no where. Best regards, Ron2006 wrote: Assuming your user is into cars and recognizes a Ford from a Dodge. If they are getting the information off of a form that is printed you will have better results having them in a very simplistic sense matching letters then trying to match letters with a picture of an auto that in a while will be out or date or not match exactly with the model of the car. If you are bound and determined to use a picture then use the Ford logo rather than a particular model. It will make your training easier. Ron -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|