Jun 9 2006, 06:34 AM
i have a text box that calulates the total hours of an employee, now i want to take this value and store it into one of my fields.
how do i do this?
Jun 9 2006, 06:43 AM
Storing calculated values is generally considered a very bad idea. Rather than store the value, you just recalulate it as needed.
Jun 9 2006, 06:56 AM
The thing is though, i need to store it as i have a module that needs to get that value. the module loops through every employee and calculates the total wage owed... but i cannot for some reason, even though the form is open. the form doesn't seem to do the calculation when the module runs.
Jun 9 2006, 06:59 AM
I would try to track down why you cannot calculate this value (maybe is a timing thing, maybe the way it is being referenced, etc.) rather than breaking normalization rules. You may want to post more details as to the specific problem and see if someone can help you with that.
Jun 9 2006, 07:23 AM
well if it is a timing thing, which was my original thought, how do i make sure that it isn't. can i wait for the form to calculate before continuing with the rest of the process?
Jun 13 2006, 07:08 AM
The only way I know is to step through the code line by line or use Debug.Print to show what the variables are during the life cycle of the code. Debug.Print will print them to the Immediate window.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here