[AccessD] combo from multiple sources

Mark A Matte markamatte at hotmail.com
Tue Feb 20 12:32:48 CST 2007


Thanks Michael,

I think they have that covered...but i will forward it on.

Thanks,

Mark A. Matte


>From: "Michael R Mattys" <mmattys at rochester.rr.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] combo from multiple sources
>Date: Tue, 20 Feb 2007 13:06:03 -0500
>
>Hi Mark,
>
>If those folks can use a wall map, they can download the
>map of New Orleans here:
>http://www.mattysconsulting.com/GalleryFrameset.htm
>
>I made a map of each state also (click on North America)
>and the click the image-map for Louisiana.
>
>Michael R. Mattys
>MapPoint & Access Dev
>www.mattysconsulting.com
>
>----- Original Message -----
>From: "Mark A Matte" <markamatte at hotmail.com>
>To: <accessd at databaseadvisors.com>
>Sent: Tuesday, February 20, 2007 10:28 AM
>Subject: Re: [AccessD] combo from multiple sources
>
>
> > I'm originally from Lafayette, LA...and last month a good friend called
> > for
> > a favor, for her friend, who happened to be a cop.  The favor was Access
> > Related(go figure)...so I looked at the db she was working on.  She had
> > done
> > well with how the form looked and had most of the fields needed in some
> > table somewhere...but 1 PK for all the tables...and it didn't play well
> > with
> > itself.
> >
> > After hearing how they got to this point(here's a little history):  This
> > is
> > to track arrests, drugs, and weapons.  Right now they write it down in a
> > notebook...and then go through the book and count the points of interest
> > to
> > report up.  They have no budget...so she was trying to build it herself.
> > The officers take up a collection each week to have their 'Port-O-Jon"
> > emptied.
> >
> > This kinda ticked me off.  I mean how long has it been...and the cops 
>have
> > to pay for their own toilet?  What other service is local government
> > supposed to be providing, but can't because of lack of 
>equipment/software?
> > How does social services know they need to go check on little mary or
> > bobby
> > to make sure their getting fed???
> >
> >
> > Anyway, they just wanted a little 'shove' in the right direction with 
>the
> > db...but it seemed more like pushing them off a cliff...so I built the
> > data
> > model, all of the forms, and the logic needed to get the reports at the
> > end...and some reports...but I left the db open for her to change the
> > labels, colors, whatever...and to write additional queries as needed.
> >
> > I couldn't charge them.  OK>>>Stepping down from podium<<<<<
> >
> > Sorry about the rant...
> >
> > At one point I wanted to show every name associated with a case in a 
>combo
> > to identify which name was used.  This included alias's which were in a
> > different table.  So I needed data displayed from 2 different 
>tables...and
> > I
> > just used a UNION query as the source.
> >
> > Does this address your question?
> >
> > Thanks,
> >
> > Mark A. Matte
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Find a local pizza place, movie theater, and more….then map the best route! 
http://maps.live.com/?icid=hmtag1&FORM=MGAC01




More information about the AccessD mailing list