<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=279342208-03042003><FONT face=Arial color=#0000ff size=2>Thanks
everyone *hugs*, but much as I could chat all day, all WEEK about it, I know not
everyone is so totally enthralled by the topic.</FONT></SPAN></DIV>
<DIV><SPAN class=279342208-03042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN><SPAN class=279342208-03042003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=279342208-03042003><FONT face=Arial color=#0000ff
size=2>Beavered away last night and got the pics set up on our own site - and
lots more of them - at <A
href="http://homepage.ntlworld.com/maxamber/gallery/gallery.htm">http://homepage.ntlworld.com/maxamber/gallery/gallery.htm</A></FONT></SPAN></DIV>
<DIV><SPAN class=279342208-03042003><FONT face=Arial color=#0000ff size=2>The
b&w ones were taken by our friends Sienna & Enzo and are really good
photos. I hope you like it 'cause I missed the football to get it
done!</FONT></SPAN></DIV>
<DIV><SPAN class=279342208-03042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=279342208-03042003><FONT face=Arial color=#0000ff size=2>That's
it from me - if you can stand to hear any more you have my yahoo address and my
msn id is the same.</FONT></SPAN></DIV>
<DIV><SPAN class=279342208-03042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=279342208-03042003><FONT face=Arial color=#0000ff
size=2>Roz</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> Drew Wutka
[mailto:DWUTKA@marlow.com] <BR><B>Sent:</B> 02 April 2003 19:30<BR><B>To:</B>
'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE: [AccessD] OT / Roz Got
Married<BR><BR></FONT></DIV>
<DIV><SPAN class=309182618-02042003><FONT face=Arial color=#0000ff size=2>I
second that. I think part of the 'charm' of the List, is that it's like
a big family.</FONT></SPAN></DIV>
<DIV><SPAN class=309182618-02042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=309182618-02042003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader 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> Wednesday, April 02, 2003
8:54 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] OT / Roz Got Married<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>