Francisco H Tapia
my.lists at verizon.net
Wed Apr 2 11:30:34 CST 2003
Congratulations Roz! Don't start any bound/unbound wars now that you're married ;o). -Francisco http://rcm.netfirms.com On Wednesday, April 02, 2003 5:41 AM [GMT-8], Roz Clarke <roz.clarke at donnslaw.co.uk> wrote: : My dad's very kindly put my sister's snaps on his site : : <http://www.dcs.qmul.ac.uk/~keithc/wedding/> : http://www.dcs.qmul.ac.uk/~keithc/wedding/ : : Roz : : : : -----Original Message----- : From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk] : Sent: 02 April 2003 14:01 : To: 'accessd at databaseadvisors.com' : Subject: RE: [AccessD] Roz Got Married ...was Updating queries with : linke d tables : : : : LOL : : OK I'll tell, but remember I'm supposed to be setting a good example!! : : Pics aren't up anywhere as yet, hopefully we can get that done tonight : before folks lose interest :) : : 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> : : 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! : : I can't send photos from here but if anyone wants one, mail me at : zora_db at yahoo.com <mailto:zora_db at yahoo.com> and I'll send one when I : get home tonight. : : -----Original Message----- : From: William Hindman [mailto:wdhindman at bellsouth.net] : Sent: 02 April 2003 03:54 : To: accessd at databaseadvisors.com : Subject: [AccessD] Roz Got Married ...was Updating queries with linked : tables : : : ...to heck with queries Roz ...tell us about the wedding, the : honeymoon ...and where the pics are? :)))) : : William Hindman : "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 : : : ----- Original Message ----- : From: Roz Clarke <mailto:roz.clarke at donnslaw.co.uk> : To: 'accessd at databaseadvisors.com' : <mailto:'accessd at databaseadvisors.com'> : Sent: Tuesday, April 01, 2003 10:52 AM : Subject: RE: [AccessD] Updating queries with linked tables : : No blank record, all fields locked. : : It wouldn't surprise me if this is just a 'feature'. : : R. : : -----Original Message----- : From: Susan Harkins [mailto:harkins at iglou.com] : Sent: 01 April 2003 16:25 : To: accessd at databaseadvisors.com <mailto:accessd at databaseadvisors.com> : Subject: Re: [AccessD] Updating queries with linked tables : : : 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? : : Susan H. : : : : Standard left outer join on staff ID - is there another way?! : *bangs head on desk* : : R. : : -----Original Message----- : From: Susan Harkins [mailto:harkins at iglou.com] : Sent: 31-Mar-2003 17:20 : To: accessd at databaseadvisors.com <mailto:accessd at databaseadvisors.com> : Subject: Re: [AccessD] Updating queries with linked tables : : : : How are you combining your tables? : : Susan H. : : 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.