Arthur Fuller
fuller.artful at gmail.com
Sat Oct 1 13:25:34 CDT 2011
I confess that I use a version of the TIme-Billing app that was a sample app in Office 2007. I reshaped it to suit my needs and then have used it ever since. It works excellenty for my meagre requirements -- single or occasionally assistant developer, and dealing with several projects. and allowing me to assign an hour to this task and and two hours to that task, and print an invoice and send same to the client in question as a PDF file. That's enough for me, and also for Revenue Canada, our equivalent of the IRS. I needed to add a couple of columns to the sample app, and to modify the queries and reports to reflect these new columns, but basically I changed almost nothing in the sample app, and it works wonderfully for my modest needs. I have not bothered to migrate it to SQL Server, since I am the only user of this db, but I have migrated dozens of client dbs and it's a breeze to go there. I back up the BE daily and why go further if the existing solution works? Way back when, I believed the opposite: "If it works, break it, and think of something better." Well, I don't have enough time remaining in my life to continue upon this path. Younger souls may have the time and energy, but I'm out of both. If it works, leave it alone! That's my current motto. You know what, I just lied. I cannot leave a well-bed baby alone. I have to go back and tend to her. In terms of code, this means Refactoring, and even if the client is not willing to pay, I can't help revisiting apps delivered and accepted. I revisit them compulsively, and I look at the 20+lines of code and think, couldn't this be 10 lines? And so on. I can't help it, even though the last invoice to the given client might have been a year ago. I return to the code and inspect it and think, "What an idiot On Sat, Oct 1, 2011 at 11:55 AM, jwcolby <jwcolby at colbyconsulting.com>wrote: > I had to relink my views (SQL Server). It seems that I had not stored the > password in the link or something. The tables were r/w but the views were > ro. > > So it appears that 4 hours later I am able to use my billing app in 2010. > It still gives the same error message in 2003. > > Unfortunately I use Outlook to send/receive email and it remains to be > configured. or move to Blat or the likes. > > -- > John W. Colby > Colby Consulting > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd> > Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com> >