Bump ;)Originally Posted by 4B646D6F78476B646B6D6F676F647E0A0 link=1249305559/0#0 date=1249305559Hi all you budding IT / Coders etc
I have a trip recorder for my car (leased for work) and while it does some great things... It is lacking in some points; it does display all the data in real time... *http://www.auteltech.com/4in1.htm
The maxirecorder is great and monitors any number of *outputs from the cars OBDII connector. *and allows me to export / down load. http://www.auteltech.com/maxirecorder.htm
(Obtained from http://www.interequip.com.au/ *Non SPONSOR LINK)
However it does not quite meet my needs or that of the ATO... *Without lots of manual intervention *:(
Now while I have dabbled and played with Access...
I am not all that comfortable with any number of its features and as I am getting OLD... (Thanks EPIC) *What I knew 12 months ago, has almost been totally lost / forgotten..... *The main file is an Access data base that is updated, when you connect via a USB port and down load. *
But info such as;
1: fuel that can be entered - goes into another file and file format. Displayed in teh system, but not in the access data base.
2: parts and other expenses not able to be entered.
3: No option to tage entries as Business Vs private.
So at present I am exporting the table into excel and manually trying to do things....
Mod teh Access data base and add in a couple of extra tables etc to allow Fuel / expenses to be logged / tracked. *Then I can do up a report to export / print for the ATO / Accountant.
Modify Excel and try to do it all in teh spreadsheet and run a macro to do a lookup and import new fields as and when they are available..
If there was a Brisbane CS with teh skills... It would be easer for me and I guess them... *However, I am open to all reasonable suggestions...
Thanks in Advance..
I guess that with all the coffee. no one has time for apps any more :(