Search results

Im not married to anything. No one has every said anything about a drop down box until now, and I havent even thought of that.. If I were to use a drop down box how do I get the value from it to be subtracted from the section total? Im pretty sure I can use a query for that but would I have to...

I know youre not supposed to save calculated values i have read it everywhere... If anyone else could give a proper solution instead of saving it im all ears.

Is there anyway to use the After Update feature to write a VBA code for an IIf statement... Im trying to store the value of a field that gives me a number based on which radio button is pushed and it seems that absolutely no one has heard of this...

I guess I am confusing everyone when I say calculated data... The only reason this is calculated is because I am using an IIf statement in the control source to spit out a number a different button is pressed... So therefore instead of being able to bind the textbox to the form that IIf...

No the form is bound to my results table and I do not want the user to enter the deductions that means they could enter less deductions than necesary.. Thats why it is important that the deductions is based on which button they push because the text box that shows the deductions will be locked...

I was using a IIf statement to give back a number is there another way to do this? I was unaware that I could set the values of option buttons to what I need them to be.

I work for a major baking manufacturer and they have to score bread daily to make sure it meets standards. the user goes through a bunch of steps and then starts the scoring process based on criteria on the form there are about 10 sections a loaf of bread is scored on each section has a good...

Im really not understanding what isnt clear... I dont want it done a certain anything that works would be great... Doing it through VBA or Binding the query that would work. anything.

I just explained it... Does that not make sense? The user is trying to score an item they have to click a button to show what score it received in multiple sections.. Which are the radio buttons. Then depending on what they choose it returns certain deductions i need to record those deductions...

Im not really sure how else to explain it... In one column the have the scoring option where you can click Target, Actionable, or Unacceptable. Then in the next column is the deductions and based on which radio button you clicked it returns a 0,8, or 15 by using this code...

Hey, I am trying to get a value from a textbox into a table I created... The textbox "calculates a number based on which radio button is pressed example if radio button 1 is pressed it returns 0 if radio button two is pressed it returns 8 and if radio button 3 is pressed it returns 15." I need...

Thanks everyone I am coming into the access database I did not create it so I was just wondering if there was an easier way instead of having to go change everything already in there.. But I see that I will have to thanks again!

I am trying to figure how to get some information to show up in chronological order. For example, It is showing up like this.. Week 1 Week 10 Week 2 Week 20 Week 3 Week 4 and so on I want it like week 1 week 2 week 3 week 4 week 10 week 20 Anyway i can do this? please help