[AccessD] Billing "Fully working" in 2010

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>
>



More information about the AccessD mailing list