Creating an Access Form to Track Mileage
Posted on 2003-11-12
I am trying to create a form that my employees can use to track their business mileage expense. The database consists of only a few fields:
I would like the person to be able to enter the starting date for the week in an unbound text box. Directly under this text box are 7 rows as follows:
ENTER DaTE (UNBOUND TEXT BOX)
Date mileage Trip Reason Comments
dd/mm/yy (automatically incremented by 1 day based on date entered above)
I would like the 7 rows of Dates automatically populated based on the date that was initially entered in the unbound text box at the top of the form. This would enable the employee to enter 1 week of mileage detail at one shot.
Once the employee fills all the boxes in I would like have him click a submit button that would post everything into the database, excluding any row that had "zero" mileage.
Any thoughts or suggestions would be appreciated. In addition if anyone knows of some code that is out there that I could use please let me know.