StarGrabber
Junior App. Developer
- Local time
- Today, 12:03
- Joined
- Oct 21, 2012
- Messages
- 165
Complicated? Your are right, RainLover, but a few weeks ago I've seen even more complicated ones (in this forum)!
Nevertheless we have to find a solution here. U-Doo, you will find the one I developed attached. - The development included several changes / modifications. I...
- renamed the field Date to WODate in tables WO Main, WO Sales and WO Services
- adapted the queries and subforms concerned by that field
- renamed textbox Date to txtDate in form Daily Stats
- made minor code corrections due to this renamed textbox
- renamed textbox text36 to TotalServices in subform Daily Services Query (yes, I know, but I wanted to go with the "naming convention" of this application here!)
- renamed textbox Text112 to txtTotalPayements
- created various sum queries (noticeable by the prefix "qry")
- removed the control source of the corresponding sum textboxes on form Daily Stats
- added some code in the procedure SetDate_Click of the module from Daily Stats in order to fill these textboxes
You should have a look at the control source of Sales Tax: =([Sales Subtotal]+[Labour Subtotal])*Nz([GST])*100/100. I could not find the field(?) GST !
And like RainLover in post # 35 I strongly recommend you the use of a naming convention. You are giving us a pretty hard time!
Nevertheless we have to find a solution here. U-Doo, you will find the one I developed attached. - The development included several changes / modifications. I...
- renamed the field Date to WODate in tables WO Main, WO Sales and WO Services
- adapted the queries and subforms concerned by that field
- renamed textbox Date to txtDate in form Daily Stats
- made minor code corrections due to this renamed textbox
- renamed textbox text36 to TotalServices in subform Daily Services Query (yes, I know, but I wanted to go with the "naming convention" of this application here!)
- renamed textbox Text112 to txtTotalPayements
- created various sum queries (noticeable by the prefix "qry")
- removed the control source of the corresponding sum textboxes on form Daily Stats
- added some code in the procedure SetDate_Click of the module from Daily Stats in order to fill these textboxes
You should have a look at the control source of Sales Tax: =([Sales Subtotal]+[Labour Subtotal])*Nz([GST])*100/100. I could not find the field(?) GST !
And like RainLover in post # 35 I strongly recommend you the use of a naming convention. You are giving us a pretty hard time!