 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / November 2006Update field
I have created a small database in Access 2003 that is linked to a form in InfoPath to track vacation days. Currently, I cannot find a function that will update the field for total days already taken when new information is submitted from the InfoPath form. I am very inexperienced in both Access and InfoPath and amazed that I was able to even build this form/database so far. Can anyone give me a recommendation on how to update this field? Total Days is a Calculated value. Calculated values should not be stored in a table. They should be calculated whenever you want to present them to a user in a form, report, or query. Calculated fields waste space, take longer to retrieve from disk than the doing the calculation in memenory, and are prone to becoming incorrect if any errors occur. > I have created a small database in Access 2003 that is linked to a form in > InfoPath to track vacation days. Currently, I cannot find a function that > will update the field for total days already taken when new information is > submitted from the InfoPath form. I am very inexperienced in both Access and > InfoPath and amazed that I was able to even build this form/database so far. > Can anyone give me a recommendation on how to update this field? So in other words, I need to do the calculation on the InfoPath side? > Total Days is a Calculated value. Calculated values should not be stored in > a table. They should be calculated whenever you want to present them to a [quoted text clipped - 8 lines] > > InfoPath and amazed that I was able to even build this form/database so far. > > Can anyone give me a recommendation on how to update this field? Since I don't know info path, I can't say for sure, but if you are working with an infopath form, I would say yes. > So in other words, I need to do the calculation on the InfoPath side? > [quoted text clipped - 10 lines] > > > InfoPath and amazed that I was able to even build this form/database so far. > > > Can anyone give me a recommendation on how to update this field? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.