<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>...ok ...change in subject to be PC ...but anytime
one of our own has such a major life change, it is ON TOPIC as far as I'm
concerned ...Pamela had already sent me some pics ...just thought the rest of
AccessD would like to know how great you looked :)))</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>William Hindman<BR>"War is an ugly thing but not the ugliest of things; the
decayed and degraded state of moral and patriotic feelings which thinks that
nothing is worth war is much worse. A man who has nothing for which he is
willing to fight, nothing which is more important than his own personal safety,
is a miserable creature and has no chance of being free unless made and kept so
by the exertions of better men than himself." John Stuart Mill <BR></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=roz.clarke@donnslaw.co.uk href="mailto:roz.clarke@donnslaw.co.uk">Roz
Clarke</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:'accessd@databaseadvisors.com'">'accessd@databaseadvisors.com'</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, April 02, 2003 8:00
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Roz Got Married
...was Updating queries with linked tables</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=083124612-02042003><FONT face=Arial color=#0000ff
size=2>LOL</FONT></SPAN></DIV>
<DIV><SPAN class=083124612-02042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=083124612-02042003><FONT face=Arial color=#0000ff size=2>OK
I'll tell, but remember I'm supposed to be setting a good
example!!</FONT></SPAN></DIV>
<DIV><SPAN class=083124612-02042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=083124612-02042003><FONT face=Arial color=#0000ff size=2>Pics
aren't up anywhere as yet, hopefully we can get that done tonight before folks
lose interest :)</FONT></SPAN></DIV>
<DIV><SPAN class=083124612-02042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=083124612-02042003><FONT face=Arial color=#0000ff size=2>As
you can see, I'm honeymooning in the office, but the wedding itself was
completely fab. Marrying Paul was the most exciting moment of my whole life,
the venue was ace, we both shook all the way through the ceremony, people
cried, my hair was fantastic (ask Pamela, she's had a photo), I mean, it was
just wonderful. And it was OURS <vbg></FONT></SPAN></DIV>
<DIV><SPAN class=083124612-02042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=083124612-02042003><FONT face=Arial color=#0000ff size=2>I
guess you always think your own will be the best wedding you've been to (and
it was) but so many other people said the same thing that I have to believe it
was a good wedding!</FONT></SPAN></DIV>
<DIV><SPAN class=083124612-02042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=083124612-02042003><FONT face=Arial color=#0000ff size=2>I
can't send photos from here but if anyone wants one, mail me at <A
href="mailto:zora_db@yahoo.com">zora_db@yahoo.com</A> and I'll send one when I
get home tonight.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> William
Hindman [mailto:wdhindman@bellsouth.net] <BR><B>Sent:</B> 02 April 2003
03:54<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] Roz Got Married ...was Updating queries with linked
tables<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>...to heck with queries Roz ...tell us about
the wedding, the honeymoon ...and where the pics are? :))))</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>William Hindman<BR>"War is an ugly thing but not the ugliest of things;
the decayed and degraded state of moral and patriotic feelings which thinks
that nothing is worth war is much worse. A man who has nothing for which he
is willing to fight, nothing which is more important than his own personal
safety, is a miserable creature and has no chance of being free unless made
and kept so by the exertions of better men than himself." John Stuart
Mill <BR></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=roz.clarke@donnslaw.co.uk
href="mailto:roz.clarke@donnslaw.co.uk">Roz Clarke</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:'accessd@databaseadvisors.com'">'accessd@databaseadvisors.com'</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, April 01, 2003 10:52
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Updating
queries with linked tables</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=731115215-01042003><FONT face=Arial color=#0000ff
size=2>No blank record, all fields locked. </FONT></SPAN></DIV>
<DIV><SPAN class=731115215-01042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=731115215-01042003><FONT face=Arial color=#0000ff
size=2>It wouldn't surprise me if this is just a
'feature'.</FONT></SPAN></DIV>
<DIV><SPAN class=731115215-01042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=731115215-01042003><FONT face=Arial color=#0000ff
size=2>R.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Susan
Harkins [mailto:harkins@iglou.com] <BR><B>Sent:</B> 01 April 2003
16:25<BR><B>To:</B> <A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A><BR><B>Subject:</B>
Re: [AccessD] Updating queries with linked tables<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Well, when you say "combine" -- I think of
append or UNION. Relationships "join" records -- nothing wrong with the
way you siad it -- I just thought I'd check to make sure. So here's the
next question -- how do you know it's not updateable? Are you getting an
error message? Is there a blank (new) record at the bottom of the query
in Datasheet View?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT></DIV>
<DIV><BR> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV><SPAN class=133000109-01042003><FONT face=Arial color=#0000ff
size=2>Standard left outer join on staff ID - is there another way?!
</FONT></SPAN></DIV>
<DIV></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=133000109-01042003><FONT face=Arial color=#0000ff>*bangs head on
desk*</FONT></SPAN></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT face=Arial color=#0000ff size=2><SPAN
class=133000109-01042003></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT face=Arial color=#0000ff size=2><SPAN
class=133000109-01042003>R.</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=133000109-01042003></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=133000109-01042003> </SPAN>-----Original
Message-----<BR><B>From:</B> Susan Harkins [mailto:harkins@iglou.com]
<BR><B>Sent:</B> 31-Mar-2003 17:20<BR><B>To:</B> <A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A><BR><B>Subject:</B>
Re: [AccessD] Updating queries with linked
tables<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2>How are you combining your tables?
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>What I'm finding (and I can't believe I
never hit this before) is that although the SQL tables can be
updated through the Access FE, and the local tables can be updated,
combine them and wallop, not updateable. Even if all the key fields
are included in the query.</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"><FONT
face=Arial size=2></FONT> </BLOCKQUOTE></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD
mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>