[AccessD] OT Friday Stuff

LOL
Actually, I was envisioning standing atop a high rise building with a cape
billowing in the wind! This bureaucrat was from Madison, WI (state capital).

LOL again!
But I guess an old farmer would be more fitting since this is when I worked
for the Agricultural Land Conservation Dept. I did stand out in a lot of
fields (and other stuff too).
:o)

John B.
PS: My degree (primary) is Natural Resources Sciences.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Michael R
> Mattys
> Sent: Friday, November 14, 2003 10:23 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] OT Friday Stuff
>
>
> John,
>
> I was going to thank you last night
> for sharing your expeiences ...
> wondered why you were out standing in
> your field ... you old farmer :)
>
> Michael R. Mattys
> www.mattysconsulting.com
>
>
>
> ----- Original Message -----
> From: "John Bartow" <john at winhaven.net>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Friday, November 14, 2003 11:15 AM
> Subject: RE: [AccessD] OT Friday Stuff
>
>
> > Reminds me of a state bureaucrat I used to know. For years she
> would send
> > out an annual update of a "Time Reporting" database application that the
> > local employees used to keep track of the time they spent on
> state funded
> > programs. In the data entry they would have to enter the date, the year
> and
> > the quarter. The only thing she changed over the entire time
> she did this
> > was to add the new year and quarters to lookup tables (4 digit
> number for
> > year e.g. "1999" and: 99-1, 99-2, 99-3, 99-4 for the quarters).
> Of course
> > she also had to adjust the reports so they would print out for the new
> year
> > and/or quarter. The reports had hard coded year and/or quarter - there
> were
> > 5 reports. There was no routine to get rid of the old data and there was
> no
> > way to print out reports or use the old data in any manner
> (which a number
> > of local people wanted to do so they started to duplicate the
> database and
> > keep the old application in order to be able to get the reports for each
> > year. Some offices had 5 of these applications/databases set up!
> >
> > The funny part: She really wasn't aware that she could just let
> the users
> > enter the date and filter the reports for year and/or quarter based on
> that!
> >
> > Well, we fixed all that and she has never issued another update (wipes
> sweat
> > from his forehead).
> >
> > John B.
> > Another complicated programming issue solved by (drum roll and
> horn blasts
> > please) Super-Programmer!
> > (As he places his hands on his hips and thrusts out his chest!)
> > ;o)
> >
> >
> > > -----Original Message-----
> > > From: accessd-bounces at databaseadvisors.com
> > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
> > > Hollis,Virginia
> > > Sent: Friday, November 14, 2003 8:57 AM
> > > To: 'accessd at databaseadvisors.com'
> > > Subject: [AccessD] OT Friday Stuff
> > >
> > >
> > > Ok, good one for a Friday. I just had someone call me that is
> > > trying to work
> > > on a database. This database tracks data for each year, 2001,
> > > 2002, and they
> > > are trying to enter the new data for 2003.
> > >
> > > Here is the good part - they can't figure out why the previous
> > > years data is
> > > changing when they change something - they saved the form as
> a new form
> > > "2003".
> > >
> > > Virginia
> > > _______________________________________________
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > >
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>