I am newbie to Access 2007 programming so need some help explaining what I need to do to get I am looking to do.
I am creating an application in access 2007 with a SQL Backend. I have a form where there is a combo box that when selected populates a textbox with the standard value for that questions.
There is another textbox that the client specific values are entered in.
Once that is entered there is a textbox that compares the standard and the client specific and yields a value of either Yes or No. If there is a numeric value( which there are some) that is entered into the client and there is a numeric value in the standard it calculates the difference and input it into a textbox.
For some of the questions there a value that is used to calculate the hours for that question. For example if there are 2000 items standard and there is 4000 items in realty for the client so the difference is 2000. If the standard is a text(Yes or No) I have specified that as variant and calculated that to be a 0
In order for more hours to be added to the estimate there is a threshold of 4000 items before the additional hours are added to the standard
For each question there is a standard amount of hours that if the client specific value doesn't equal to the standard the hours will change that amount.
What I am wanting to do with a Click Procedure using a command button to accomplish the following:
1.Take the value of the difference textbox and if greater then 0 and compare that to the threshold of hours as discussed above and determine the amount of hours that need to be added.
2. Using the standard hours for that question take what is calculated in 1 and add that to the standard.
3. Once complete this will be added as a line item into a table with each question having a value.
Let me know if there are any questions but if possible put as much code as possible as I am unsure on even how to begin and have looked online and in forums before posting.
I am creating an application in access 2007 with a SQL Backend. I have a form where there is a combo box that when selected populates a textbox with the standard value for that questions.
There is another textbox that the client specific values are entered in.
Once that is entered there is a textbox that compares the standard and the client specific and yields a value of either Yes or No. If there is a numeric value( which there are some) that is entered into the client and there is a numeric value in the standard it calculates the difference and input it into a textbox.
For some of the questions there a value that is used to calculate the hours for that question. For example if there are 2000 items standard and there is 4000 items in realty for the client so the difference is 2000. If the standard is a text(Yes or No) I have specified that as variant and calculated that to be a 0
In order for more hours to be added to the estimate there is a threshold of 4000 items before the additional hours are added to the standard
For each question there is a standard amount of hours that if the client specific value doesn't equal to the standard the hours will change that amount.
What I am wanting to do with a Click Procedure using a command button to accomplish the following:
1.Take the value of the difference textbox and if greater then 0 and compare that to the threshold of hours as discussed above and determine the amount of hours that need to be added.
2. Using the standard hours for that question take what is calculated in 1 and add that to the standard.
3. Once complete this will be added as a line item into a table with each question having a value.
Let me know if there are any questions but if possible put as much code as possible as I am unsure on even how to begin and have looked online and in forums before posting.
Last edited: