Need to use up some points so I'd like your opinion on how to implement an application. I have some ideas but would like to hear what you think.
I've been asked to develop an app for a cab company. They have dispatch sheets which consist of logging the time of call, Origin, Destination, cab#, amt of fare, and CC fee (if cust. charges). The app will run 24 hours/day. There are 3 shifts, 5a-5p, 5p-5a,12mid-1a (13 hours). All calls must be saved. Reports will be needed for drivers total fares per day/month/year, etc. It must use an Access DB. I'll be using VB 6.
Questions: Should I develop an ActiveX Component for the Dispatch sheets or use a third-party, editable grid control (which I have)? How should the shifts be saved so that reports can be generated? I'm guessing that approximately 3,500 calls/month will have to be logged, maybe more.
Any other information that's helpful is appreciated.